Skip to main content

GitHub API docs

Introduction
Getting started
Playground
Migrations
Examples
Recipes
Other runtimes
Dialects
Generating types
Plugin system

Examples
SELECT

SELECT

Short and simple examples of using the select methods

📄️ Select individual columns

A very basic example that selects a subset of table's columns. You can give an alias

📄️ Select all columns

The selectAll method produces a SELECT * statement.

📄️ Select all columns of a table

The selectAll method can also be used to select all columns of a single table.

📄️ Complex selections

Instead of basic columns, this example selects more complex SQL expressions. A key thing to

Select individual columns

Docs

Introduction
Getting started
Playground
Migrations
Generating types

Examples

SELECT
UPDATE
DELETE
INSERT

Community

Discord
Twitter

Other

GitHub
API docs

Sponsors