-- 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;

-- name: GetPwdById :one
 SELECT pwd
   FROM users
 WHERE id = $1;

-- name: UpdatePwd :exec
 UPDATE users
    SET pwd = $1
  WHERE id = $2;