"Remove the semicolons from the query"

Problem:
When creating a data explorer query that replaces some HTML entities, I could not save the query because it contained semicolons.

However, these semicolons are not part of the actual DQL syntax and (thus) innocent.

Reproduce: create a query SELECT REPLACE ('argh', '"', '"')

Desired: only complain about semicolons at the end of the query and/or outside of quotes.

Workaround: use chr and concatenation so '&quot' || chr(59) instead of "

3 Likes