axiom-sqlitedata-ref

Solve advanced SQLiteData query patterns and schema composition in Swift 6.

Updated Dec 23, 2025

Search Tags:#sqlite #swift #sql #cte #grdb #query-patterns #column-groups

Ready to run

npx skills add https://github.com/pradeepmouli/swift-template --skill axiom-sqlitedata-ref-pradeepmouli

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: axiom-sqlitedata-ref
Source: https://github.com/pradeepmouli/swift-template/tree/main/.agents/skills/axiom-sqlitedata-ref
Command: npx skills add https://github.com/pradeepmouli/swift-template --skill axiom-sqlitedata-ref-pradeepmouli

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Solves the need for mastering advanced querying and schema composition in SQLiteData for Swift apps, enabling robust data modeling and high-performance queries.

Core Features & Use Cases

Advanced column grouping with @Selection to reuse column definitions across entities.
Single-table inheritance patterns using @CasePathable @Selection enums to model polymorphic data.
Complex queries with Recursive and non-recursive CTEs, JSON aggregation, and advanced joins for hierarchical data and analytics.
Schema composition and model-level reuse to simplify complex data architectures.

Quick Start

Set up a sample project with Swift 6, strict concurrency, and SQLiteData 1.4+, then implement a small schema using @Selection groups and a recursive CTE to observe patterns.

Frequently Asked Questions about axiom-sqlitedata-ref

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I implement recursive CTEs in SQLiteData using Swift?▼

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.

What is the best way to model single-table inheritance in SQLiteData?▼

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.

Do I need Swift 6 strict concurrency to use @Selection column groups?▼

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.

How do I reuse column definitions across different SQLiteData 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.

Can SQLiteData handle JSON aggregation and advanced joins for analytics?▼

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.

Why use views and aggregates in a shared SQLiteData layer?▼

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.