Commenting out a line in SQL should disable parsing for {{ }} for the rest of the line being parsed

commenting a SQL line containing a template causes an error when running a query. Retool still parses the template, despite it being inside a comment causing runtime errors.

select * from my_db
-- where item = {{ some.value }}
^^causes an error

select * from my_db
-- where item = { {some.value}}
^^ no error as no template detected due to space between braces..

+1 for this, I've been caught out by this a couple of times where I comment out part of the query and it gets parsed

Oof, yes. We should definitely fix this! Filed a bug :bug:

1 Like

+1 from me, was just caught out on this.