SQLite

    DROP VIEW IF EXISTS paths;
    CREATE VIEW paths AS
    SELECT n1.name AS name
         ,  COALESCE(n6.name || '\','')
         || COALESCE(n5.name || '\','')
         || COALESCE(n4.name || '\','')
         || COALESCE(n3.name || '\','')
         || COALESCE(n2.name || '\','')
         || COALESCE(n1.name       ,'') AS path
         , COALESCE(n6.parent_id
                   ,n5.parent_id
                   ,n4.parent_id
                   ,n3.parent_id
                   ,n2.parent_id
                   ,n1.parent_id) AS last_parent
    FROM files n1
    LEFT JOIN files n2 ON n2.id = n1.parent_id AND n2.isdir = 1
    LEFT JOIN files n3 ON n3.id = n2.parent_id AND n3.isdir = 1
    LEFT JOIN files n4 ON n4.id = n3.parent_id AND n4.isdir = 1
    LEFT JOIN files n5 ON n5.id = n4.parent_id AND n5.isdir = 1
    LEFT JOIN files n6 ON n6.id = n5.parent_id AND n6.isdir = 1
    WHERE n1.isdir = 0