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 doesn't exist on a Google sheet.
I'm wondering if there's a solution to this issue?
Here's an example of what I'm talking about:
text1.value = someColumnName
Query:
select {{text1.value}}
from {{googlesheetdataset}}
It will return some JSON that just contains text1.value - the query doesn't run properly.
