Getting a dynamically built JS query to execute and return the output

[pyrrho]

Since you are already building the query in a JS Statement, you could try to declare a SQL parameter that is set to the value of that statement, and then EXEC(@theStatement).

Dynamically generated SQL query in Retool

Try doing this as a JavaScript query that returns the statement, declare the statement in your SQL query and then EXEC(theStatement). jsQuery: return "select '111' from dual" SQL: DECLARE @statement NVARCHAR(max) SET @statement = {{jsQuery.data}} EXEC(@statement) I see that you are trying to access a Oracle DB, so you might need to use a different declaration/execute syntax but I've been able to create dynamic queries (sanitized in the query as best as possible). We have made some pretty i…