Maybe a bug maybe a feature request
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
Any chance we can get support for that?