So I’m dealing with some massive keyword-based ecto queries that I need to optimize with a CTE. I’ve already measured a substantial improvement in using them.
The problem is, these are such huge queries that it’s not practical for me to convert them to function syntax if I don’t have to.
So it seems I can’t use this with keyword syntax:
unsupported :with_cte in keyword query expression. That’s not necessarily a problem because I can do something like the following:
query = with_cte(Model, "stuff", as: ^stuff) from(m in query, ... etc to massive kw-based query)
But the problem with this seems to be that whenever I reference the CTE in a join with keyword syntax, it tries to treat it as an actual table.
... join: s in "stuff" # it thinks this is a table, not my CTE ...
This doesn’t happen when using the function syntax for join. Am I stuck converting this HUGE keyword-based query to the function syntax just so I can use