Comment by grumblingdev

SQL not so good for tree structures. Recursive CTEs are pretty gnarly.

Graphdb would be ideal.