My team just started working on a project that will work with hierarchical data. Have you looked into ltree[0] at all? Any thoughts on when that would or would not be beneficial?
Not every of those path queries are easily implemented using recursive CTEs.