Child Collection LINQ Query Optimization Phase Next

[jeremydmiller]

There is probably some extra cases where Marten is querying against child collections somehow, someway that force Marten to use CTEs. I think I'd like to propose putting some extra logging in temporarily that calls out CTE queries and the corresponding LINQ query that caused it.

Offhand from poking around, I think we're got opportunities to opt into JSONPath filters to eliminate CTE usage with:

• The filter for string.IsEmptyOrNull() could be a JSONPath check (@oskardudycz just did that, but it popped up as a CTE query)
• string.StartsWith/Contains/EndsWith()? Contains is possible through JSONPath. Not sure about the others, but JSONPath docs are absurdly fragmented
• Intersection queries. See any_filter_honors_tenancy()

I think these are low priorities