Query Builder

Fluent SQL query builder with parameterized queries.

1 min readEdit this page

SELECT

const users = await db
  .select('id', 'name', 'email')
  .from('users')
  .where('active', true)
  .orderBy('name', 'ASC')
  .limit(10)
  .all()

INSERT

await db.insert('users', { name: 'Tariq', email: 'tariq@restjs.dev' }).execute()

UPDATE

await db.update('users').set({ name: 'Tariq Mehmood' }).where('id', 1).execute()

DELETE

await db.delete('users').where('id', 1).execute()