Wow that you for taking the time to develop this query! I didn’t realize it would be that complex! I’ll need to spend some time digesting the pieces 
My current workflow will have multiple blocks within each Scene page. I want to be able to keep all the actual text of the scene in a “level 1” block and have comments/tasks/notes/references about each paragraph as child blocks. There isn’t a way to query and determine which order blocks appear in the page/file?
I may need to look into a custom JS plugin for this. I think there’s a get_page_tree() function in the LogSeq API I may be able to use to keep/determine the order.
Is there a way to access the :db/id or :block/file properties in a query? Would these give the page structure/block order?