To update data in a table, use .updateTable():

await db
  .updateTable('tablename')
  .values({ name: 'test' })
  .where('id', '=', 1)
  .execute()

This corresponds to the SQL query:

UPDATE tablename SET id=1 WHERE name='test';

Lessons in this unit: