Search results

WriteOnlyMapped: default_factory=list broken in 2.1 due to new declarative_scan validation

requires triageNew issue that requires categorizationNew issue that requires categorization

Status: Open.

#13227 In sqlalchemy/sqlalchemy;

· rhynzler opened on Apr 8, 2026

mssql+mssqlpython: insertmanyvalues ~14x slower than mssql+pyodbc

dialectsgeneral dialect tag. useful for unsupported dbs or deprecations. not needed for specific dbs.general dialect tag. useful for unsupported dbs or deprecations. not needed for specific dbs.

performancewhere performance can be improved. add "bug" only if it's a performance degradationwhere performance can be improved. add "bug" only if it's a performance degradation

SQL ServerMicrosoft SQL Server, e.g. mssqlMicrosoft SQL Server, e.g. mssql

Status: Open.

#13223 In sqlalchemy/sqlalchemy;

· dxdc opened on Apr 7, 2026

·  

2.1

Support for native JSON in mssql

datatypesthings to do with database types, like VARCHAR and othersthings to do with database types, like VARCHAR and others

SQL ServerMicrosoft SQL Server, e.g. mssqlMicrosoft SQL Server, e.g. mssql

use casenot really a feature or a bug; can be support for new DB features or user use cases not anticipatednot really a feature or a bug; can be support for new DB features or user use cases not anticipated

Status: Open.

#13212 In sqlalchemy/sqlalchemy;

· CaselIT opened on Mar 31, 2026

·  

2.1

arrayaggload in addition to joinedload and selectinload

loader optionsORM options like joinedload(), load_only(), these are complicated and have a lot of issuesORM options like joinedload(), load_only(), these are complicated and have a lot of issues

orm

use casenot really a feature or a bug; can be support for new DB features or user use cases not anticipatednot really a feature or a bug; can be support for new DB features or user use cases not anticipated

Status: Open.

#13211 In sqlalchemy/sqlalchemy;

· pinaraf opened on Mar 30, 2026

Applying a loader option to a parent relationship when using with_polymorphic does not work properly

bugSomething isn't workingSomething isn't working

loader optionsORM options like joinedload(), load_only(), these are complicated and have a lot of issuesORM options like joinedload(), load_only(), these are complicated and have a lot of issues

orm

Status: Open.

#13210 In sqlalchemy/sqlalchemy;

· CaselIT opened on Mar 29, 2026

·  

2.0.x

Subquery load loses and_ criteria when combined with of_type

bugSomething isn't workingSomething isn't working

loader optionsORM options like joinedload(), load_only(), these are complicated and have a lot of issuesORM options like joinedload(), load_only(), these are complicated and have a lot of issues

orm

Status: Open.

#13207 In sqlalchemy/sqlalchemy;

· CaselIT opened on Mar 28, 2026

Immediateload fails to load when combined with inheritance

bugSomething isn't workingSomething isn't working

fuzzer

loader optionsORM options like joinedload(), load_only(), these are complicated and have a lot of issuesORM options like joinedload(), load_only(), these are complicated and have a lot of issues

orm

Status: Open.

#13204 In sqlalchemy/sqlalchemy;

· CaselIT opened on Mar 27, 2026

·  

2.0.x

joinedload + of_type() + .and_() generates invalid SQL

bugSomething isn't workingSomething isn't working

fuzzer

loader optionsORM options like joinedload(), load_only(), these are complicated and have a lot of issuesORM options like joinedload(), load_only(), these are complicated and have a lot of issues

orm

Status: Open.

#13203 In sqlalchemy/sqlalchemy;

· CaselIT opened on Mar 27, 2026

·  

2.0.x

Connection pool soft invalidation uses time.time() comparison that can silently fail on low-resolution clocks (e.g. Windows ~16 ms)

connection pool

use casenot really a feature or a bug; can be support for new DB features or user use cases not anticipatednot really a feature or a bug; can be support for new DB features or user use cases not anticipated

Status: Open.

#13169 In sqlalchemy/sqlalchemy;

· tejasae-afk opened on Mar 13, 2026

·  

2.x.x

PostgreSQL check constraint reflection strips brackets naively

bugSomething isn't workingSomething isn't working

great mcveAn issue with a great mcveAn issue with a great mcve

postgresql

reflectionreflection of tables, columns, constraints, defaults, sequences, views, everything elsereflection of tables, columns, constraints, defaults, sequences, views, everything else

Status: Open.

#13157 In sqlalchemy/sqlalchemy;

· RazerM opened on Mar 6, 2026

·  

2.0.x

composite with in-place custom values getter

orm

use casenot really a feature or a bug; can be support for new DB features or user use cases not anticipatednot really a feature or a bug; can be support for new DB features or user use cases not anticipated

Status: Open.

#13153 In sqlalchemy/sqlalchemy;

· Tishka17 opened on Mar 4, 2026

·  

2.x.x

SQLite insert supports multiple on-conflict clauses in inserts

dmlINSERT, UPDATE, DELETE, often with ORMINSERT, UPDATE, DELETE, often with ORM

sqlite

use casenot really a feature or a bug; can be support for new DB features or user use cases not anticipatednot really a feature or a bug; can be support for new DB features or user use cases not anticipated

Status: Open.

#13113 In sqlalchemy/sqlalchemy;

· CaselIT opened on Feb 6, 2026

·  

2.1.x