On mobile so can’t write a full form answer but for these use cases, we’ll build queries programmatically. i.e., cond-> :in and :where.

I got a prototype of this working just before reading this. It’s actually a bit easier than I first anticipated.

@U083D6HK9 do you happen to use this technique to inject authorization constraints onto queries as well? Authorization seems to touch every query in my system, and it occurred to me I might be able to append those rules onto queries using generic helper functions..

We do not, sorry.

No worries, just curious