It would be helpful if you could put a small, indeed minimal, example of tree SQL on that page, including the schema for data and some idea of the syntax, especially showing where the recursion happens (if it happens). The query currently there is not something I want to fight through, but whatever you're doing sounds interesting.

WITH RECURSIVE seems OK https://sqlite.org/lang_with.html