This is not what I need. If I use custom SQL or (that's the same) view on SQL Server side - Tableau will build bad SQL around my custom SQL / view.
I'd like to utilize your schema builder, but completely replace SQL code generator. Is it possible ?
Question is whether this approach will work better (or work at all) across all the connectors we support.
Opportunities is our biggest day-to-day challenge and headache in this space as we try not to go overboard with connections specific tuning as it proven to be a rabbit hole and maintenance nightmare.
p.s. I took a peek at customization page and now wonder what CAP_QUERY_JOIN_REQUIRES_SUBQUERY is for