# Release 1.5.0 of python-sql
**URL:** https://discuss.tryton.org/t/release-1-5-0-of-python-sql/7278
**Category:** News
**Tags:** python-sql
**Created:** [May 13, 2024, 5:05pm UTC](https://discuss.tryton.org/t/release-1-5-0-of-python-sql/7278 "2024-05-13T17:05:50Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [May 13, 2024, 5:05pm UTC](https://discuss.tryton.org/t/release-1-5-0-of-python-sql/7278/1 "2024-05-13T17:05:50Z")
We are proud to announce the release of the version 1.5.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:
- Add `MERGE` query
- Support “UPSERT” with `ON CONFLICT` clause on `INSERT` query
- Remove default escape char on LIKE and ILIKE
- Add `GROUPING SETS`, `CUBE`, and `ROLLUP` clauses for `GROUP BY`.
python-sql is available on PyPI: [python-sql 1.5.0](https://pypi.org/project/python-sql/1.5.0/).
---
### Author:  [@coogor](https://discuss.tryton.org/u/coogor)
#### Post date: [May 14, 2024, 8:33am UTC](https://discuss.tryton.org/t/release-1-5-0-of-python-sql/7278/2 "2024-05-14T08:33:12Z")
any reason why the download file is called python\_sql instead of python-sql?
---
### Author:  [@system](https://discuss.tryton.org/u/system)
#### Post date: [June 12, 2024, 5:06pm UTC](https://discuss.tryton.org/t/release-1-5-0-of-python-sql/7278/3 "2024-06-12T17:06:41Z")
This topic was automatically closed after 30 days. New replies are no longer allowed.