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

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.

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

This works for me: