naise_pos/db/query/users.sql

-- name: CreateUser :one
INSERT INTO users (
  email,
  password,
  fullname
) VALUES ($1, $2, $3)
RETURNING *;

-- name: GetPasswordByEmail :one
SELECT password
FROM users
WHERE email = $1;

-- name: GetUserById :one
SELECT * 
FROM users u 
JOIN merchants m on u.id = m.owner_id
WHERE u.id = $1;

-- name: GetUserByEmail :one
SELECT * 
FROM users u 
JOIN merchants m on u.id = m.owner_id
WHERE email = $1;