How to add dynamic values to query in workflows

[jg80]

I think you would need to disable prepared statements for the resource. There is some discussion on this in the below link (though for apps, I would guess it works for workflows too). Buyer beware in regards to opening up the danger of SQL injection in doing so.

Replace table names with a temporary variable value

I have many queries on the retool and all query runs a BigQuery SQL and returns data. These all queries contains a single table name, but when I wanted to change a table name I have to do this in all queries which is a bit repetitive process. Is there any way when I have put my table name in a temporary variable and put that variable at place of table names in SQL?

One other thought would be a branch in the code that is used to direct toward one table or another. This would get exceedingly complicated and difficult to maintain if the number of possible tables is large (more than two, IMO ).