Select | Kysely

📄️ A single column

Select a single column:

Select a single column and specify a table:

Select multiple columns:

You can provide an alias for the selections by appending as the_alias to the selection.

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

This example uses the fn module to select some aggregates:

Examples

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