How To Do Full Branch Ancestry Queries With Room?

I tried to shoehorn path enumeration into Room. There are two main filtering use cases: Hiding folder A hides descendants AA, AB, etc. Alternatively selecting a nested keyword '

Solution 1:

This was my solution with the new @RawQuery in 1.1.0:

https://gist.github.com/rcketscientist/4ded9ae64a770ff6929f27b5dbdbe13a