Set a query on a variable for dbeaver SQL / Multiple line assign variable

Viewed 31

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.

0 Answers
Related