We are proud to announce the release of the version 1.5.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:
- Add
MERGE
query - Support “UPSERT” with
ON CONFLICT
clause onINSERT
query - Remove default escape char on LIKE and ILIKE
- Add
GROUPING SETS
,CUBE
, andROLLUP
clauses forGROUP BY
.
python-sql is available on PyPI: python-sql 1.5.0.