<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlparse.git/sqlparse/keywords.py, branch 0.4.0</title>
<subtitle>github.com: andialbrecht/sqlparse.git
</subtitle>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/'/>
<entry>
<title>Update copyright notice.</title>
<updated>2020-10-07T06:54:27+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2020-10-07T06:54:27+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=10b0ec24cefc4e2c36a04e1250a0635051071f35'/>
<id>10b0ec24cefc4e2c36a04e1250a0635051071f35</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix splitting when using DECLARE ... HANDLER (fixes #581).</title>
<updated>2020-09-30T07:31:40+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2020-09-30T07:31:40+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=990500a149920b02b2b6e5ffe6e747dea7c6739e'/>
<id>990500a149920b02b2b6e5ffe6e747dea7c6739e</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Don't make parsing of square bracket identifiers too greedy (fixes #583).</title>
<updated>2020-09-30T06:11:53+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2020-09-30T06:11:53+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=cd4a723ee509437166b0f3e0fd62322ecc7bbd99'/>
<id>cd4a723ee509437166b0f3e0fd62322ecc7bbd99</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add RLIKE keyword</title>
<updated>2020-09-30T05:24:23+00:00</updated>
<author>
<name>Will Jones</name>
<email>willjones127@gmail.com</email>
</author>
<published>2020-09-29T00:40:42+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=a887b6d44a69e8a40a325a44635a229c50e3b3bf'/>
<id>a887b6d44a69e8a40a325a44635a229c50e3b3bf</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add postgres WINDOW keyword</title>
<updated>2020-09-30T05:21:06+00:00</updated>
<author>
<name>ali-tny</name>
<email>aliteeney@googlemail.com</email>
</author>
<published>2020-09-26T06:29:40+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=4c570778b2e1c06e8bfcb3c48ae5baeff908fcdf'/>
<id>4c570778b2e1c06e8bfcb3c48ae5baeff908fcdf</id>
<content type='text'>
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 &lt;Identifier 'x WINDOW'&gt;.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
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 &lt;Identifier 'x WINDOW'&gt;.
</pre>
</div>
</content>
</entry>
<entry>
<title>add regex pattern to identify IN as a Compasion token</title>
<updated>2020-09-13T06:58:20+00:00</updated>
<author>
<name>hurcy</name>
<email>cinyoung.hur@gmail.com</email>
</author>
<published>2020-07-29T05:47:47+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=28c4d4026e1d9389a99d8cd627c96fa360c17fc4'/>
<id>28c4d4026e1d9389a99d8cd627c96fa360c17fc4</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Remove support for end-of-life Pythons</title>
<updated>2020-09-01T00:27:38+00:00</updated>
<author>
<name>Jon Dufresne</name>
<email>jon.dufresne@gmail.com</email>
</author>
<published>2020-05-24T13:44:09+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=3e3892f939031d58d98275ce8a237689225d299a'/>
<id>3e3892f939031d58d98275ce8a237689225d299a</id>
<content type='text'>
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 &lt;https://github.com/asottile/pyupgrade&gt;.

The wheel is no longer marked as "universal" as it is now Python 3 only.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
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 &lt;https://github.com/asottile/pyupgrade&gt;.

The wheel is no longer marked as "universal" as it is now Python 3 only.
</pre>
</div>
</content>
</entry>
<entry>
<title>More test cases</title>
<updated>2020-01-16T08:19:34+00:00</updated>
<author>
<name>Corey Zumar</name>
<email>corey.zumar@databricks.com</email>
</author>
<published>2019-12-25T08:22:02+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=101084b790496ae916557f6407be18c4e528f776'/>
<id>101084b790496ae916557f6407be18c4e528f776</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add first test case</title>
<updated>2020-01-16T08:19:34+00:00</updated>
<author>
<name>Corey Zumar</name>
<email>corey.zumar@databricks.com</email>
</author>
<published>2019-12-25T01:25:45+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=6f72de13a3db480ed2909965b6e8cd02ac7fdf7e'/>
<id>6f72de13a3db480ed2909965b6e8cd02ac7fdf7e</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Map like and ilike clauses to comparisons</title>
<updated>2020-01-16T08:19:34+00:00</updated>
<author>
<name>Corey Zumar</name>
<email>corey.zumar@databricks.com</email>
</author>
<published>2019-12-25T00:34:29+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=667aee971aedfca140be8c553f683d831adfc927'/>
<id>667aee971aedfca140be8c553f683d831adfc927</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
