Delete Query Methods

delete()

The delete() method is used to start a DELETE query. In the usual case it doesn't take any arguments, but should be used in conjunction with from() to specify the table, and optionally where(), to select the rows that you want to delete.

await db
  .delete()
  .from('users')
  .where({ id: 12345 })
  .run()
// -> DELETE FROM "users"
//    WHERE "id" = ?

As usual, values can be specified in the where() method, as shown above, or passed to the run() method.

await db
  .delete()
  .from('users')
  .where('id')
  .run([12345])