]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
projects / thirdparty / sqlalchemy / sqlalchemy.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f0dc51c) | patch
Add frame exclusion support for window functions
authorVarun Chawla <varun_6april@hotmail.com>
Tue, 24 Feb 2026 14:10:50 +0000 (09:10 -0500)
committerFederico Caselli <cfederico87@gmail.com>
Mon, 16 Mar 2026 20:26:11 +0000 (20:26 +0000)
commit30880dbd8ec1531268eceadef18e997a3c268a93
tree6ab16f16e634ab5a7ff5f713ae0fa8b2329afb22tree | snapshot
parentf0dc51c464dd9468c2faefe3be93836a3b861666commit | diff
Add frame exclusion support for window functions

Add the `exclude` parameter to the `Over` construct and all `.over()`
methods, enabling SQL standard frame exclusion clauses
`EXCLUDE CURRENT ROW`, `EXCLUDE GROUP`, `EXCLUDE TIES`,
`EXCLUDE NO OTHERS` in window functions.
Pull request courtesy of Varun Chawla.

Fixes #11671
Closes: #13117
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13117
Pull-request-sha: 23f9d34dd80c45dff68ecc8c08331acf22b82279

Change-Id: I8efdb06876d5a11a9f5ed9abec2c187c6c9b7e5e
doc/build/changelog/unreleased_21/11671.rst [new file with mode: 0644] blob
lib/sqlalchemy/sql/_elements_constructors.py diff | blob | blame | history
lib/sqlalchemy/sql/compiler.py diff | blob | blame | history
lib/sqlalchemy/sql/elements.py diff | blob | blame | history
lib/sqlalchemy/sql/functions.py diff | blob | blame | history
test/sql/test_compiler.py diff | blob | blame | history
Mirror of https://github.com/sqlalchemy/sqlalchemy.git