If your note's type is JSON (or TW's native dictionary), you can query it as such in filters.

My search problem is that I rely on metadata a lot. It's natural for me to want a UI that renders machine readable metadata in a way that my brain can process and that requires rich querying capabilities.

I tried them all and, so far, TW wins for me, with orgmode being second close (I like orgmode in vim, but it had some fatal rendering flaws and I don’t feel like using emacs just for notes).