I'm running into issues when trying to use a variable in a select statement in a "Query JSON as SQL" query that uses a Google Sheet as the data set. From searching the forums, I saw that "disable converting queries to prepared statements" can be a solution when querying a database, but this option …

Unable to use variables in JSON SQL queries (Google sheets data set)

Tess August 6, 2021, 8:54pm 2

Hi @zp123 could you try using a JS query or transformer instead?

This works for me:

Topic		Replies	Views
Variable in "Query JSON with SQL" does not resolve 💬 App Building query-json-with-sql	4	789	August 28, 2023
Can't query Google sheets where column name is a multi word string 💬 Queries and Resources sql	7	1209	June 18, 2023
Question with SelectValue as ColumnName and "Disable converting queries to prepared statements" 💬 App Building query-json-with-sql	8	1149	August 3, 2023
API + Transformer + SQL query 💬 App Building	5	2506	August 2, 2023
Variables as column names 💬 Queries and Resources	4	4072	August 2, 2023