axiom-sqlitedata-ref

Recursive CTEs in SQLiteData are implemented using complex query patterns to fetch hierarchical data. This Skill provides patterns for executing recursive and non-recursive CTEs alongside advanced joins and JSON aggregation for analytics.

Single-table inheritance in SQLiteData is modeled using @CasePathable @Selection enums to represent polymorphic data. This approach allows entities to share a single database table while maintaining distinct Swift types.

Yes, using @Selection column groups requires Swift 6 with strict concurrency enabled and SQLiteData 1.4 or later. These prerequisites ensure safe data access and allow reusable column definitions across entities.

You reuse column definitions by implementing advanced column grouping with the @Selection property wrapper. This schema composition technique simplifies complex data architectures by sharing column configurations across multiple models.

SQLiteData handles JSON aggregation and advanced joins by utilizing complex query patterns. These features support extracting nested data structures and performing analytics across a shared data layer within Swift applications.

Views and aggregates in a shared SQLiteData layer simplify complex data architectures and enable high-performance queries. They allow you to pre-compute heavy analytical logic and reuse those results across your Swift application.