SQL Reference

Reference documentation for SQLiteNow SQL files, annotations, query generation, and generated APIs.

Core Concepts

Schema Definition

Define tables, indexes, and views with SQL files.

Create Schema

Querying Data

Write SELECT statements and use generated typed query runners.

Query Data

Managing Data

Write INSERT, UPDATE, and DELETE statements with typed parameters.

Manage Data

Initializing Data

Seed a fresh database from init/ SQL files.

Initialize Data

Migrations

Move installed databases between schema versions.

Migrations

Dynamic Fields

Map JOIN-heavy SQL into nested result models.

Dynamic Fields