We are proud to announce the release of the version 1.7.0 of python-sql.
python-sql is a library to write SQL queries in a pythonic way. It is mainly developed for Tryton 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.