(SQL) Escaped quotes breaks highlight

[angeljqv]

Describe the issue

Queries with escaped values breaks highlight

but the query is correct and works in the DB.

Which language seems to have the issue?
SQL

Are you using highlight or highlightAuto?

hljs.highlight(my_code, {language: 'sql'})

Sample Code to Reproduce and Expected behavior
https://highlightjs.org/demo#lang=sql&v=1&theme=atom-one-dark&code=c2VsZWN

select 'text"' as `field`; --' work
select 'text\'' as `field`; --'  dont work in highlightjs but works here and on other plugins
select 'text\\'' as `field`; --'  --also try
select 'text\\' as `field`; --'  double backslash is only one on run
select 'text\' as `field`; --'  --this must fail, it's ok

Why

highlight.js/test/markup/sql/string-types.txt

Line 1 in 2ceb591

SELECT '\';

Must be:

[joshgoebel]

Our SQL grammar is for the official SQL spec - we don't care about any popular databases - those need their own grammars. If you can show that it supports this type of escaping then we'd consider a fix.

[angeljqv]

Do you accept contributions to create the mysql language?