SQLProviderclass

Abstract database provider that implements CRUD and query operations by generating and executing SQL.

• Subclasses implement exec() to run a query against a concrete database (e.g. SQLite, PostgreSQL).
• The sql* helpers build composable SQLFragment objects so dialect differences can be overridden.
• Realtime subscriptions are unsupported and throw UnimplementedError.

The abstract SQL base provider. SQLProvider implements the DBProvider surface in terms of SQL, leaving one method for concrete subclasses to provide: exec<X>(strings, ...values), which runs a parameterised query and returns rows as plain objects.

Each scalar field in a collection schema maps to a generated column extracted from the data JSON blob, so queries use indexed column comparisons. SQLProvider supports integer (number with step: 1) and string identifiers. Realtime sequences are not supported — getItemSequence / getQuerySequence throw UnimplementedError.

Usage

SQLProvider is abstract — bind it to a driver by implementing exec(). The built-in SQLiteProvider and PostgreSQLProvider extend it with dialect-specific JSON path syntax; concrete drivers live in the shelving/cloudflare and shelving/bun modules.

import { SQLiteProvider } from "shelving/db";

// A concrete subclass implements exec() against a specific driver.
class D1Provider extends SQLiteProvider {
  async exec(strings, ...values) {
    return this.db.prepare(strings.join("?")).bind(...values).all();
  }
}