Assigned Excecuted SQL as variable

Hello

I'm using an Post API server action which currently takes in a sql query as an input parameter. 

Currently we write the sql straight into the variable, but I would like to write the sql query in the advanced query widget, and then assign the executed SQL to a variable.

Is this possible?

Thanks

Joe

Hi Joe,

First, this isn't possible. The "executed SQL" isn't available runtime. Secondly, I'm not entirely sure why you want to write SQL to a variable, but there's of course a huge security risk if you allow random queries to be executed on the database.