]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
extend Values from HasCTE
authorMike Bayer <mike_mp@zzzcomputing.com>
Mon, 14 Jul 2025 20:13:03 +0000 (16:13 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Tue, 15 Jul 2025 18:27:01 +0000 (14:27 -0400)
commit209d1913cc702665252f3d2bc1b38ce3a0b9e3eb
treeb00f98f008362eb9df9033edcb3c2434cef62d5b
parentb319787b413794ad8c6d70135a286e664be292f8
extend Values from HasCTE

The :func:`_sql.values` construct gains a new method :meth:`_sql.Values.cte`,
which allows creation of a named, explicit-columns :class:`.CTE` against an
unnamed ``VALUES`` expression, producing a syntax that allows column-oriented
selection from a ``VALUES`` construct on modern versions of PostgreSQL, SQLite,
and MariaDB.

Fixes: #12734
Change-Id: I4a0146418420cce3cbbda4e50f5eb32206dc696b
doc/build/changelog/unreleased_20/12734.rst [new file with mode: 0644]
doc/build/core/selectable.rst
lib/sqlalchemy/sql/_selectable_constructors.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/elements.py
lib/sqlalchemy/sql/selectable.py
lib/sqlalchemy/testing/requirements.py
lib/sqlalchemy/testing/suite/test_cte.py
test/requirements.py
test/sql/test_compare.py
test/sql/test_values.py