goflare/sql/queries/users.sql

-- name: CountUsers :one
SELECT COUNT(*) FROM users;

-- name: GetUserByUsername :one
SELECT * FROM users WHERE username = ?;

-- name: CreateUser :one
INSERT INTO users (username, password_hash)
VALUES (?, ?)
RETURNING *;