Skip to main content

Multiple columns

Select multiple columns:

ts
const persons = await db
  .selectFrom('person')
  .select(['person.id', 'first_name'])
  .execute()
More examples

The API documentation is packed with examples. The API docs are hosted here, but you can access the same documentation by hovering over functions/methods/classes in your IDE. The examples are always just one hover away!

For example, check out these sections: