MySQL, reference textInput.value for table name

[pyrrho]

Try writing the entire statement as a JS query and using an EXEC call to execute it.

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…

return "CREATE PROCEDURE " + {{ textInput1.value }} + "()"

...should get you the statement the way you want it.