# Release 1.7.0 of python-sql

**URL:** <https://discuss.tryton.org/t/release-1-7-0-of-python-sql/9157>\
**Category:** News\
**Tags:** python-sql\
**Created:** [March 22, 2026, 9:18am UTC](https://discuss.tryton.org/t/release-1-7-0-of-python-sql/9157 "2026-03-22T09:18:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [March 22, 2026, 9:18am UTC](https://discuss.tryton.org/t/release-1-7-0-of-python-sql/9157/1 "2026-03-22T09:18:06Z")

</div>

We are proud to announce the release of the version 1.7.0 of [python-sql](https://pypi.org/project/python-sql/).

python-sql is a library to write SQL queries in a pythonic way. It is mainly developed for [Tryton](https://www.tryton.org/) but it has no external dependencies and is agnostic to any framework or SQL database.

In addition to bug-fixes, this release contains the following improvements:

- Upgrade to pyproject
- Add support for array operators
- Remove the parentheses around the unary and binary operators
- Use the ordinal number as aliases for GROUP BY
- Check the coherence of the aliases of GROUP BY and ORDER BY expressions
- Do not use parameter for EXTRACT field
- Remove support for Python older than 3.9

python-sql is available on PyPI: [python-sql 1.7.0](https://pypi.org/project/python-sql/1.7.0/).

---

<div class="post-metadata">

**Author:** ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)\
**Post date:** [April 21, 2026, 9:18am UTC](https://discuss.tryton.org/t/release-1-7-0-of-python-sql/9157/2 "2026-04-21T09:18:08Z")

</div>

This topic was automatically closed after 30 days. New replies are no longer allowed.