Can I do recursive / CTE query on convex
Can I do recursive / CTE query on convex?
I ask because I have a file system / document management system set up on convex, where docs are stored with a parentId this makes moves cheap as we build the hierarchy as we navigate but I want to implement metadata filtering based on path prefix, it would be great if there were CTEs available so that I could do a traversal/recursive query to build this automatically rather than all the machinery to maintain it myself. My use-case is full-text and vector search of documents under a given heirarchy path.
I ask because I have a file system / document management system set up on convex, where docs are stored with a parentId this makes moves cheap as we build the hierarchy as we navigate but I want to implement metadata filtering based on path prefix, it would be great if there were CTEs available so that I could do a traversal/recursive query to build this automatically rather than all the machinery to maintain it myself. My use-case is full-text and vector search of documents under a given heirarchy path.
