It's trivial to implement hierarchical data with recursive common table expressions. https://www.sqlite.org/lang_with.html