export declare const authQueries: {
    readonly ownerSelectCount: "SELECT COUNT(*) AS count FROM users WHERE is_owner = 1";
    readonly ownerInsertUser: "INSERT INTO users (id, email, role, is_owner, name, avatar_url, created_at, updated_at) VALUES (?, ?, 'owner', 1, ?, ?, ?, ?)";
    readonly ownerInsertCredential: "INSERT INTO user_credentials (user_id, password_hash, created_at, updated_at) VALUES (?, ?, ?, ?)";
    readonly userSelectOwnerId: "SELECT id AS id FROM users WHERE is_owner = 1 LIMIT 1";
    readonly userSelectByEmail: "SELECT u.id AS id, u.email AS email, c.password_hash AS passwordHash FROM users u INNER JOIN user_credentials c ON c.user_id = u.id WHERE lower(u.email) = lower(?) LIMIT 1";
    readonly userSelectIdByEmail: "SELECT id AS id FROM users WHERE lower(email) = lower(?) LIMIT 1";
    readonly sessionSelectById: "SELECT id AS id, user_id AS userId, expires_at AS expiresAt FROM sessions WHERE id = ? LIMIT 1";
    readonly sessionInsert: "INSERT INTO sessions (id, user_id, created_at, expires_at) VALUES (?, ?, ?, ?)";
    readonly sessionDeleteById: "DELETE FROM sessions WHERE id = ?";
    readonly oauthUpdateUser: "UPDATE users SET email = COALESCE(?, email), name = COALESCE(?, name), avatar_url = COALESCE(?, avatar_url), updated_at = ? WHERE id = ?";
    readonly oauthInsertOwnerUser: "INSERT INTO users (id, email, role, is_owner, name, avatar_url, created_at, updated_at) VALUES (?, ?, 'owner', 1, ?, ?, ?, ?)";
    readonly identitySelectUserId: "SELECT user_id AS userId FROM identities WHERE provider = ? AND provider_user_id = ? LIMIT 1";
    readonly identitySelectLinkedUserIdByProvider: "SELECT user_id AS userId FROM identities WHERE provider = ? LIMIT 1";
    readonly identityUpsert: "INSERT INTO identities (provider, provider_user_id, user_id, email, name, avatar_url, linked_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(provider, provider_user_id) DO UPDATE SET user_id = excluded.user_id, email = excluded.email, name = excluded.name, avatar_url = excluded.avatar_url, updated_at = excluded.updated_at";
};