mirror of
https://github.com/VinGarcia/ksql.git
synced 2025-05-11 09:59:50 +00:00
12 lines
238 B
SQL
12 lines
238 B
SQL
-- name: InsertUser :one
|
|
INSERT INTO users(name, age)
|
|
VALUES ($1, $2) RETURNING id;
|
|
|
|
-- name: GetUser :one
|
|
SELECT id, name, age FROM users
|
|
OFFSET $1 LIMIT 1;
|
|
|
|
-- name: List10Users :many
|
|
SELECT id, name, age FROM users
|
|
OFFSET $1 LIMIT 10;
|