Update Info

openSUSE-2024-172


Recommended update for python-python-sql


Type: recommended
Severity: moderate
Issued: 2024-06-20
Description:
This update for python-python-sql fixes the following issues:

- update to 1.5.1:
  * Use parameter for start and end of WINDOW FRAME
  * Use parameter for limit and offset

- version 1.5.0
  * naming scheme broken upstream
  * 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.

- update to 1.4.3:
  * Render common table expression in combining query
  * Add support for Python 3.12
  * Restore usage of alias in returning expression
  * Do not use alias in returning expression

- version 1.4.0
  * Use unittest discover
  * Use only column name for INSERT and UPDATE
  * Add escape to Like operators
  * Add default literal ‘*’ expression to Count
  * Add support for Python 3.10

- Version 1.3.0
  * Add GROUPS frame to Window
  * Add exclude to Window
  * Add method for each type of join
  * Remove support for Python older than 3.5
  * Support Select queries in conditionals and functions

- version update to 1.2.2
  Version 1.2.2 - 2021-05-16
  * Escape table and column names containing double quote
  * Use alias on the main table used in UPDATE and INSERT
  * Add support for Python 3.9
  Version 1.2.1 - 2020-10-08
  * Fix AttributeError in Select.params with windows

- Version 1.2.0
  * Add explicit Windows to Select
  * Fix missing Windows definitions in nested expressions


              

References


No references

Packages


  • python-python-sql-1.5.1-bp155.3.3.1