sql/users.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

-- name: GetUsers :many
SELECT *
  FROM users;

-- name: GetUserByName :one
SELECT *
  FROM users
 WHERE LOWER(name) = LOWER($1);

-- name: GetUserById :one
SELECT *
  FROM users
 WHERE id = $1;