]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/log
thirdparty/sqlalchemy/sqlalchemy.git
7 days agonarrow scope of _correct_for_mysql_bugs_88718_96365 rel_2_0
Mike Bayer [Mon, 20 Apr 2026 13:30:35 +0000 (09:30 -0400)] 
narrow scope of _correct_for_mysql_bugs_88718_96365

Narrowed the scope of the internal workaround for MySQL bugs `#88718
<https://bugs.mysql.com/bug.php?id=88718>`_ and `#96365
<https://bugs.mysql.com/bug.php?id=96365>`_ so that it is only applied
where needed: MySQL 8.0.1 through 8.0.13 (where bug 88718 is present), and
on systems with ``lower_case_table_names=2`` (where bug 96365 applies,
typically macOS).  Previously the workaround was applied unconditionally
for all MySQL 8.0+ versions, which caused a ``KeyError`` during foreign key
reflection when the database user lacked SELECT privileges on referred
tables.

Fixes: #13243
Change-Id: I7c29f67d1653c5cd32f29e098f038fea1d56117b
(cherry picked from commit 530e1f71e74263ee9e23245071af2557aa65d425)

7 days agodocs: fix typo 'nad' -> 'and' in DefaultDialect.construct_arguments docstring (#13245)
Bojun Chai [Mon, 20 Apr 2026 20:30:20 +0000 (04:30 +0800)] 
docs: fix typo 'nad' -> 'and' in DefaultDialect.construct_arguments docstring (#13245)

Co-authored-by: Bojun Chai <bojunchai@microsoft.com>
(cherry picked from commit 053a90668acd235cc03b5209470e24c9742121db)

10 days agohandle asyncpg InternalClientError
Mike Bayer [Fri, 17 Apr 2026 20:13:53 +0000 (16:13 -0400)] 
handle asyncpg InternalClientError

Fixed issue where the asyncpg driver could throw an insufficiently-handled
exception ``InternalClientError`` under some circumstances, leading to
connections not being properly marked as invalidated.

Fixes: #13241
References: https://github.com/MagicStack/asyncpg/issues/1069
Change-Id: Iaaf551b3d7b062cce62e13b441161583a484615f
(cherry picked from commit 70de8780239972233fe2b7b4121251698bbf19ca)

11 days agoFix 'compatiblity' typo in sqlite dialect docstring (#13237)
Mukunda Rao Katta [Thu, 16 Apr 2026 18:56:30 +0000 (11:56 -0700)] 
Fix 'compatiblity' typo in sqlite dialect docstring (#13237)

Co-authored-by: MukundaKatta <mukundakatta@users.noreply.github.com>
(cherry picked from commit 1f27a0deefd86c14fd2de3b80e24aeb00c154da7)

13 days agoImprove pg two-phase transactions
Federico Caselli [Mon, 13 Apr 2026 21:53:00 +0000 (23:53 +0200)] 
Improve pg two-phase transactions

Improve handling of two phase transaction identifiers for PostgreSQL
when the identifier is provided by the user.
As part of this change the psycopg dialect was updated to use the DBAPI
two phase transaction API instead of executing the SQL directly.

Fixes: #13229
Change-Id: If8301a7253b4a0c88e5323c9a052c3a9fa258780
(cherry picked from commit 08cef20f4a2bfbeda61abfe6caee975190f0794c)

2 weeks agoImprove escaping in pysqlcipher
Federico Caselli [Mon, 13 Apr 2026 20:26:48 +0000 (22:26 +0200)] 
Improve escaping in pysqlcipher

Escape key and pragma values when utilizing the pysqlcipher dialect.

Fixes: #13230
Change-Id: I7583577a3e00e2f2986e50f32136a9ef005eb28a
(cherry picked from commit 87f17c2e59cd27e20e7badc685c482e788fb2711)

3 weeks agoVersion 2.0.50 placeholder
Mike Bayer [Fri, 3 Apr 2026 16:38:35 +0000 (12:38 -0400)] 
Version 2.0.50 placeholder

3 weeks ago- 2.0.49 rel_2_0_49
Mike Bayer [Fri, 3 Apr 2026 16:34:12 +0000 (12:34 -0400)] 
- 2.0.49

3 weeks agocorrect that last exclude, only the greenlet builds
Mike Bayer [Fri, 3 Apr 2026 16:19:52 +0000 (12:19 -0400)] 
correct that last exclude, only the greenlet builds

Change-Id: I6944fdbf6c96b2b462bc91040bc347f9736c754a

3 weeks agodisable failing actions combos so we can get a green
Mike Bayer [Fri, 3 Apr 2026 16:02:03 +0000 (12:02 -0400)] 
disable failing actions combos so we can get a green

Change-Id: I120b14b03f6baeff67be7195a07f47e29e67ba84

3 weeks agoMerge "really remove cx_oracle from test setup" into rel_2_0
Michael Bayer [Wed, 1 Apr 2026 20:28:19 +0000 (20:28 +0000)] 
Merge "really remove cx_oracle from test setup" into rel_2_0

3 weeks agoreally remove cx_oracle from test setup
Mike Bayer [Wed, 1 Apr 2026 20:10:17 +0000 (16:10 -0400)] 
really remove cx_oracle from test setup

in 6282bcef11781b5ded26d48b22b5f we tried to disable cx_oracle
testing bug failed because pyproject was still pulling it in.
really fix this time

Change-Id: If5a46bf1ad9a9ee48e8693cccdc4b8b40cee392d

3 weeks agoupdate for mypy 1.20.0
Mike Bayer [Wed, 1 Apr 2026 18:31:21 +0000 (14:31 -0400)] 
update for mypy 1.20.0

Change-Id: I95f72b8a1818b79d01d26531202199f24fe3b808
(cherry picked from commit 120eb13e8e08d167fafd56590aaeb3c048f7afcc)

4 weeks agoaccommodate subclass mapper in post-loader entity_isa check
Mike Bayer [Sun, 29 Mar 2026 17:46:39 +0000 (13:46 -0400)] 
accommodate subclass mapper in post-loader entity_isa check

Fixed issue where using chained loader options such as
:func:`_orm.selectinload` after :func:`_orm.joinedload` with
:meth:`_orm.PropComparator.of_type` for a polymorphic relationship would
not properly apply the chained loader option. The loader option is now
correctly applied when using a call such as
``joinedload(A.b.of_type(poly)).selectinload(poly.SubClass.c)`` to eagerly
load related objects.

Fixes: #13209
Change-Id: I2d14838f1b1a9a2b18dc52137910dab0bccf0dd5
(cherry picked from commit 2ac8c1a7c71400c1bc13f54f3c05cfd2e3ae1442)

4 weeks agoMerge "fix: Session.get() with with_for_update=False skips identity map" into rel_2_0
Michael Bayer [Sun, 29 Mar 2026 17:10:16 +0000 (17:10 +0000)] 
Merge "fix: Session.get() with with_for_update=False skips identity map" into rel_2_0

4 weeks agoapply _path_with_polymorphic in prepend as well
Mike Bayer [Fri, 27 Mar 2026 18:24:10 +0000 (14:24 -0400)] 
apply _path_with_polymorphic in prepend as well

Fixed issue where using :meth:`_orm.Load.options` to apply a chained loader
option such as :func:`_orm.joinedload` or :func:`_orm.selectinload` with
:meth:`_orm.PropComparator.of_type` for a polymorphic relationship would
not generate the necessary clauses for the polymorphic subclasses. The
polymorphic loading strategy is now correctly propagated when using a call
such as ``joinedload(A.b).options(joinedload(B.c.of_type(poly)))`` to match
the behavior of direct chaining e.g.
``joinedload(A.b).joinedload(B.c.of_type(poly))``.

Fixes: #13202
Change-Id: I7b2ce2dd10a7f8583ff99495b0a65fa1a895ee29
(cherry picked from commit d3a8d4950e7f1c1cfcabc819e4b85f0bba61e26d)

4 weeks agofix: Session.get() with with_for_update=False skips identity map
joshuaswanson [Fri, 27 Mar 2026 16:41:11 +0000 (12:41 -0400)] 
fix: Session.get() with with_for_update=False skips identity map

Fixes #13176.

`Session.get()` checks `with_for_update is None` to decide whether to look up the identity map. Passing `with_for_update=False` fails this check and always hits the database, even though `ForUpdateArg._from_argument` already treats `False` and `None` identically (both return `None`). Changed to `with_for_update in (None, False)` to match.

Closes: #13199
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13199
Pull-request-sha: c639b8723888947317598df387c5e3e4d87acac4

Change-Id: I0584873f46099afadcdd760c0a267ae4d30528eb
(cherry picked from commit d466d375889ee266ef928b6fbb6d673bda6beeb1)

5 weeks agoMerge "detect and accommodate reverse condition for loader strategy" into rel_2_0
Michael Bayer [Mon, 23 Mar 2026 21:21:59 +0000 (21:21 +0000)] 
Merge "detect and accommodate reverse condition for loader strategy" into rel_2_0

5 weeks agolink insert.value to data insert tutorial
Federico Caselli [Mon, 23 Mar 2026 20:59:23 +0000 (21:59 +0100)] 
link insert.value to data insert tutorial

Change-Id: I892fd7357f88c0e8d16e8e6fb74f18f4541ff795
(cherry picked from commit a0baf90b2ee7f21f1f17e27851cb4fc3cc47e3ef)

5 weeks agodetect and accommodate reverse condition for loader strategy
Mike Bayer [Mon, 23 Mar 2026 18:13:02 +0000 (14:13 -0400)] 
detect and accommodate reverse condition for loader strategy

Fixed issue where chained :func:`_orm.joinedload` options would not be
applied correctly when the final relationship in the chain is declared on a
base mapper and accessed through a subclass mapper in a
:func:`_orm.with_polymorphic` query. The path registry now correctly
computes the natural path when a property declared on a base class is
accessed through a path containing a subclass mapper, ensuring the loader
option can be located during query compilation.

Fixes: #13193
Change-Id: I9ec83a0f184caed2bf6dd087b20c3538d6c23597
(cherry picked from commit 5f7e29fb4657367d8b02bd5d56ad28807b9df691)

5 weeks agomssql: fall back to base type for alias types during reflection
Carlos Serrano [Wed, 18 Mar 2026 15:37:08 +0000 (11:37 -0400)] 
mssql: fall back to base type for alias types during reflection

Fixed regression from version 2.0.42 caused by :ticket:`12654` where the
updated column reflection query would receive SQL Server "type alias" names
for special types such as ``sysname``, whereas previously the base name
would be received (e.g. ``nvarchar`` for ``sysname``), leading to warnings
that such types could not be reflected and resulting in :class:`.NullType`,
rather than the expected :class:`.NVARCHAR` for a type like ``sysname``.
The column reflection query now joins ``sys.types`` a second time to look
up the base type when the user type name is not present in
:attr:`.MSDialect.ischema_names`, and both names are checked in
:attr:`.MSDialect.ischema_names` for a match. Pull request courtesy Carlos
Serrano.

Fixes: #13181
Fixes: #13182
Closes: #13178
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13178
Pull-request-sha: be5c3850594665c0154ae215d4f9c322cc5a3f5a

Change-Id: I7fe86b80dfa45b208f7d97003ee5b1df3f07bfe7
(cherry picked from commit 1c78168f8a1a9cd3c88f1977bba1bac763225482)

5 weeks agoMerge "Remove version warning in SQL Server" into rel_2_0
Michael Bayer [Fri, 20 Mar 2026 19:25:05 +0000 (19:25 +0000)] 
Merge "Remove version warning in SQL Server" into rel_2_0

5 weeks agoMerge "Allow escaped quotes in Postgres quoted identifier" into rel_2_0
Michael Bayer [Fri, 20 Mar 2026 19:23:43 +0000 (19:23 +0000)] 
Merge "Allow escaped quotes in Postgres quoted identifier" into rel_2_0

5 weeks agoremove cx_oracle from testing
Mike Bayer [Thu, 19 Mar 2026 00:21:20 +0000 (20:21 -0400)] 
remove cx_oracle from testing

cx_oracle is no longer able to build from its .tar.gz form
reliably because it does not include setuptools in its build
dependencies.   It still can be built if pip is given
--no-build-isolation, or if a wheel file is installed rather than
the .tar.gz, but given how quickly cx_oracle has been pushed
aside by oracledb it's not really that important to be testing
it anymore.

Change-Id: I8a4b2cffabe5275a0df88b5a624ecd6379d84d37
(cherry picked from commit 6282bcef11781b5ded26d48b22b5fac8d2eebd61)

5 weeks agoAdd typing overloads to Query.__getitem__ and AppenderQuery.__getitem__
medovi40k [Sat, 28 Feb 2026 23:10:17 +0000 (18:10 -0500)] 
Add typing overloads to Query.__getitem__ and AppenderQuery.__getitem__

Fixes #13128

### Description
`Query.__getitem__` and `AppenderQuery.__getitem__` previously returned Union[_T, List[_T]] for all inputs, making the return type inaccurate.
Added `@overload` signatures so that integer index returns _T and slice returns List[_T].

This pull request is:

- [x] A documentation / typographical / small typing error fix
- Good to go, no issue or tests are needed

Closes: #13142
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13142
Pull-request-sha: 9ba1f0145d90b18c997137aeba7fde72dac23a7c

Change-Id: Ib37ab63d3d844491c34cc5ccfc4efc1591a1878c
(cherry picked from commit 8af25c2b35f3740a00e2551c65f9ba245e6f5a9d)

5 weeks agoAllow escaped quotes in Postgres quoted identifier
Austin Graham [Wed, 18 Mar 2026 14:57:13 +0000 (10:57 -0400)] 
Allow escaped quotes in Postgres quoted identifier

<!-- Provide a general summary of your proposed changes in the Title field above -->

### Description
Issue: https://github.com/sqlalchemy/sqlalchemy/issues/10902

Hello! This is my first PR here, so please let me know what I may have missed in terms of having a valuable contribution. I was looking through issues to grab an easy first one, and found this. Looks like someone else was going to have a go at it, but never did.

I simply added a small change to the FK regex in for Postgres that allows anything not quotes alongside escaped double quotes. Test is included for the scenario mentioned in the issue. Alongside that, I didn't see a test for general quoted strings, so I added another one that includes spaces and dashes, in my experience common things to be used inside quoted identifiers.

A manual test as well:
DB setup:
```
austin_test_bug=# CREATE TABLE """test_parent_table-quoted""" (id SERIAL PRIMARY KEY, val INTEGER);
CREATE TABLE
austin_test_bug=# CREATE TABLE test_child_table_ref_quoted (id SERIAL, parent INTEGER, CONSTRAINT fk_parent FOREIGN KEY (parent) REFERENCES """test_parent_table-quoted"""(id));
CREATE TABLE
austin_test_bug=# \d+
                                                     List of relations
 Schema |                Name                |   Type   |  Owner   | Persistence | Access method |    Size    | Description
--------+------------------------------------+----------+----------+-------------+---------------+------------+-------------
 public | "test_parent_table-quoted"         | table    | postgres | permanent   | heap          | 0 bytes    |
 public | "test_parent_table-quoted"_id_seq  | sequence | postgres | permanent   |               | 8192 bytes |
 public | test_child_table_ref_quoted        | table    | postgres | permanent   | heap          | 0 bytes    |
 public | test_child_table_ref_quoted_id_seq | sequence | postgres | permanent   |               | 8192 bytes |
(4 rows)

```

And the python:
```
>>> from sqlalchemy import create_engine, inspect
>>> engine = create_engine('postgresql://scott:tiger@localhost:5432/austin_test_bug')
>>> connection = engine.connect()
>>> inspect(connection).get_multi_foreign_keys()
{(None, '"test_parent_table-quoted"'): [], (None, 'test_child_table_ref_quoted'): [{'name': 'fk_parent', 'constrained_columns': ['parent'], 'referred_schema': None, 'referred_table': '"test_parent_table-quoted"', 'referred_columns': ['id'], 'options': {}, 'comment': None}]}
```

### Checklist
<!-- go over following points. check them with an `x` if they do apply, (they turn into clickable checkboxes once the PR is submitted, so no need to do everything at once)

-->

This pull request is:

- [ ] A documentation / typographical / small typing error fix
- Good to go, no issue or tests are needed
- [x] A short code fix
- please include the issue number, and create an issue if none exists, which
  must include a complete example of the issue.  one line code fixes without an
  issue and demonstration will not be accepted.
- Please include: `Fixes: #<issue number>` in the commit message
- please include tests.   one line code fixes without tests will not be accepted.
- [ ] A new feature implementation
- please include the issue number, and create an issue if none exists, which must
  include a complete example of how the feature would look.
- Please include: `Fixes: #<issue number>` in the commit message
- please include tests.

**Have a nice day!**

Fixes: #10902
Closes: #13179
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13179
Pull-request-sha: 8890dc3250a30fc62b8f15cd1da1353b81524c00

Change-Id: I185c2cb062740551ab931368de602054eb5a4acd
(cherry picked from commit c7412ac909125db873b9ddff0dafb8d92034d0a7)

5 weeks agoRemove version warning in SQL Server
Federico Caselli [Wed, 18 Mar 2026 19:45:39 +0000 (20:45 +0100)] 
Remove version warning in SQL Server

Remove warning for SQL Server dialect when a new version is detected.
The warning was originally added more than 15 years ago due to an unexpected
value returned when using an old version of FreeTDS.
The assumption is that since then the issue has been resolved, so make the
SQL Server dialect behave like the other ones that don't have an upper bound
check on the version number.

This effectively reverts 64d92c836ce029e33b57bcabd4ca76944549e022
that was added for #1825

Fixes: #13185
Change-Id: I79c6951b2fbb6da2caefca97dc3e1b9d8f48f0ab
(cherry picked from commit f5e4c2bcaa27cf1e1e73e5fc8d4ca19180954ae8)

5 weeks agoclarify the Result.closed attribute
Mike Bayer [Wed, 18 Mar 2026 19:30:54 +0000 (15:30 -0400)] 
clarify the Result.closed attribute

document that Result.returns_rows is usually what people
want when they are looking for this.

References: #13184
Change-Id: Ia0b23e7482115bca3f93d20e21e53598aa9d084c
(cherry picked from commit 4840e6a206741eb7fe54e47067f61a57dd36c68d)

5 weeks agoMerge "ensure function classes are not shadowed" into rel_2_0
Michael Bayer [Wed, 18 Mar 2026 15:01:48 +0000 (15:01 +0000)] 
Merge "ensure function classes are not shadowed" into rel_2_0

5 weeks agoensure function classes are not shadowed
Federico Caselli [Thu, 12 Mar 2026 22:34:27 +0000 (23:34 +0100)] 
ensure function classes are not shadowed

Ensure the _FunctionGenerator method do not shadow the function class
of the same name

Fixed a typing issue where the typed members of :data:`.func` would return
the appropriate class of the same name, however this creates an issue for
typecheckers such as Zuban and pyrefly that assume :pep:`749` style
typechecking even if the file states that it's a :pep:`563` file; they see
the returned name as indicating the method object and not the class object.
These typecheckers are actually following along with an upcoming test
harness that insists on :pep:`749` style name resolution for this case
unconditionally.  Since :pep:`749` is the way of the future regardless,
differently-named type aliases have been added for these return types.

Fixes: #13167
Change-Id: If58a3858001c78ab21b2ed343205dfd9ce868576
(cherry picked from commit 0a185a3bb6347719ffab60012db8fbbc23eb29e4)

6 weeks agoUpdate _NamingSchemaCallable to support Index
Martin Baláž [Mon, 9 Mar 2026 17:19:04 +0000 (13:19 -0400)] 
Update _NamingSchemaCallable to support Index

<!-- Provide a general summary of your proposed changes in the Title field above -->

### Description
<!-- Describe your changes in detail -->
According to [the documentation](https://docs.sqlalchemy.org/en/21/core/metadata.html#sqlalchemy.schema.MetaData.params.naming_convention), the values associated with user-defined “token” keys in `naming_convention` should be callables of the form `fn(constraint, table)`, which accepts the constraint/index object and Table. However, the type alias `_NamingSchemaCallable` accepts only constraint in the first argument. I propose to update `_NamingSchemaCallable` to accept also an index.

### Example
```python
import sqlalchemy

def include_0_N_name(
schema_item: sqlalchemy.Index | sqlalchemy.Constraint,
table: sqlalchemy.Table,
) -> str:
tokens = []

for column in schema_item.dialect_options.get('postgresql', {}).get('include', []):
tokens.append("_")
tokens.append(column.name)

return "".join(tokens)

metadata = sqlalchemy.MetaData(
naming_convention={
"include_0_N_name": include_0_N_name,
"ix": "%(table_name)s_%(column_0_N_name)s%(include_0_N_name)s_idx",
"uq": "%(table_name)s_%(column_0_N_name)s%(include_0_N_name)s_key",
"fk": "%(table_name)s_%(column_0_N_name)s%(include_0_N_name)s_fkey",
"pk": "%(table_name)s_pkey",
},
)
```

### Checklist
<!-- go over following points. check them with an `x` if they do apply, (they turn into clickable checkboxes once the PR is submitted, so no need to do everything at once)

-->

This pull request is:

- [x] A documentation / typographical / small typing error fix
- Good to go, no issue or tests are needed
- [ ] A short code fix
- please include the issue number, and create an issue if none exists, which
  must include a complete example of the issue.  one line code fixes without an
  issue and demonstration will not be accepted.
- Please include: `Fixes: #<issue number>` in the commit message
- please include tests.   one line code fixes without tests will not be accepted.
- [ ] A new feature implementation
- please include the issue number, and create an issue if none exists, which must
  include a complete example of how the feature would look.
- Please include: `Fixes: #<issue number>` in the commit message
- please include tests.

Closes: #13161
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13161
Pull-request-sha: cf53bd722932741bceaba1dd16a52ba93ff579cc

Change-Id: I0daf8a6eeb458aaa09f3392e00d98c27dbf8ca3c
(cherry picked from commit 2513bc65721a7651adb711b075b31f81d4b10343)

7 weeks agodocs: fix RelationshipProperty comparator cross-references (#13155)
Dr Alex Mitre [Fri, 6 Mar 2026 21:57:04 +0000 (15:57 -0600)] 
docs: fix RelationshipProperty comparator cross-references (#13155)

(cherry picked from commit 1eff7bbc96014e6d0d6f0ac4d11c29c5ad187f22)

7 weeks agoAdd fast_executemany property to asyncadapt aioodbc cursor
Georg Sieber [Wed, 4 Mar 2026 23:24:44 +0000 (18:24 -0500)] 
Add fast_executemany property to asyncadapt aioodbc cursor

Enhanced the ``aioodbc`` dialect to expose the ``fast_executemany``
attribute of the pyodbc cursor.   This allows the ``fast_executemany``
parameter to work with the ``mssql+aioodbc`` dialect.   Pull request
courtesy Georg Sieber.

Fixes: #13152
Closes: #13151
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13151
Pull-request-sha: c25aa581afff6d49af74b3d7b58b9635a23556e9

Change-Id: I6f27600b509f4881769ecca944fc0939e26626e6
(cherry picked from commit f09778c70050391ab77e97e8043083f6a5177038)

7 weeks agoOracle dialect reflection of RAW length
Daniel Sullivan [Tue, 3 Mar 2026 20:50:17 +0000 (15:50 -0500)] 
Oracle dialect reflection of RAW length

Fixed issue in Oracle dialect where the :class:`_oracle.RAW` datatype would
not reflect the length parameter.   Pull request courtesy Daniel Sullivan.

Fixes: #13150
Closes: #13149
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13149
Pull-request-sha: f7488faaf86451dfe53801faa848414c343614b3

Change-Id: I7db0219b6484317de15203b42f9ca5a84fe36bb7
(cherry picked from commit ddfec399ce63403a48d7185c2b5938ab4db27a5a)

8 weeks agoVersion 2.0.49 placeholder
Mike Bayer [Mon, 2 Mar 2026 15:29:07 +0000 (10:29 -0500)] 
Version 2.0.49 placeholder

8 weeks ago- 2.0.48 rel_2_0_48
Mike Bayer [Mon, 2 Mar 2026 14:39:42 +0000 (09:39 -0500)] 
- 2.0.48

8 weeks agofix changelog typo
Mike Bayer [Mon, 2 Mar 2026 14:38:02 +0000 (09:38 -0500)] 
fix changelog typo

Change-Id: I08ffdc1eda8921745e0459ca375e154ac3cf8b9d
(cherry picked from commit d7132e9562caf8eb542d4ca6a4bef65fde747c1d)

8 weeks agomake local mutable copies for cargs / cparams in do_connect
Mike Bayer [Sun, 1 Mar 2026 18:05:21 +0000 (13:05 -0500)] 
make local mutable copies for cargs / cparams in do_connect

Fixed a critical issue in :class:`.Engine` where connections created in
conjunction with the :meth:`.ConnectionEvents.do_connect` event listeners
would receive shared, mutable collections for the connection arguments,
leading to a variety of potential issues including unlimited growth of the
argument list as well as elements within the parameter dictionary being
shared among concurrent connection calls.  In particular this could impact
do_connect routines making use of complex mutable authentication
structures.

Fixes: #13144
Change-Id: I1549dae36e8e7e6cf50fdaf796659b53e7b78234
(cherry picked from commit dfb1c49cd7306eeca49fd7bb7ec4bcbef0e68d79)

2 months agoVersion 2.0.48 placeholder
Mike Bayer [Tue, 24 Feb 2026 16:38:55 +0000 (11:38 -0500)] 
Version 2.0.48 placeholder

2 months ago- 2.0.47 rel_2_0_47
Mike Bayer [Tue, 24 Feb 2026 16:21:39 +0000 (11:21 -0500)] 
- 2.0.47

2 months agofix an idiosyncratic F821 failure
Mike Bayer [Tue, 24 Feb 2026 16:03:24 +0000 (11:03 -0500)] 
fix an idiosyncratic F821 failure

this fail only occurs:

1. with python 3.13 (maybe earlier also?)
2. in the 2.0 branch.   identical code is in main and does not fail
(identical flake8 settings too)

can't narrow down why this one occurs but it's failing
GH actions so just patch it

Change-Id: Ib1655856e0363b9dc365e093a86eecc75e5d783c

2 months agoFix WeakSequence.__getitem__ catching KeyError instead of IndexError
Kadir Can Ozden [Sat, 21 Feb 2026 11:35:38 +0000 (06:35 -0500)] 
Fix WeakSequence.__getitem__ catching KeyError instead of IndexError

### Description

`WeakSequence.__getitem__` catches `KeyError` but the internal `_storage` is a `list`, which raises `IndexError` for out-of-range access. This means the `except KeyError` handler never executes, and the custom error message is never shown.

### Current behavior

```python
def __getitem__(self, index):
    try:
        obj = self._storage[index]  # _storage is a list
    except KeyError:  # lists don't raise KeyError
        raise IndexError("Index %s out of range" % index)
    else:
        return obj()
```

On an out-of-range index, the raw `IndexError` from list access propagates directly (e.g., `list index out of range`) instead of the intended custom message.

### Fix

Changed `except KeyError` to `except IndexError` so the handler actually catches the exception raised by list indexing.

Closes: #13136
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13136
Pull-request-sha: ceb8f9fe46590ec69686769f6736686789c88986

Change-Id: Ia36c2b9b0f3aec97624bcd2a9e49f43b9ed786d9
(cherry picked from commit 0f74af5c339d7f3a6412537571aa60c0180be426)

2 months agoMysql ddl compiler fall back to default index args
Tiansu Yu [Fri, 20 Feb 2026 14:20:40 +0000 (09:20 -0500)] 
Mysql ddl compiler fall back to default index args

Fixed issue where DDL compilation options were registered to the hard-coded
dialect name ``mysql``. This made it awkward for MySQL-derived dialects
like MariaDB, StarRocks, etc. to work with such options when different sets
of options exist for different platforms. Options are now registered under
the actual dialect name, and a fallback was added to help avoid errors when
an option does not exist for that dialect. Pull request courtesy Tiansu Yu.

Fixes: #13134
Closes: #13138
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13138
Pull-request-sha: 1bc953a2a1be97f82cdbbbc0d8961361716190fa

Change-Id: Ifa700a4e34da4d1923e9473dd8f0d2417dcfded4
(cherry picked from commit 8c262051247d5d83f3d0269003705a363dbc3e60)

2 months agodowngrade batches for bindparam() in SET
Mike Bayer [Tue, 17 Feb 2026 20:58:22 +0000 (15:58 -0500)] 
downgrade batches for bindparam() in SET

Fixed issue where :meth:`_postgresql.Insert.on_conflict_do_update`
using parametrized bound parameters in the ``set_`` clause would fail
when used with executemany batching. For dialects that use the
``use_insertmanyvalues_wo_returning`` optimization (psycopg2),
insertmanyvalues is now disabled when there is an ON CONFLICT clause.
For cases with RETURNING, row-at-a-time mode is used when the SET
clause contains parametrized bindparams (bindparams that receive
values from the parameters dict), ensuring each row's parameters are
correctly applied. ON CONFLICT statements using expressions like
``excluded.<column>`` continue to batch normally.

Fixed issue where :meth:`_sqlite.Insert.on_conflict_do_update`
using parametrized bound parameters in the ``set_`` clause would fail
when used with executemany batching. Row-at-a-time mode is now used
for ON CONFLICT statements with RETURNING that contain parametrized
bindparams, ensuring each row's parameters are correctly applied. ON
CONFLICT statements using expressions like ``excluded.<column>``
continue to batch normally.

Fixes: #13130
Change-Id: I0c5a9142401c745d38e58d071c16e53610f9bfea
(cherry picked from commit 5b2e7aae01cc2e55e68a8445569ee709b17715dd)

2 months agoPoolProxiedConnection support context protocol
Federico Caselli [Mon, 9 Feb 2026 21:47:19 +0000 (22:47 +0100)] 
PoolProxiedConnection support context protocol

The connection object returned by :meth:`_engine.Engine.raw_connection`
now supports the context manager protocol, automatically returning the
connection to the pool when exiting the context.

Fixes: #13116
Change-Id: I51eb1fd61b772368f12a787e5f60db153a839e70
(cherry picked from commit 6fa097ed100dbe5553796c3b45efc50f614c2371)

2 months agodocument thread starvation as a cause of pool exhaustion
Mike Bayer [Mon, 9 Feb 2026 14:26:38 +0000 (09:26 -0500)] 
document thread starvation as a cause of pool exhaustion

Fixes: #7679
Change-Id: I5f2619ac73a5e1f34b9131fe549122998db8a29a
(cherry picked from commit cf0cc646d6700b25a0c7314ec1f9fe75ef1692ab)

2 months agoPostgreSQL / SQLite / Insert.on_conflict_do_update: respect compile_kwargs
Loïc Simon [Thu, 5 Feb 2026 19:56:26 +0000 (14:56 -0500)] 
PostgreSQL / SQLite / Insert.on_conflict_do_update: respect compile_kwargs

Fixed issue where :meth:`_postgresql.Insert.on_conflict_do_update`
as well as  :meth:`_sqlite.Insert.on_conflict_do_update`
parameters were not respecting compilation options such as
``literal_binds=True``.

Pull request courtesy Loïc Simon.

Fixes: #13110
Closes: #13111
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13111
Pull-request-sha: 9ca251610b2eb1c5fdda6aeffa6e81dcaef23aaa

Change-Id: Ice21e508210d682098104c78e77bad8d24e6c93f
(cherry picked from commit 6b09777e3d1ef35eb0ed07843b51d1a525702b79)

2 months agoallow batch with upsert if embed_values_counter is True
Mike Bayer [Wed, 4 Feb 2026 02:07:59 +0000 (21:07 -0500)] 
allow batch with upsert if embed_values_counter is True

Fixed issue in the :ref:`engine_insertmanyvalues` feature where using
PostgreSQL's ``ON CONFLICT`` clause with
:paramref:`_dml.Insert.returning.sort_by_parameter_order` enabled would
generate invalid SQL when the insert used an implicit sentinel (server-side
autoincrement primary key). The generated SQL would incorrectly declare a
sentinel counter column in the ``imp_sen`` table alias without providing
corresponding values in the ``VALUES`` clause, leading to a
``ProgrammingError`` indicating column count mismatch. The fix allows batch
execution mode when ``embed_values_counter`` is active, as the embedded
counter provides the ordering capability needed even with upsert behaviors,
rather than unnecessarily downgrading to row-at-a-time execution.

Fixes: #13107
Change-Id: I382472b2cf2991b520344adea5783584e27425d0
(cherry picked from commit 574facaaf4207b952379c28673c44b62835535fb)

2 months agoparse ON UPDATE / ON DELETE in any order
Mike Bayer [Tue, 3 Feb 2026 21:11:13 +0000 (16:11 -0500)] 
parse ON UPDATE / ON DELETE in any order

Fixed an issue in the PostgreSQL dialect where foreign key constraint
reflection would incorrectly swap or fail to capture ``onupdate`` and
``ondelete`` values when these clauses appeared in a different order than
expected in the constraint definition. This issue primarily affected
PostgreSQL-compatible databases such as CockroachDB, which may return ``ON
DELETE`` before ``ON UPDATE`` in the constraint definition string. The
reflection logic now correctly parses both clauses regardless of their
ordering.

Fixes: #13105
Change-Id: I1331b433f713632e84ae6a34467806e080b8003e
(cherry picked from commit 6fbdd3602136fe7589238c657f61de60b85c3c54)

2 months agoforwards-port cpython issue 141560 for getfullargspec
Mike Bayer [Tue, 3 Feb 2026 13:53:53 +0000 (08:53 -0500)] 
forwards-port cpython issue 141560 for getfullargspec

Fixed issue when using ORM mappings with Python 3.14's :pep:`649` feature
that no longer requires "future annotations", where the ORM's introspection
of the ``__init__`` method of mapped classes would fail if non-present
identifiers in annotations were present.  The vendored ``getfullargspec()``
method has been amended to use ``Format.FORWARDREF`` under Python 3.14 to
prevent resolution of names that aren't present.

Fixes: #13104
References: https://github.com/python/cpython/issues/141560
Change-Id: I6af8026a07131d4a1e28cd7fc2e90509194ae957
(cherry picked from commit be37eb8d3061a316d82051d1a7eb670fc65b5fb0)

2 months agoallow 2 uncleared connections at most
Mike Bayer [Fri, 30 Jan 2026 15:32:52 +0000 (10:32 -0500)] 
allow 2 uncleared connections at most

tests show that if the code is really broken, we have
5 or more connections lingering here, so for less than two
(it's usually one) just clean it out and consider it as GC noise.

To test this better we also open up the windows/mac archs that
were disabled for greenlet

Fixes: #13102
Change-Id: Iccf419e7f345bcae4a388d222ab69fc792a3c1ca
(cherry picked from commit ff2c7668fe90b43b75dcb0d6e7651349dd715e5a)

2 months agoAdd external dialects for DynamoDB and MongoDB (#13100)
Peng Ren [Thu, 29 Jan 2026 19:52:43 +0000 (14:52 -0500)] 
Add external dialects for DynamoDB and MongoDB (#13100)

(cherry picked from commit 290378a57a65e0db2862a6fb7f1de8b5d22bac31)

2 months agoclarify that poolevents should be registered via engines
Mike Bayer [Tue, 27 Jan 2026 18:38:26 +0000 (13:38 -0500)] 
clarify that poolevents should be registered via engines

also clarify the role of engine.dispose()

references: #13097
Change-Id: I495863b58ffd05f4883f51ce2b3dcbd2bb2367b2
(cherry picked from commit 325addda8b569581f5c5537cbbb76ef70da6534d)

3 months agoFix a typo in relationships.rst (#13087)
Imad Saddik [Fri, 23 Jan 2026 22:43:16 +0000 (23:43 +0100)] 
Fix a typo in relationships.rst (#13087)

(cherry picked from commit 53e2966dc0dab99f5814b5a84f4ab7435a4e216e)

3 months agoVersion 2.0.47 placeholder
Mike Bayer [Wed, 21 Jan 2026 18:04:03 +0000 (13:04 -0500)] 
Version 2.0.47 placeholder

3 months ago- 2.0.46 rel_2_0_46
Mike Bayer [Wed, 21 Jan 2026 17:59:27 +0000 (12:59 -0500)] 
- 2.0.46

3 months agomake qtoken for PostgreSQL _fk_regex_pattern less restrictive
Gord Thompson [Mon, 19 Jan 2026 12:34:28 +0000 (05:34 -0700)] 
make qtoken for PostgreSQL _fk_regex_pattern less restrictive

Improved the foreign key reflection regular expression pattern used by the
PostgreSQL dialect to be more permissive in matching identifier characters,
allowing it to correctly handle unicode characters in table and column
names. This change improves compatibility with PostgreSQL variants such as
CockroachDB that may use different quoting patterns in combination with
unicode characters in their identifiers.  Pull request courtesy Gord
Thompson.

Change-Id: Iaee340879400e01df2f776417e8b1018f1801cfe
(cherry picked from commit d0d9f1b71115471b0a6918075383c2bddf2212b1)

3 months agodocs: fix grammar in reflection documentation
Imad Saddik [Tue, 20 Jan 2026 20:52:24 +0000 (21:52 +0100)] 
docs: fix grammar in reflection documentation

(cherry picked from commit d1026e788cad26ee507bb79fa7b8b316c81166e2)

3 months agocorrect mariadb sequence behavior when cycle=False
rusher [Wed, 14 Jan 2026 14:03:00 +0000 (09:03 -0500)] 
correct mariadb sequence behavior when cycle=False

Fixed the SQL compilation for the mariadb sequence "NOCYCLE" keyword that
is to be emitted when the :paramref:`.Sequence.cycle` parameter is set to
False on a :class:`.Sequence`.  Pull request courtesy Diego Dupin.

Fixes: #13073
Closes: #13074
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13074
Pull-request-sha: ead18a04018db6d574a3bc4bd71f21c23256737c

Change-Id: Ie1640c969aaa64e41da334fe0eff21e0d12a8bf0
(cherry picked from commit c36643fbb933c0defd00b9caa7a184c24e2a544b)

3 months agoadd additional clarification re: table valued for SQLite vs. PostgreSQL
Mike Bayer [Wed, 14 Jan 2026 18:43:26 +0000 (13:43 -0500)] 
add additional clarification re: table valued for SQLite vs. PostgreSQL

Fixes: #13079
Change-Id: I4e96709712a3f365e75b134dadc3bd24fb0cc053
(cherry picked from commit 63885906e8a5f6ad479e591e4f5716b486ef1df6)

3 months agohappy new year
Mike Bayer [Wed, 14 Jan 2026 18:01:21 +0000 (13:01 -0500)] 
happy new year

Change-Id: I86954844fe5ae036758c332b9a033851d3266ca9

3 months agotyping updates to accept with_polymorphic(), aliases
Mike Bayer [Tue, 13 Jan 2026 14:19:14 +0000 (09:19 -0500)] 
typing updates to accept with_polymorphic(), aliases

Fixed typing issues where ORM mapped classes and aliased entities could not
be used as keys in result row mappings or as join targets in select
statements. Patterns such as ``row._mapping[User]``,
``row._mapping[aliased(User)]``, ``row._mapping[with_polymorphic(...)]``
(rejected by both mypy and Pylance), and ``.join(aliased(User))``
(rejected by Pylance) are documented and fully supported at runtime but
were previously rejected by type checkers. The type definitions for
:class:`._KeyType` and :class:`._FromClauseArgument` have been updated to
accept these ORM entity types.

Fixes: #13075
Change-Id: Icc3b1ef832b01fd205b1409b2f6d0f211395d4ad
(cherry picked from commit 48410f83407661e009326d7170ab79e5163eb8f1)

3 months agoremove paragraph re: init=False as I think this is a 2.1 thing
Mike Bayer [Fri, 9 Jan 2026 14:19:22 +0000 (09:19 -0500)] 
remove paragraph re: init=False as I think this is a 2.1 thing

Change-Id: I78a61f75a2288e6823704cd10fcbbdb52352a25d

3 months agoclarify default_factory
Mike Bayer [Fri, 9 Jan 2026 14:07:23 +0000 (09:07 -0500)] 
clarify default_factory

References: #13068
Change-Id: Ie08ad4120a21bf24c8e5704340c525299b9894fd
(cherry picked from commit 47266b11b7b4ef81c34c199f9b75424dfebbee60)

3 months agoapply Grouping on left side of JSONB subscript in compiler
Mike Bayer [Wed, 7 Jan 2026 01:03:10 +0000 (20:03 -0500)] 
apply Grouping on left side of JSONB subscript in compiler

Fixed regression in PostgreSQL dialect where JSONB subscription syntax
would generate incorrect SQL for :func:`.cast` expressions returning JSONB,
causing syntax errors. The dialect now properly wraps cast expressions in
parentheses when using the ``[]`` subscription syntax, generating
``(CAST(...))[index]`` instead of ``CAST(...)[index]`` to comply with
PostgreSQL syntax requirements. This extends the fix from :ticket:`12778`
which addressed the same issue for function calls.

This reverts how we did the fix for #12778 in Function.self_group()
and instead moves to a direct Grouping() applied in the PG compiler
based on isinstance of the left side.

in retrospect, when we first did #10927, we **definitely** made
the completely wrong choice in how to do this, the original idea
to detect when we were in an UPDATE and use [] only then was
by **far** what we should have done, given the fact that PG indexes
are based on exact syntax matches.  but since we've made everyone
switch to [] format for their indexes now we can't keep going
back and forth.   even though PG would like [] to be the defacto
syntax it simply is not.    We should potentially pursue a dialect/
create_engine option to switch the use of [] back to -> for
all cases except UPDATE.

Fixes: #13067
Change-Id: I2e0d0f45ebb820d2a8f214550f1d1a500bae223b
(cherry picked from commit 217b3fd053857d396a65349a170da1342ae030d1)

3 months agoMerge "Fixed JSONB path_match and path_exists operators to use correct type coercion...
Michael Bayer [Wed, 7 Jan 2026 00:09:57 +0000 (00:09 +0000)] 
Merge "Fixed JSONB path_match and path_exists operators to use correct type coercion" into rel_2_0

3 months agoSupport aiosqlite 0.22.0+
Federico Caselli [Wed, 24 Dec 2025 13:02:17 +0000 (14:02 +0100)] 
Support aiosqlite 0.22.0+

Fixed issue in the aiosqlite driver where SQLAlchemy's setting of
aiosqlite's worker thread to "daemon" stopped working because the aiosqlite
architecture moved the location of the worker thread in version 0.22.0.
This "daemon" flag is necessary so that a program is able to exit if the
SQLite connection itself was not explicitly closed, which is particularly
likely with SQLAlchemy as it maintains SQLite connections in a connection
pool.  While it's perfectly fine to call :meth:`.AsyncEngine.dispose`
before program exit, this is not historically or technically necessary for
any driver of any known backend, since a primary feature of relational
databases is durability.  The change also implements support for
"terminate" with aiosqlite when using version version 0.22.1 or greater,
which implements a sync ``.stop()`` method.

Fixes: #13039
Change-Id: I46efcbaab9dd028f673e113d5f6f2ceddfd133ca
(cherry picked from commit 380c234ce901416ca3c04453744f33d53cc4bd55)

3 months agoFixed JSONB path_match and path_exists operators to use correct type coercion
Mike Bayer [Wed, 31 Dec 2025 20:48:44 +0000 (15:48 -0500)] 
Fixed JSONB path_match and path_exists operators to use correct type coercion

Fixed issue where PostgreSQL JSONB operators
:meth:`_postgresql.JSONB.Comparator.path_match` and
:meth:`_postgresql.JSONB.Comparator.path_exists` were applying incorrect
``VARCHAR`` casts to the right-hand side operand when used with newer
PostgreSQL drivers such as psycopg. The operators now indicate the
right-hand type as ``JSONPATH``, which currently results in no casting
taking place, but is also compatible with explicit casts if the
implementation were require it at a later point.

Fixes: #13059
Change-Id: I8e1a58361456f7efabf4940339cb5ce2c5a1d5f9
(cherry picked from commit a88f89849e303ab441082de788545ee8a698dc2e)

3 months agodont run oracledb async on profiling tests
Mike Bayer [Wed, 31 Dec 2025 14:46:57 +0000 (09:46 -0500)] 
dont run oracledb async on profiling tests

this was never the intention

Change-Id: Iaaa208299f377da8afafea7f487c055e170fbc9e
(cherry picked from commit 0a1be6dcfab7b17613835248a368e6b822a53319)

4 months agoMerge "Support for `IF EXISTS` in SQL Server 2016 (13.x) and later versions" into...
Michael Bayer [Fri, 19 Dec 2025 21:41:35 +0000 (21:41 +0000)] 
Merge "Support for `IF EXISTS` in SQL Server 2016 (13.x) and later versions" into rel_2_0

4 months agofix typos (#13047)
Fardin Alizadeh [Fri, 19 Dec 2025 20:24:23 +0000 (23:54 +0330)] 
fix typos (#13047)

* fix typos

* fix typos

* fix typos

---------

Co-authored-by: fardyn <fa.alizadeh@pm.me>
(cherry picked from commit 81e72ca9cd4230bd29cebc3965cc6fa0913e26e3)

Change-Id: I016b3ce4a981a09a60bb302cc38badff8b1fe24d

4 months agoSupport for `IF EXISTS` in SQL Server 2016 (13.x) and later versions
Edgar Ramírez Mondragón [Thu, 18 Dec 2025 19:58:59 +0000 (14:58 -0500)] 
Support for `IF EXISTS` in SQL Server 2016 (13.x) and later versions

Added support for the ``IF EXISTS`` clause when dropping indexes on SQL
Server 2016 (13.x) and later versions. The :paramref:`.DropIndex.if_exists`
parameter is now honored by the SQL Server dialect, allowing conditional
index drops that will not raise an error if the index does not exist.
Pull request courtesy Edgar Ramírez Mondragón.

Fixes: #13045
Closes: #13046
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13046
Pull-request-sha: 65dca2055cb403430730b5cf42f0c5f55b23bfb1

Change-Id: Iab95b1a46003b38709a791b8a7c4233dfda5e830
(cherry picked from commit 40fc3c90e1fee3f7a19184ab57cca3cbcdfa6da1)

4 months agofix typos (#13038)
Fardin Alizadeh [Thu, 18 Dec 2025 20:18:42 +0000 (23:48 +0330)] 
fix typos (#13038)

* fix typos

* fix typos

---------

Co-authored-by: fardyn <fa.alizadeh@pm.me>
(cherry picked from commit fb408b8e9d2e4ca7ac446c3d8dbd42c66b69b5a3)

Change-Id: I29c3229aa475b51b6a7055dd5d149283ef1a08a8

4 months agomention adapt on names
Mike Bayer [Thu, 18 Dec 2025 14:19:12 +0000 (09:19 -0500)] 
mention adapt on names

make sure we include that column correspondence is not
the only way to do this

Change-Id: I4fa78f2e79585c1796c3dc169f88c849d604f668
(cherry picked from commit b4068fd0227b980bb9e6340befd649d4d261c2c7)

4 months agofix typos (#13036)
Fardin [Tue, 16 Dec 2025 20:10:03 +0000 (23:40 +0330)] 
fix typos (#13036)

(cherry picked from commit 7194b5ba3de050815ea20aafb80d262b6fcd1d07)

Change-Id: Ib462035322aaeacd733386f5db6883a811b36a4d

4 months agoimprove SQL Server fulltext drop
Mike Bayer [Sun, 14 Dec 2025 03:37:04 +0000 (22:37 -0500)] 
improve SQL Server fulltext drop

Change-Id: I848080227d50ab446a8add296b759003441fd0ad
(cherry picked from commit 01dcb7a967fd91b0764e83dabaed0a8a7bfa78ec)

4 months agoMerge "Fix return type hint for `Query.get()`" into rel_2_0
Michael Bayer [Wed, 10 Dec 2025 20:44:44 +0000 (20:44 +0000)] 
Merge "Fix return type hint for `Query.get()`" into rel_2_0

4 months agocleaup test pipeline
Federico Caselli [Wed, 10 Dec 2025 20:06:44 +0000 (21:06 +0100)] 
cleaup test pipeline

Change-Id: Ic29289686139f27df3c3802f20ca4cbd2105778c

4 months agoFix wheel pipeline
Federico Caselli [Wed, 10 Dec 2025 20:02:34 +0000 (21:02 +0100)] 
Fix wheel pipeline

Change-Id: I97b47160b619a454e421a94396a2fb8116dada6e

4 months agoFix return type hint for `Query.get()`
Séamus Ó Ceanainn [Wed, 10 Dec 2025 17:14:25 +0000 (12:14 -0500)] 
Fix return type hint for `Query.get()`

<!-- Provide a general summary of your proposed changes in the Title field above -->

<!-- Describe your changes in detail -->

`Query[_T].get(...)` should return `Optional[_T]` instead of `Optional[Any]`. This is typed correctly when migrating to  `Session.get(_T, ...)`. By typing the legacy `Query.get(...)` call first, it should make migrations easier on developers, as it splits up the type checking improvements (and subsequent errors which may be discovered) from the `Query.get()`
 to `Session.get()` migration.

<!-- go over following points. check them with an `x` if they do apply, (they turn into clickable checkboxes once the PR is submitted, so no need to do everything at once)

-->

This pull request is:

- [x] A documentation / typographical / small typing error fix
- Good to go, no issue or tests are needed
- [ ] A short code fix
- please include the issue number, and create an issue if none exists, which
  must include a complete example of the issue.  one line code fixes without an
  issue and demonstration will not be accepted.
- Please include: `Fixes: #<issue number>` in the commit message
- please include tests.   one line code fixes without tests will not be accepted.
- [ ] A new feature implementation
- please include the issue number, and create an issue if none exists, which must
  include a complete example of how the feature would look.
- Please include: `Fixes: #<issue number>` in the commit message
- please include tests.

**Have a nice day!**

Closes: #13028
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13028
Pull-request-sha: 38ec0c3ae072f8c7b62134dd017579a6a249219f

Change-Id: I7ae8e59bc0bd0a25c65de3804d60f6c2b6f50151
(cherry picked from commit 9cd9b6b5896333f779f484c73f3c1119448305b5)

4 months agoMerge "additional check for dc test" into rel_2_0
Michael Bayer [Wed, 10 Dec 2025 14:34:53 +0000 (14:34 +0000)] 
Merge "additional check for dc test" into rel_2_0

4 months agoadd length, take two
Mike Bayer [Wed, 10 Dec 2025 14:19:23 +0000 (09:19 -0500)] 
add length, take two

followup to 292aa19698326793003

Change-Id: I283059eaf747c722b871afa55aaeaa2889862584
(cherry picked from commit 668ea5b7384297236330ead78919889b4473807f)

4 months agoadd length
Mike Bayer [Wed, 10 Dec 2025 13:38:03 +0000 (08:38 -0500)] 
add length

new tests in e4a802f99a for issue #12858 forgot to add string
length for String leading to MySQL failures

Change-Id: I7642ee8581da09a3a25236dacdc441effee21931
(cherry picked from commit 292aa19698326793003c0ebb2c75f6863d039573)

4 months agoadditional check for dc test
Federico Caselli [Tue, 9 Dec 2025 21:40:02 +0000 (22:40 +0100)] 
additional check for dc test

Change-Id: Ibf39a4c413b445abd8825ded900ac451ab9de9a2
(cherry picked from commit 3cad9e372b98b96e9493ad383b2e44301b4b58f4)

4 months agoVersion 2.0.46 placeholder
Mike Bayer [Tue, 9 Dec 2025 21:06:37 +0000 (16:06 -0500)] 
Version 2.0.46 placeholder

4 months ago- 2.0.45 rel_2_0_45
Mike Bayer [Tue, 9 Dec 2025 20:54:35 +0000 (15:54 -0500)] 
- 2.0.45

4 months agoMerge "Factor out constraints into separate methods" into rel_2_0
Michael Bayer [Tue, 9 Dec 2025 20:45:35 +0000 (20:45 +0000)] 
Merge "Factor out constraints into separate methods" into rel_2_0

4 months agoFactor out constraints into separate methods
G Allajmi [Tue, 9 Dec 2025 19:13:52 +0000 (14:13 -0500)] 
Factor out constraints into separate methods

Fixed issue where PostgreSQL dialect options such as ``postgresql_include``
on :class:`.PrimaryKeyConstraint` and :class:`.UniqueConstraint` were
rendered in the wrong position when combined with constraint deferrability
options like ``deferrable=True``. Pull request courtesy G Allajmi.

Fixes: #12867
Closes: #13003
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13003
Pull-request-sha: 1a9216062f12cba2695b0b4a1407e092556c2305

Change-Id: I8c55d8faae25d56ff63c9126d569c01d8ee6c7dd
(cherry picked from commit 9fe3c3cd30bd7d4afc877bb2243ba7679ebe185d)

4 months agoFix adding property to mapper before mapping is complete
G Allajmi [Mon, 8 Dec 2025 13:03:49 +0000 (08:03 -0500)] 
Fix adding property to mapper before mapping is complete

Fixed issue where calling :meth:`.Mapper.add_property` within mapper event
hooks such as :meth:`.MapperEvents.instrument_class`,
:meth:`.MapperEvents.after_mapper_constructed`, or
:meth:`.MapperEvents.before_mapper_configured` would raise an
``AttributeError`` because the mapper's internal property collections were
not yet initialized. The :meth:`.Mapper.add_property` method now handles
early-stage property additions correctly, allowing properties including
column properties, deferred columns, and relationships to be added during
mapper initialization events.  Pull request courtesy G Allajmi.

Fixes: #12858
Closes: #13023
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13023
Pull-request-sha: fa9a0ae4bb07819307e6c9d6ec5fd4c9706bf67e

Change-Id: Ibb794c401102a8d23d157b40353f272d5735b49a
(cherry picked from commit e4a802f99a0bca813dd29e8dc88bb5e5aaddff93)

4 months agoupdate cibuildwheel to ensure python 3.14 is supported
Federico Caselli [Mon, 8 Dec 2025 20:12:16 +0000 (21:12 +0100)] 
update cibuildwheel to ensure python 3.14 is supported

Change-Id: Ic520ae7084dcc0660da0d70a0c33de251395ec50
(cherry picked from commit f58ea194d5190859baef66c183fa0228f629830c)

4 months agofix typo
Mike Bayer [Mon, 8 Dec 2025 16:40:34 +0000 (11:40 -0500)] 
fix typo

Change-Id: I5a440f9d3a8bb5afb45b0af4d9f1a112255d5f96
(cherry picked from commit c7bd25650adf6babc8f39eb61b42eb626d92261f)

4 months agouse plain 3.14 for test runs
Mike Bayer [Mon, 8 Dec 2025 14:14:26 +0000 (09:14 -0500)] 
use plain 3.14 for test runs

this was already applied to main previously

Change-Id: Id0d6a16e3be645ecf30cdbd238b4a9867791fd79

4 months agofix / modernize short_selects example
Mike Bayer [Fri, 5 Dec 2025 22:41:56 +0000 (17:41 -0500)] 
fix / modernize short_selects example

Fixed the "short_selects" performance example where the cache was being
used in all the examples, making it impossible to compare performance with
and without the cache.   Less important comparisons like "lambdas" and
"baked queries" have been removed.

Change-Id: Ia55391ba23e01d2ed136c84f9c34bb16689ce10e
(cherry picked from commit 66d55b51992a463beef47212992e5b2914f9e586)

4 months agoAdd a test for #13021
Mike Bayer [Wed, 3 Dec 2025 19:48:08 +0000 (14:48 -0500)] 
Add a test for #13021

Confirmed the upstream fix for [1] given at [2] solves the issue
illustrated here, this patch adds a test for this case as our
existing tests did not catch this error in python 3.14.1.

Fixes: #13021
Change-Id: Ie6827279ccf2b2cb2e0fe6029aafdcfefc790f1f
(cherry picked from commit 133f14dabed44f7398039e2556bf9b7107f3922e)

4 months agoMerge "run sentinel server side fns outside of VALUES" into rel_2_0
Michael Bayer [Wed, 3 Dec 2025 16:56:18 +0000 (16:56 +0000)] 
Merge "run sentinel server side fns outside of VALUES" into rel_2_0

4 months agorun sentinel server side fns outside of VALUES
Mike Bayer [Mon, 1 Dec 2025 20:11:50 +0000 (15:11 -0500)] 
run sentinel server side fns outside of VALUES

Fixed the structure of the SQL string used for the
:ref:`engine_insertmanyvalues` feature when an explicit sequence with
``nextval()`` is used. The SQL function invocation for the sequence has
been moved from being rendered inline within each tuple inside of VALUES to
being rendered once in the SELECT that reads from VALUES. This change
ensures the function is invoked in the correct order as rows are processed,
rather than assuming PostgreSQL will execute inline function calls within
VALUES in a particular order. While current PostgreSQL versions appear to
handle the previous approach correctly, the database does not guarantee
this behavior for future versions.

Fixes: #13015
Change-Id: Ia0a2a4e8f89e21852d7cb550dfa5d9ea9447b590
(cherry picked from commit c5d09f5ed4b4e37cfdd033026e2f67382ee9fcb3)

4 months ago[typing] Fix type error when passing Mapped columns to values()
Yossi [Mon, 1 Dec 2025 17:06:12 +0000 (12:06 -0500)] 
[typing] Fix type error when passing Mapped columns to values()

This adjusts the _DMLOnlyColumnArgument type to be a more
focused _OnlyColumnArgument type where we also add a more tightly
focused coercion, while still allowing ORM attributes to be used
as arguments.

Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Closes: #13012
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13012
Pull-request-sha: 5ebb402c686abf1090e5b83e3489dfca4908efdf

Change-Id: I8bbccaf556ec5ecb2f5cfdd2030bcfa4eb5ce125
(cherry picked from commit 40c2400af7d44a528358ea1d73c275a85bb75616)

4 months agoType postgresql.ExcludeConstraint()
Denis Laxalde [Mon, 1 Dec 2025 10:43:18 +0000 (05:43 -0500)] 
Type postgresql.ExcludeConstraint()

Related to #6810.

Closes: #13011
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13011
Pull-request-sha: 4a212cad1b231629ae4e3d6866c9603662a197a2

Change-Id: If5d91e06b6c0afc11adc02bb0c0d5ce97e53203c
(cherry picked from commit 4f87f4d9265adf826bd10b3b764405c3b871b5d8)

4 months agoadd python 3.14 wheels + free threaded
Mike Bayer [Mon, 1 Dec 2025 20:22:54 +0000 (15:22 -0500)] 
add python 3.14 wheels + free threaded

the freethreadeds are in a separate task so if they fail,
we still have wheels published

Change-Id: Ie28483cc379cf3db01afe2a2b4c475a9fbfbb9e5

4 months agoadditional fixes re: mariadb innodb etc.
Mike Bayer [Sat, 29 Nov 2025 03:47:40 +0000 (22:47 -0500)] 
additional fixes re: mariadb innodb etc.

fix a bunch of side effects that were not tested in the gerrit
phase because we run with --backendonly

Change-Id: Iebcedb962e6e11dd247b0da5f309a71db711694c
(cherry picked from commit 2169a2950479873cd42d62c3f81a6bd7caa8aaeb)