1-- name: GetModels :many
 2SELECT * FROM models ORDER BY created_at ASC;
 3
 4-- name: GetModel :one
 5SELECT * FROM models WHERE model_id = ?;
 6
 7-- name: CreateModel :one
 8INSERT INTO models (model_id, display_name, provider_type, endpoint, api_key, model_name, max_tokens, tags)
 9VALUES (?, ?, ?, ?, ?, ?, ?, ?)
10RETURNING *;
11
12-- name: UpdateModel :one
13UPDATE models
14SET display_name = ?,
15    provider_type = ?,
16    endpoint = ?,
17    api_key = ?,
18    model_name = ?,
19    max_tokens = ?,
20    tags = ?,
21    updated_at = CURRENT_TIMESTAMP
22WHERE model_id = ?
23RETURNING *;
24
25-- name: DeleteModel :exec
26DELETE FROM models WHERE model_id = ?;