-- sql/regions.sql
-- GENERATED - DO NOT MODIFY. See README.lit
WITH RECURSIVE parent_chain AS (
    SELECT
        id,
        parent_id,
        name,
        CAST([] AS VARCHAR[]) AS path_names
    FROM data
    WHERE id = $1

    UNION ALL

    SELECT
        t.id,
        t.parent_id,
        t.name,
        array_append(pc.path_names, t.name)
    FROM data t
    JOIN parent_chain pc ON t.id = pc.parent_id
    WHERE pc.parent_id != -1
)
SELECT path_names
FROM parent_chain
ORDER BY array_length(path_names) DESC
LIMIT 1;