Queries

JSON style

const adults = await db.table('users').find(u => u.age >= 18)
// or partial-object filter:
const namedAin = await db.table('users').find({ name: 'Ain' })

SQL style (subset)

await db.query("INSERT INTO users(name, age) VALUES('Nisa', 22)")
await db.query("UPDATE users SET age=23 WHERE name='Nisa'")
const rows = await db.query("SELECT * FROM users WHERE age >= 18")
await db.query("DELETE FROM users WHERE name='Nisa'")

Supported statements include:

• CREATE TABLE, DROP TABLE, ALTER TABLE ADD/DROP COLUMN
• CREATE INDEX name ON table(col1, col2) and DROP INDEX
• MERGE, ANALYZE, VACUUM (COMPACT), DESCRIBE
• SELECT/INSERT/UPDATE/DELETE (basic forms)

EXPLAIN <SELECT> is accepted and returns a placeholder plan today.