Syntax highlighting - sql - double apostraphe on strings

[DPetersen257]

Hello,

Hoping someone can point me in the right direction here -

In an app I'm working on, SQL scripts are stored inside XML.
This means that for many of my strings, I have to use double ' rather than single.
This messes with string and char syntax highlighting as it expects 'string' and instead receives ''string'' which causes string to not be highlighted.

Any way to easily add '' as a flag for a string just like ' already is?