andialbrecht / sqlparse

A non-validating SQL parser module for Python

BSD 3-Clause "New" or "Revised" License

3.71k stars 693 forks source link

allow operators to procede dollar quoted strings #764

Closed proddata closed 7 months ago

proddata commented 8 months ago

Thanks for contributing!

Before submitting your pull request please have a look at the following checklist:

[x] ran the tests (pytest)
[ ] all style issues addressed (flake8)
[x] your changes are covered by tests
[ ] your changes are documented, if needed

Fixes #763 Currently string literals using dollar quoting ($js$mytext$js$) must be preceded by a whitespace character, which prevents e.g. using SET application_name=$$foo;bar$$ which is valid PostgreSQL

amotl commented 7 months ago

Dear @andialbrecht. We are tracking this patch from another issue we are observing on our interactive database shell. Do you see any chance to have a look at it? Thanks in advance, Andreas.

https://github.com/crate/crash/issues/427

andialbrecht commented 7 months ago

Sorry for the delay and thanks for the contribution!