Note: This is taken from the Chicken Wiki, where a more recent version could be available.

Introduction

This extension provides a record-based front-end to the sqlite3 extension. sqlite3-records writes, prepares, and caches all of the statements needed to efficiently create, read, update, and delete table records. To this it adds functions needed to manage hierarchical (also called parent/child or master/detail) relationships, which are not supported by Sqlite but required for database normalization.

Limitations and Future Work

Currently, only create, read, update, delete, and count queries are supported. Arbitrary aggregate and table-based queries are not yet supported. I expect to add basic support for non-join SQL operations. Additionally, record serialization is not yet supported (but is in progress).