FCModel

Provides full access to raw SQL queries and SQLite features, allowing developers to optimize schemas, indexes, and migrations directly, as emphasized in the philosophy section.

Ensures a single in-memory instance per unique table/primary-key pair, reducing redundancy and simplifying caching, which is highlighted in the retention and caching documentation.

Prioritizes a small footprint and straightforward mental model by avoiding automatic relationship mapping, making it easier to understand than heavier ORMs like Core Data.

Supports random 64-bit integer primary keys or custom keys, offering flexibility without manual key management, as detailed in the schema-to-object mapping examples.