summaryrefslogtreecommitdiff
path: root/sqlparse/keywords.py
Commit message (Collapse)AuthorAgeFilesLines
* Remove unnecessary parts in regex for bad escaping.Andi Albrecht2023-04-181-2/+2
| | | | | The regex tried to deal with situations where escaping in the SQL to be parsed was suspicious.
* Cleanup regex for detecting keywords (fixes #709).Andi Albrecht2023-03-201-1/+1
|
* lexer documentationSimon Heisterkamp2023-01-021-84/+80
|
* remove type annotations for python 3.5 compatibilitySimon Heisterkamp2023-01-021-6/+0
|
* configurable syntaxSimon Heisterkamp2023-01-021-14/+8
|
* Revert "add regex pattern to identify IN as a Compasion token"Andi Albrecht2022-12-301-1/+1
| | | | | | | | | | | This reverts commit 28c4d4026e1d9389a99d8cd627c96fa360c17fc4. See #694. The expectation is that IN is primarily recognized as a keyword, although it acts as a comparison operator. This also matches the definition of IN in most SQL syntax references where it is listed as a reserved keyword (PostgreSQL: https://www.postgresql.org/docs/current/sql-keywords-appendix.html, MySQL: https://dev.mysql.com/doc/refman/8.0/en/keywords.html, for example).
* Allow any unicode character as identifier name (fixes #641).Andi Albrecht2022-09-101-1/+1
|
* Add docstring and comments.Andi Albrecht2022-09-061-1/+8
|
* Add DISTINCTROW keyword (fixes #677).Andi Albrecht2022-08-241-0/+6
|
* Add regex pattern to identify REGEXP as a Compasion tokenJavierPan2022-08-081-0/+1
|
* added some builtin types that can appear in Spark create table statements.Simon Heisterkamp2022-08-081-0/+4
|
* DIV is OperatorAki Ariga2022-08-081-0/+1
|
* Fix INDICATOR keywordosmnv2022-08-071-1/+1
|
* Fix parsing of scientific numbers (fixes #399).Andi Albrecht2021-07-141-1/+1
|
* keyword, add ON_ERROR_STOPJean-Martin Archer2020-12-121-0/+1
|
* keyword, add CONFLICT to postgres keywordsJean-Martin Archer2020-12-121-0/+1
| | | | As in ON CONFLICT
* Add ELSIF as keyword (fixes #584).Andi Albrecht2020-10-191-0/+1
|
* Fix parsing of backticks (fixes #588).Andi Albrecht2020-10-191-1/+1
| | | | | The backticks in this operator regex was introduced in c794c97531c09e66b6a7ffac76626a727ad02f5e. Pretty sure it was by mistake.
* Update copyright notice.Andi Albrecht2020-10-071-1/+1
|
* Fix splitting when using DECLARE ... HANDLER (fixes #581).Andi Albrecht2020-09-301-1/+1
|
* Don't make parsing of square bracket identifiers too greedy (fixes #583).Andi Albrecht2020-09-301-1/+1
|
* Add RLIKE keywordWill Jones2020-09-301-1/+1
|
* Add postgres WINDOW keywordali-tny2020-09-301-0/+1
| | | | | | | | | | | | | | | Postgres allows statements of the form: ```sql SELECT col_1, col_2, SUM(col_3) OVER w FROM x WINDOW w AS (PARTITION BY col_1 ORDER BY col_2) ``` where the window is defined once at the end of the query (see https://www.postgresql.org/docs/9.5/sql-select.html). This change adds WINDOW as a postgres keyword, preventing queries like the above being misparsed, with table name and WINDOW being grouped into an single identifier <Identifier 'x WINDOW'>.
* add regex pattern to identify IN as a Compasion tokenhurcy2020-09-131-1/+1
|
* Remove support for end-of-life PythonsJon Dufresne2020-08-311-1/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Python 2.7 and 3.4 are end-of-life. They are no longer receiving bug fixes, including for security issues. Python 2.7 went EOL on 2020-01-01 and 3.4 on 2019-03-18. For additional details on support Python versions, see: Supported: https://devguide.python.org/#status-of-python-branches EOL: https://devguide.python.org/devcycle/#end-of-life-branches Removing support for EOL Pythons will reduce testing and maintenance resources while allowing the library to move towards modern Python 3. Using pypinfo, we can show the PyPI download statistics, showing less than 10% of users are using Python 2.7. | python_version | percent | download_count | | -------------- | ------: | -------------: | | 3.7 | 45.36% | 3,056,010 | | 3.6 | 26.46% | 1,782,778 | | 3.8 | 12.22% | 823,213 | | 2.7 | 9.97% | 671,459 | | 3.5 | 5.86% | 394,846 | | 3.4 | 0.10% | 6,700 | | 3.9 | 0.03% | 2,346 | | 2.6 | 0.00% | 57 | | 3.3 | 0.00% | 21 | | 3.10 | 0.00% | 6 | | Total | | 6,737,436 | Library users who continue to use Python 2.7 will still be able to install previous versions of sqlparse. Compatibility shims have been dropped, simplifying the code. Using pyupgrade, the codebase has been updated to take advantage of modern syntax <https://github.com/asottile/pyupgrade>. The wheel is no longer marked as "universal" as it is now Python 3 only.
* More test casesCorey Zumar2020-01-161-1/+1
|
* Add first test caseCorey Zumar2020-01-161-1/+1
|
* Map like and ilike clauses to comparisonsCorey Zumar2020-01-161-1/+1
|
* Code cleanup.Andreas Albrecht2019-10-201-2/+5
|
* support typed literals (if that's what they're called)Dvořák Václav2019-10-201-4/+4
|
* [fix] Addressing issue #507John Bodley2019-10-091-3/+3
|
* Revert "Add in slash comment functionality"Toby Mao2019-06-261-2/+2
| | | | This reverts commit 170010e7d709f2145169d23482d006dc56856256.
* Optimize parsing of literal blocks between dollar signs (fixes #491).Andi Albrecht2019-06-261-1/+1
|
* Add support for time zone casts (fixes #489).Andi Albrecht2019-05-161-1/+1
|
* Identitfy NULLS FIRST/LAST as keywords (fixes #487).Andi Albrecht2019-05-011-0/+1
|
* Added HQL Keywordsmathilde.oustlant2019-03-121-2/+97
|
* Avoid formatting of psql commands (fixes #469).Andi Albrecht2019-03-111-0/+2
|
* [tokenizer] Grouping GROUP/ORDER BYJohn Bodley2019-03-101-0/+2
|
* [keywords] Adding Calcite temporal keywordsJohn Bodley2019-03-101-0/+4
|
* Add in slash comment functionalityIan Robertson2019-03-101-2/+2
|
* Code cleanup.Andreas Albrecht2019-03-101-4/+4
|
* Fix from( parsing issue (fixes #446)Fredy Wijaya2018-12-031-1/+1
|
* Fix reindent issue for parenthesis (fixes issue 427)Fredy Wijaya2018-12-031-1/+1
|
* Update copyright header (fixes #372).Andi Albrecht2018-07-311-1/+2
|
* Add UPSERT keyword (fixes #408).Andi Albrecht2018-07-311-0/+1
|
* Add missing EXPLAIN keyword (fixes #421).Andi Albrecht2018-07-281-0/+1
|
* Fix incorrect splitting with double quotes and a new lineFredy Wijaya2018-03-091-0/+1
|
* Add more Postgres types. [1]Jesse Claven2017-12-181-0/+27
| | | | [1] https://www.postgresql.org/docs/9.5/static/datatype.html#DATATYPE-TABLE
* Fix typostypoVictor Uriarte2017-11-291-2/+2
|
* Merge branch 'master' into masterAndi Albrecht2017-09-211-10/+27
|\