Env variables not interpreted inside a SQL comment

Maybe a bug maybe a feature request :slight_smile:

Our org regularly inserts meta information using SQL comments which our system then interprets at runtime. The following SQL does not work in retool, throwing a postgres error (db is postgres but this seems generic to any db):

-- userinfo: {{current_user.email}}
select * from public.v2_people
where
  email ilike {{  '%' + emailSearch.value + '%'  }}
etc...

The first comment line throws "could not determine data type of parameter $1"

Looks like retool interprets its system variables everywhere except in sql comments :frowning:

Any chance we can get support for that?