Parsing bug in string literal ')\'');a'

[judson-firebolt]

Describe the bug
The following query gets split into two, when it shouldn't be:

SELECT (')\'');a');

To Reproduce

https://sqlformat.org/

SELECT (')\'');a');

Yields:

SELECT (')\'');

a');

Expected behavior
The query should come out unchanged

Versions (please complete the following information):
Python: 3.12.1
sqlparse: 0.5.0

[andialbrecht]

hm... not sure if it's actually a bug... Some SQL dialects allow quoting a single quote by using a backslash (see https://learnsql.com/cookbook/how-to-escape-single-quotes-in-sql/ for examples).

But I think that is ambiguous. I tried the exact statement in DataGrip using a PostgreSQL database. And the returned value was the complete string )\');a. But the syntax highlighting messed it up ;-)
I really don't know how PostgreSQL (in my case) interprets this example as the double single quotes '' can escape a single quote as well.