Syntax highlighting breaks on regular expression

[dragonlobster]

Dataform GCP syntax highlighting is very buggy and problematic. Just one simple example, it breaks the moment you add any regular expression:

select REGEXP_REPLACE(JSON_QUERY(a.json_field, "$.jsonKey"), r'([\'\"])', '') as VALUE
FROM table a
WHERE a.some_field > 1;

This is a screenshot from the GCP editor for Dataform:

Even markdown syntax highlighting gets it right where as dataform can't.

Originally posted by @dragonlobster in https://github.com/dataform-co/dataform/issues/1589#issuecomment-1867137197