-
Goal: I want to run SQL on another query result directly, because I have some base tables doing some complicated joins and I want to do a bunch of things to that same logic without copying the SQL ... and I want to do it with SQL not javascript which seems to be what the transformers are explicitly for.
-
Steps: I've got each part working fine, and can put in a query essentially
SELECT * FROM (
SELECT * FROM baseTable
) AS filteredTable
WHERE etc etc
I'd like to just replace the whole inner part with a query that already has that in it, so it'd be
SELECT * FROM (someQuery)
AS filteredTable
WHERE etc etc
Is that possible? It seems like it'd make code maintenance much easier.