a Postgres view that recursively finds all children, grand-children, great-grand-children, etc. of a Google Drive folder

scion_view.sql

CREATE VIEW scion_view AS
  WITH RECURSIVE scions(id, scion) AS (
    SELECT c.id, c.child
    FROM children AS c
    UNION ALL
    SELECT s.id, c.child
    FROM children AS c, scions AS s
    WHERE c.id = s.scion)
  SELECT * FROM scions ORDER BY id, scion;