project/sql/get_top_level_folder.sql

WITH
    permitted as (
        SELECT
            folder_id
        FROM
            permissions
        WHERE
            user_id = $1
    )
SELECT
    folder_id, owner_id, folder_name, created_at
FROM
    folders
WHERE
    folder_id IN (
        SELECT
            folder_id
        FROM
            permitted
    )
    AND parent_folder_id NOT IN (
        SELECT
            folder_id
        FROM
            permitted
    )