feat(backend): create-user command

1 files changed, 14 insertions, 0 deletions

diff --git a/backend/db/queries/users.sql b/backend/db/queries/users.sql
new file mode 100644
index 0000000..99515d5
--- /dev/null
+++ b/backend/db/queries/users.sql
@@ -0,0 +1,14 @@
+-- name: CreateUser :one
+INSERT INTO users (username, password_hash)
+VALUES (?, ?)
+RETURNING *;
+
+-- name: GetUserByUsername :one
+SELECT id, username, password_hash, created_at
+FROM users
+WHERE username = ?;
+
+-- name: GetUserByID :one
+SELECT id, username, password_hash, created_at
+FROM users
+WHERE id = ?;