File _patchinfo of Package patchinfo.18420
<patchinfo incident="18420"> <packager>DocB</packager> <rating>moderate</rating> <category>recommended</category> <summary>Recommended update for python-python-sql</summary> <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 </description> </patchinfo>
