Also the database schema changes very frequently (We’ve had over 400 changes since we released), so there is no way to really document it in a usable and stable way.
I’m the one working on the new searcher so we’ll document the new commands there. So when I do give advice in terms of using a SQL query for now, I always go back and see if I can find a way to make that a direct search term instead.
So if you do have some powerful search feature that you would like, please post it on here, and I’ll see if I can help you with a SQL search for now, and add it a formal search in the future.
(It will still support SQL queries like the above since there is just no way to plan every possibility up front, but it may be a slightly different outer syntax).