CRUD

// INSERT
await db.table('users').insert({ name: 'Sari', age: 28 })

// UPSERT (same as insert; primary key auto-generated if absent)
await db.table('users').upsert({ id: 'u-2', name: 'Sari', age: 29 })

// FIND
const all = await db.table('users').find()
const exact = await db.table('users').find({ name: 'Sari' })
const byFn = await db.table('users').find(u => u.age > 20)

// DELETE
const removed = await db.table('users').delete({ name: 'Sari' })
console.log(removed, 'row(s) removed')

SQL equivalents

await db.query("INSERT INTO users(name,age) VALUES('Sari',28)")
await db.query("UPDATE users SET age=29 WHERE name='Sari'")
await db.query("DELETE FROM users WHERE name='Sari'")
const rows = await db.query("SELECT * FROM users WHERE age > 20")