[magnat]

How would you query such structure to retrieve elements in-order?

[netghost]

Your best solution would probably be to use a recursive CTE if your DB supported it, but as a sibling post mentioned, it's probably not a good approach.