I was trying to save a query on a variable like:
WITH auxiliar AS (
SELECT var1
FROM table
)
SELECT *
FROM aux
but instead save the first part on a variable:
@set auxiliar =
SELECT var1
FROM table
SELECT *
FROM (${auxiliar}) AS aux
but the second option does not work on several lines
The only way for it to work is with:
@set auxiliar = SELECT var1 FROM table
SELECT *
FROM (${auxiliar}) AS aux
But I'd like to know if it is possible to use some kind of brackets so I can write it on several lines.