Queries

Start a query from a table of a Db, such as db.form, and await it to execute it:

const forms = await db.form.where({ published: true }).select("id", "name")
// forms: { id: string; name: string }[]

A method never changes the query it is called on, so a query can be extended in several ways without affecting the others.

Guides

• Selecting: choose the fields of records, take one row, get plain values, count rows and compute other aggregates, check whether rows exist, load several queries at once, or convert results in code.
• Filtering: find records by column values, operators, related records, values of other queries, and SQL conditions.
• Operators: see which operators each type has for conditions and computed values.
• Sorting and Pagination: sort rows by columns, expressions, and related records, and get them page by page.
• Grouping: compute the aggregates of groups of rows, filter the groups by them, and sort by them.
• Related Records: load the related records of each row in the same query.
• Expressions: replace NULL, take the largest or the smallest of several values, choose a value by conditions, select a constant, or define an expression once and reuse it across queries.
• Inserting, Updating, and Deleting: change records and get the fields of the changed ones.
• Composing Queries: add clauses conditionally, or define them once and reuse them across queries of a table.
• Reusable Queries: define a query once and execute it in several places, also with a Db known only at runtime.
• SQL Statements: run SQL that queries do not cover, such as an upsert, get its rows, or run a script of several statements.