root_genres (view)

45 rows

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE VIEW root_genres AS
WITH RECURSIVE split(label, str) AS (
    SELECT
        '',
        genre || '-'
    FROM starting_list
    UNION ALL
    SELECT
        substr(str, 0, instr(str, '-')) as label,
        substr(str, instr(str, '-') + 1) as str
    FROM split
    WHERE str != ''
)
SELECT
    DISTINCT label
FROM split
WHERE label != ''
ORDER BY label;