Splitting statements now allows to remove the semicolon at the end.
Some database backends love statements without semicolon (issue742).
Support TypedLiterals in get_parameters (pr649, by Khrol).
Improve splitting of Transact SQL when using GO keyword (issue762).
Support for some JSON operators (issue682).
Improve formatting of statements containing JSON operators (issue542).
Support for BigQuery and Snowflake keywords (pr699, by griffatrasgo).
Support parsing of OVER clause (issue701, pr768 by r33s3n6).
Bug Fixes
Ignore dunder attributes when creating Tokens (issue672).
Allow operators to precede dollar-quoted strings (issue763).
Fix parsing of nested order clauses (issue745, pr746 by john-bodley).
Thread-safe initialization of Lexer class (issue730).
Classify TRUNCATE as DDL and GRANT/REVOKE as DCL keywords (based on pr719
by josuc1, thanks for bringing this up!).
Fix parsing of PRIMARY KEY (issue740).
Other
Optimize performance of matching function (pr799, by admachainz).
Release 0.4.4 (Apr 18, 2023)
Notable Changes
IMPORTANT: This release fixes a security vulnerability in the
parser where a regular expression vulnerable to ReDOS (Regular
Expression Denial of Service) was used. See the security advisory
for details: https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-rrm6-wvj7-cwh2
The vulnerability was discovered by @erik-krogh from GitHub
Security Lab (GHSL). Thanks for reporting!
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
- `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency
- `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/kostrykin/tournaments/network/alerts).
Bumps sqlparse from 0.4.2 to 0.5.0.
Changelog
Sourced from sqlparse's changelog.
... (truncated)
Commits
ddbd0ec
Bump version.29f2e0a
Raise recursion limit for tests.b4a39d9
Raise SQLParseError instead of RecursionError.f1bcf2f
Update AUHTORS and Changelog.e03b74e
Fix Function.get_parameters(), add Funtion.get_window()617b8f6
Add OVER clause, and group it into Function (fixes #701)d8f8147
Update AUHTORS and Changelog.012c9f1
Optimize sqlparse.utils.imt().46971e5
Fix parsing of PRIMARY KEY (fixes #740).fc4b0be
Code cleanup.Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase
.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show