Another way to create tables (equivalent to "create table" queries")

Execute a query and return many results

Execute a query without results

Execute a query with a single result

Execute a query that has no argument, and returns the latest query result (shortcut for .prepare(cmd).bind().executeAll())

Progressively executes a query that has no argument, yielding results until the end of enumeration (or an exception) (shortcut for .prepare(cmd).bind().iterate())

Prepare a query

Get a table in this db to inspect it

List all tables in this schema

Register a function

Register a binary operator

Register a simple type, which is equivalent to another

Register a simple type, which is equivalent to another

Get an existing type

Registers an enum type on this schema

Database migration, node-sqlite flavor ⚠ Only working when runnin nodejs !

Intecept queries. If your interceptor returns an array, then the query will not be executed. The given result will be returned instead.