OK it's worse than I thought - we can basically move the filtering we're doing here into the service, but there's no benefit to doing this in the query at all as-is, AFAICT.

So, is it better to have the filtering on the service-side and have a lower cache hit rate, or leave as-is (and fix the TCBS caching if it is not in fact working correctly, as I suspect it might not be)?