2e3f1df55c- update to 0.5.3: * EXTENSION is now recognized as a keyword (issue785). * SQL hints are not removed when removing comments (issue262, by skryzh).
devel
Dirk Mueller2025-02-24 10:02:54 +00:00
00f141a556Accepting request 1194657 from devel:languages:python
Ana Guerrero
2024-08-20 14:12:48 +00:00
d650f16849- 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).Dirk Mueller2024-08-19 07:44:02 +00:00
a070a8f675- 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.
Steve Kowalik
2024-05-07 02:22:41 +00:00
302070b8d2- 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).Matej Cepl2023-05-25 16:30:01 +00:00
890239637bAccepting request 1007717 from devel:languages:pythonRichard Brown2022-10-04 18:37:14 +00:00
2e479a6918- 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.Dirk Mueller2022-10-03 16:02:44 +00:00
da538c5371- 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 patchDirk Mueller2020-11-26 08:44:08 +00:00
7b6436d15d- Add stdout-encoding-set.patch to use sys.stdout.reconfigure() if the stream is an instance of TextIOWrapper to support a pytest change.
Steve Kowalik
2020-03-24 02:46:35 +00:00
85757991a1- Add stdout-encoding-set.patch to use sys.stdout.reconfigure() for Python 3.
Steve Kowalik
2020-03-23 06:36:48 +00:00
46ded828ef- 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).Dirk Mueller2020-03-09 16:23:34 +00:00
Dominique Leuenberger
Dirk Mueller
Ana Guerrero
Steve Kowalik
Robert Schweikert
Matej Cepl
Richard Brown
Markéta Machová
Tomáš Chvátal
Thomas Bechtold
Denisart Benjamin
Stephan Kulow
Sascha Peilicke