SELECT | Kysely

📄️A single column

Select a single column:

Select a single column and specify a table:

Select multiple columns:

You can give an alias for selections and tables by appending as the_alias to the name:

You can select arbitrary expression including subqueries and raw sql snippets.

Sometimes you can be sure something's not null, but Kysely isn't able to infer

This example shows how to create function calls. These examples also work in any

The API documentation is packed with examples. The API docs are hosted here,

The API documentation is packed with examples. The API docs are hosted here,

The selectAll method generates SELECT *:

Select all columns of a table:

While kysely is not an ORM and it doesn't have the concept of relations, we do provide

While kysely is not an ORM and it doesn't have the concept of relations, we do provide

A generic type-safe helper function for finding a row by a column value: