🎉 Initial Release #

Core Builder API

• db.table(name) — Extension method on Database that returns a QueryBuilder.
• Fluent method chaining: every builder method returns this.
• All values are automatically bound as ? parameters — complete SQL Injection protection.

SELECT

• select(columns) — choose specific columns
• selectDistinct(columns) — add DISTINCT modifier
• selectRaw(expression) — embed raw SQL expressions

WHERE — 12 variants

• where(column, operator, value) — basic AND condition
• orWhere(column, operator, value) — OR condition
• whereIn(column, values) — IN (?, ...) clause
• whereNotIn(column, values) — NOT IN (?, ...) clause
• whereBetween(column, start, end) — BETWEEN ? AND ?
• whereNotBetween(column, start, end) — NOT BETWEEN ? AND ?
• whereNull(column) — IS NULL
• whereNotNull(column) — IS NOT NULL
• whereNested(callback) — nested AND group (...)
• orWhereNested(callback) — nested OR group (...)
• whereRaw(sql, bindings) — raw SQL fragment
• orWhereRaw(sql, bindings) — raw SQL fragment with OR

JOIN

• join(table, first, op, second) — INNER JOIN
• leftJoin(table, first, op, second) — LEFT JOIN
• crossJoin(table) — CROSS JOIN

ORDER BY

• orderBy(column, {descending}) — ASC / DESC
• orderByDesc(column) — shorthand for DESC
• inRandomOrder() — ORDER BY RANDOM()

GROUP BY / HAVING

• groupBy(column) — GROUP BY
• having(expression, operator, value) — HAVING
• havingRaw(expression) — raw HAVING expression

LIMIT / OFFSET / PAGINATION

• limit(n) — LIMIT n
• offset(n) — OFFSET n
• paginate({page, perPage}) — automatic LIMIT + OFFSET from page number
• forPage({page, perPage}) — alias for paginate

Terminal — READ

• get() — all matching rows
• getAs(mapper) — typed row list
• first() — first row or null
• firstAs(mapper) — typed first row or null
• firstOrFail() — first row or RecordNotFoundException
• firstOrFailAs(mapper) — typed first row or throws
• value(column) — single column value
• pluck(column) — flat list of one column
• chunk(size, callback) — chunked processing

Terminal — AGGREGATES

• count([column]) — COUNT
• max(column) — MAX
• min(column) — MIN
• avg(column) — AVG
• sum(column) — SUM
• exists() — boolean existence check
• doesntExist() — inverse of exists()

Terminal — WRITE

• insert(data) — insert row, returns new id
• insertOrIgnore(data) — INSERT OR IGNORE
• upsert(data) — INSERT OR REPLACE
• insertMany(rows) — batch insert via sqflite Batch
• update(data) — update rows (requires WHERE)
• updateAll(data) — update all rows (no WHERE required)
• increment(column, {by, extra}) — atomic increment
• decrement(column, {by, extra}) — atomic decrement
• delete() — delete rows (requires WHERE)
• truncate() — delete all rows

Safety Guards

• DangerousOperationException thrown on update() / delete() without WHERE
• InvalidOperatorException thrown on unsupported operator strings
• UnsupportedDialectFeatureException thrown on SQLite-incompatible features (e.g. RIGHT JOIN)

Debug

• toSql() — inspect generated SQL
• toSqlWithBindings() — inspect SQL + bindings

Transactions

• db.transactionSafe(callback) — extension method returning QueryTransaction
• QueryTransaction.table(name) — full builder API within transaction

Schema System (optional)

• TableSchema — abstract class for declarative table definitions
• ColumnDefinition — typed column builder with all SQLite constraints
• IndexDefinition — typed index declarations
• TableSchema.toCreateSql() — generates CREATE TABLE IF NOT EXISTS ...
• TableSchema.toDropSql() — generates DROP TABLE IF EXISTS ...
• TableSchema.allCreateStatements() — table + all indexes

Column Types

• ColumnDefinition.integer(name) — INTEGER
• ColumnDefinition.text(name) — TEXT
• ColumnDefinition.real(name) — REAL
• ColumnDefinition.blob(name) — BLOB
• ColumnDefinition.boolean(name) — INTEGER (0/1)
• ColumnDefinition.dateTime(name) — TEXT (ISO 8601)
• ColumnDefinition.json(name) — TEXT (JSON string)
• ColumnDefinition.numeric(name) — NUMERIC

Column Modifiers

• .primaryKey(), .autoIncrement(), .notNull(), .nullable(), .unique()
• .withDefault(value), .defaultValue(value), .defaultNow(), .defaultExpression(expr)
• .references(table, column, {onDelete, onUpdate}) — foreign key
• .check(expression) — CHECK constraint

Migration System

• MigrationRunner — tracks applied versions in _migrations meta-table
• db.migrations.runAll(list) — run all pending migrations
• db.migrations.isApplied(version) — check status
• db.migrations.rollbackLast() — remove last applied version
• db.migrations.appliedVersions() — full set of applied versions
• Migration(version, up, {down, description}) — migration definition

Typed Result Extensions

• QueryResultExtension.getAs(mapper) — typed list
• QueryResultExtension.firstAs(mapper) — typed first
• QueryResultExtension.firstOrFailAs(mapper) — typed first or throws
• QueryResultExtension.getIndexedBy(keyColumn, mapper) — lookup map
• QueryResultExtension.groupedBy(keyColumn, mapper) — grouped map
• QueryResultExtension.paginateAs(page, perPage, mapper) — PaginatedResult<T>
• PaginatedResult — data + total + lastPage + hasNextPage + hasPrevPage

Type Conversion

• TypeConverter.toSqlite(value) — Dart → SQLite (bool, DateTime, Enum)
• TypeConverter.toBool(value) — SQLite INTEGER → bool
• TypeConverter.toDateTime(value) — ISO TEXT → DateTime
• TypeConverter.toEnum(value, values) — TEXT → Enum
• TypeConverter.toInt, toDouble, toText helpers

Configuration & Logging

• SqlLiteBuilderConfig.configure(...) — global config
• SqlLiteLogger — debug-mode-only logger (stripped in release)

Database Extension Helpers

• db.tableExists(name) — check table existence
• db.columnExists(table, column) — check column existence
• db.rowCount(table) — quick count
• db.setForeignKeys(enabled) — toggle FK enforcement
• db.vacuum() — optimize database file
• db.getUserVersion(), db.setUserVersion(v) — user_version pragma

---

• Pre-release development snapshot
• Core builder, WHERE, compiler, and parameter binder