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