@typed-sql/sqlite

The stable SQLite grammar for typed-sql. It provides sound inference for SQLite's dynamic type system, schema introspection, and an optional application-owned node:sqlite adapter.

pnpm add @typed-sql/core @typed-sql/sqlite
pnpm add -D @typed-sql/cli [email protected]

import { sql, typePolicy } from "@typed-sql/sqlite";
import { createNodeSqliteDatabase } from "@typed-sql/sqlite/node-sqlite";

const query = sql`
  SELECT account.id, account.email
  FROM account
  WHERE account.id = ${42n}
`;

const database = await createNodeSqliteDatabase({ path: "app.db", typePolicy });
const accounts = await database.execute(query);
await database.close();

The package root has no database-driver dependency. /node-sqlite loads the built-in Node module only when the application selects that adapter. STRICT tables receive precise declared types; ordinary SQLite tables use a storage-class union because their declared affinity does not constrain the values they may contain.

The package is on the stable release track. The grammar follows typed-sql's general Node.js range; the optional adapter checks its narrower supported Node and bundled-SQLite matrix when loaded.

MIT © typed-sql contributors