CREATE VIEW parent_of
AS
SELECT id, ancestor AS parent_id, isdir, name
FROM nodes
JOIN closures ON descendant = id AND pathlength = 1;