openSUSE Recommended Update: Recommended update for python-python-sql ______________________________________________________________________________ Announcement ID: openSUSE-RU-2024:0172-1 Rating: moderate References: Affected Products: openSUSE Backports SLE-15-SP5 ______________________________________________________________________________ An update that has 0 recommended fixes can now be installed. 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 Patch Instructions: To install this openSUSE Recommended Update use the SUSE recommended installation methods like YaST online_update or "zypper patch". Alternatively you can run the command listed for your product: - openSUSE Backports SLE-15-SP5: zypper in -t patch openSUSE-2024-172=1 Package List: - openSUSE Backports SLE-15-SP5 (noarch): python3-python-sql-1.5.1-bp155.3.3.1 python311-python-sql-1.5.1-bp155.3.3.1 References: