HN-like selfhosted forums
-- name: GetUser :oneSELECT * FROM users WHERE id = $1;-- name: GetUserByUsername :oneSELECT * FROM users WHERE lower(username) = lower(sqlc.arg(username)::text);-- name: NewUser :oneINSERT INTO users (username, email, passwd_hash)VALUES ($1, $2, $3)RETURNING *;-- name: GetUserByLogin :oneSELECT * FROM usersWHERE lower(email) = lower(sqlc.arg(login)::text) OR lower(username) = lower(sqlc.arg(login)::text);