- update to 0.5.5:
* Fix DoS protection to raise SQLParseError instead of silently
returning None when grouping limits are exceeded (issue827).
* Fix splitting of BEGIN TRANSACTION statements (issue826).
* Add support for Python 3.14.
* Add type annotations to top-level API functions and include
py.typed marker for PEP 561 compliance, enabling type checking
with mypy and other tools
* Add pre-commit hook support. sqlparse can now be used as a
pre-commit hook to automatically format SQL files. The CLI now
supports multiple files and an `--in-place` flag for in-place
editing (issue537).
* Add `ATTACH` and `DETACH` to PostgreSQL keywords (pr808).
* Add `INTERSECT` to close keywords in WHERE clause (pr820).
* Support `REGEXP BINARY` comparison operator (pr817).
* Add additional protection against denial of service attacks
when parsing very large lists of tuples. This enhances the
existing recursion protections with configurable limits for
token processing to prevent DoS through algorithmic complexity
attacks. The new limits
* MAX_GROUPING_TOKENS=10000) can be adjusted or disabled (by
setting to None) if needed for legitimate large SQL statements.
* Remove shebang from cli.py and remove executable flag
* Fix strip_comments not removing all comments when input
contains only comments (issue801, pr803 by stropysh).
* Fix splitting statements with IF EXISTS/IF NOT EXISTS inside
BEGIN...END blocks (issue812).
* Fix splitting on semicolons inside BEGIN...END blocks
(issue809).
OBS-URL: https://build.opensuse.org/request/show/1329526
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-sqlparse?expand=0&rev=22
* Fix DoS protection to raise SQLParseError instead of silently
returning None
* when grouping limits are exceeded (issue827).
* Fix splitting of BEGIN TRANSACTION statements (issue826).
* Add support for Python 3.14.
* Add type annotations to top-level API functions and include
py.typed marker for PEP 561 compliance, enabling type checking
with mypy and other tools
* Add pre-commit hook support. sqlparse can now be used as a
pre-commit hook to automatically format SQL files. The CLI now
supports multiple files and an `--in-place` flag for in-place
editing (issue537).
* Add `ATTACH` and `DETACH` to PostgreSQL keywords (pr808).
* Add `INTERSECT` to close keywords in WHERE clause (pr820).
* Support `REGEXP BINARY` comparison operator (pr817).
* Add additional protection against denial of service attacks
when parsing very large lists of tuples. This enhances the
existing recursion protections with configurable limits for
token processing to prevent DoS through algorithmic complexity
attacks. The new limits
* MAX_GROUPING_TOKENS=10000) can be adjusted or disabled (by
setting to None) if needed for legitimate large SQL statements.
* Remove shebang from cli.py and remove executable flag
* Fix strip_comments not removing all comments when input
contains only comments (issue801, pr803 by stropysh).
* Fix splitting statements with IF EXISTS/IF NOT EXISTS inside
BEGIN...END blocks (issue812).
* Fix splitting on semicolons inside BEGIN...END blocks
(issue809).
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=44
- update to 0.5.1:
* New "compact" option for formatter. If set, the formatter
tries to produce a more compact output by avoiding some line
breaks
* The strip comments filter was a bit greedy and removed too
much whitespace (issue772). Note: In some cases you might want
to add `strip_whitespace=True` where you previously used just
`strip_comments=True`. `strip_comments` did some of the
work that `strip_whitespace` should do.
* Fix error when splitting statements that contain multiple
CASE clauses within a BEGIN block (issue784).
* Fix whitespace removal with nested expressions (issue782).
* Fix parsing and formatting of ORDER clauses containing NULLS
FIRST or NULLS LAST (issue532).
OBS-URL: https://build.opensuse.org/request/show/1194657
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-sqlparse?expand=0&rev=19
* New "compact" option for formatter. If set, the formatter
tries to produce a more compact output by avoiding some line
breaks
* The strip comments filter was a bit greedy and removed too
much whitespace (issue772). Note: In some cases you might want
to add `strip_whitespace=True` where you previously used just
`strip_comments=True`. `strip_comments` did some of the
work that `strip_whitespace` should do.
* Fix error when splitting statements that contain multiple
CASE clauses within a BEGIN block (issue784).
* Fix whitespace removal with nested expressions (issue782).
* Fix parsing and formatting of ORDER clauses containing NULLS
FIRST or NULLS LAST (issue532).
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=38
- Update to 0.5.0:
* Notable Changes
+ Drop support for Python 3.5, 3.6, and 3.7.
+ Python 3.12 is now supported.
+ IMPORTANT: Fixes a potential denial of service attack (DOS) due to
recursion error for deeply nested statements.
(CVE-2024-2430, bsc#1223603)
* Enhancements:
+ Splitting statements now allows to remove the semicolon at the end.
Some database backends love statements without semicolon.
+ Support TypedLiterals in get_parameters.
+ Improve splitting of Transact SQL when using GO keyword.
+ Support for some JSON operators.
+ Improve formatting of statements containing JSON operators.
+ Support for BigQuery and Snowflake keywords.
+ Support parsing of OVER clause.
* Bug Fixes
+ Ignore dunder attributes when creating Tokens.
+ Allow operators to precede dollar-quoted strings.
+ Fix parsing of nested order clauses.
+ Thread-safe initialization of Lexer class.
+ Classify TRUNCATE as DDL and GRANT/REVOKE as DCL keywords.
+ Fix parsing of PRIMARY KEY.
* Other
+ Optimize performance of matching function.
OBS-URL: https://build.opensuse.org/request/show/1172288
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-sqlparse?expand=0&rev=18
* Notable Changes
+ Drop support for Python 3.5, 3.6, and 3.7.
+ Python 3.12 is now supported.
+ IMPORTANT: Fixes a potential denial of service attack (DOS) due to
recursion error for deeply nested statements.
(CVE-2024-2430, bsc#1223603)
* Enhancements:
+ Splitting statements now allows to remove the semicolon at the end.
Some database backends love statements without semicolon.
+ Support TypedLiterals in get_parameters.
+ Improve splitting of Transact SQL when using GO keyword.
+ Support for some JSON operators.
+ Improve formatting of statements containing JSON operators.
+ Support for BigQuery and Snowflake keywords.
+ Support parsing of OVER clause.
* Bug Fixes
+ Ignore dunder attributes when creating Tokens.
+ Allow operators to precede dollar-quoted strings.
+ Fix parsing of nested order clauses.
+ Thread-safe initialization of Lexer class.
+ Classify TRUNCATE as DDL and GRANT/REVOKE as DCL keywords.
+ Fix parsing of PRIMARY KEY.
* Other
+ Optimize performance of matching function.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=36
- Update to 0.4.4:
* 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 (CVE-2023-30608, bsc#1210617,
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!
* Revert a change from 0.4.0 that changed IN to be a comparison
(issue694). The primary expectation is that IN is treated as
a keyword and not as a comparison operator. That also follows
the definition of reserved keywords for the major SQL syntax
definitions.
* Fix regular expressions for string parsing.
* sqlparse now uses pyproject.toml instead of setup.cfg
(issue685).
OBS-URL: https://build.opensuse.org/request/show/1089053
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-sqlparse?expand=0&rev=15
* 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 (CVE-2023-30608, bsc#1210617,
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!
* Revert a change from 0.4.0 that changed IN to be a comparison
(issue694). The primary expectation is that IN is treated as
a keyword and not as a comparison operator. That also follows
the definition of reserved keywords for the major SQL syntax
definitions.
* Fix regular expressions for string parsing.
* sqlparse now uses pyproject.toml instead of setup.cfg
(issue685).
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=29
- update to 0.4.3:
* Add support for DIV operator.
* Add support for additional SPARK keywords.
* Avoid tokens copy.
* Add REGEXP as a comparision.
* Add DISTINCTROW keyword for MS Access.
* Improve parsing of CREATE TABLE AS SELECT.
* Fix spelling of INDICATOR keyword.
* Fix formatting error in EXTRACT function.
* Fix bad parsing of create table statements that use lower case.
* Handle backtick as valid quote char.
* Allow any unicode character as valid identifier name.
OBS-URL: https://build.opensuse.org/request/show/1007717
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-sqlparse?expand=0&rev=14
* Add support for DIV operator.
* Add support for additional SPARK keywords.
* Avoid tokens copy.
* Add REGEXP as a comparision.
* Add DISTINCTROW keyword for MS Access.
* Improve parsing of CREATE TABLE AS SELECT.
* Fix spelling of INDICATOR keyword.
* Fix formatting error in EXTRACT function.
* Fix bad parsing of create table statements that use lower case.
* Handle backtick as valid quote char.
* Allow any unicode character as valid identifier name.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=27
- update to 0.4.1:
* Python 3.9 support
* Remove support for end-of-life Python 2.7 and 3.4. Python 3.5+ is now
required.
* Remaining strings that only consist of whitespaces are not treated as
statements anymore. Code that ignored the last element from
sqlparse.split() should be updated accordingly since that function
now doesn't return an empty string as the last element in some
cases (issue496).
- remove non-upstream stdout-encoding-set.patch patch
OBS-URL: https://build.opensuse.org/request/show/850920
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-sqlparse?expand=0&rev=11
* Python 3.9 support
* Remove support for end-of-life Python 2.7 and 3.4. Python 3.5+ is now
required.
* Remaining strings that only consist of whitespaces are not treated as
statements anymore. Code that ignored the last element from
sqlparse.split() should be updated accordingly since that function
now doesn't return an empty string as the last element in some
cases (issue496).
- remove non-upstream stdout-encoding-set.patch patch
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=22
- update to v0.3.1:
* Add HQL keywords (pr475, by matwalk).
* Add support for time zone casts (issue489).
* Enhance formatting of AS keyword (issue507, by john-bodley).
* Stabilize grouping engine when parsing invalid SQL statements.
* Fix splitting of SQL with multiple statements inside
parentheses (issue485, pr486 by win39).
* Correctly identify NULLS FIRST / NULLS LAST as keywords (issue487).
* Fix splitting of SQL statements that contain dollar signs in
identifiers (issue491).
* Remove support for parsing double slash comments introduced in
0.3.0 (issue456) as it had some side-effects with other dialects and
doesn't seem to be widely used (issue476).
* Restrict detection of alias names to objects that acutally could
have an alias (issue455, adopted some parts of pr509 by john-bodley).
* Fix parsing of date/time literals (issue438, by vashek).
* Fix initialization of TokenList (issue499, pr505 by john-bodley).
* Fix parsing of LIKE (issue493, pr525 by dbczumar).
* Improve parsing of identifiers (pr527 by liulk).
OBS-URL: https://build.opensuse.org/request/show/783018
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-sqlparse?expand=0&rev=9
* Add HQL keywords (pr475, by matwalk).
* Add support for time zone casts (issue489).
* Enhance formatting of AS keyword (issue507, by john-bodley).
* Stabilize grouping engine when parsing invalid SQL statements.
* Fix splitting of SQL with multiple statements inside
parentheses (issue485, pr486 by win39).
* Correctly identify NULLS FIRST / NULLS LAST as keywords (issue487).
* Fix splitting of SQL statements that contain dollar signs in
identifiers (issue491).
* Remove support for parsing double slash comments introduced in
0.3.0 (issue456) as it had some side-effects with other dialects and
doesn't seem to be widely used (issue476).
* Restrict detection of alias names to objects that acutally could
have an alias (issue455, adopted some parts of pr509 by john-bodley).
* Fix parsing of date/time literals (issue438, by vashek).
* Fix initialization of TokenList (issue499, pr505 by john-bodley).
* Fix parsing of LIKE (issue493, pr525 by dbczumar).
* Improve parsing of identifiers (pr527 by liulk).
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=17
- Update to 0.2.4:
* Add more keywords for MySQL table options (pr328, pr333, by phdru).
* Add more PL/pgSQL keywords (pr357, by Demetrio92).
* Improve parsing of floats (pr330, by atronah).
* Fix parsing of MySQL table names starting with digits (issue337).
* Fix detection of identifiers using comparisons (issue327).
* Fix parsing of UNION ALL after WHERE (issue349).
* Fix handling of semicolon in assignments (issue359, issue358).
- Use fdupes and %license
- Remove shebangs from non-executable python files
OBS-URL: https://build.opensuse.org/request/show/631122
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=11
- update to 0.2.3:
* New command line option "--encoding" (by twang2218, pr317).
* Support CONCURRENTLY keyword (issue322, by rowanseymour).
* Fix some edge-cases when parsing invalid SQL statements.
* Fix indentation of LIMIT (by romainr, issue320).
* Fix parsing of INTO keyword (issue324).
* Several improvements regarding encodings.
* Add comma_first option: When splitting list "comma first" notation
is used (issue141).
* Fix parsing of incomplete AS (issue284, by vmuriart).
* Fix parsing of Oracle names containing dollars (issue291).
* Fix parsing of UNION ALL (issue294).
* Fix grouping of identifiers containing typecasts (issue297).
* Add Changelog to sdist again (issue302).
* `is_whitespace` and `is_group` changed into properties
- convert to singlespec
OBS-URL: https://build.opensuse.org/request/show/509611
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-sqlparse?expand=0&rev=9
