Re:SQLite now allows multiple recursive SELECT statements in...
by nitely on Wednesday October 21, 2020 @03:08AM
(#24845429)
One application not mention in this thread is to traverse trees, like in the old forums where you had many levels of categories/subcategories. AKA hierarchical query. SQLite already has support for this[0]. It seems they are supporting multiple selects now.
[0] https://sqlite.org/lang_with.html