List view

SQLITE: SQLiteDialect.get_check_constraints incorrectly reflects multiline check constraints

bugSomething isn't workingSomething isn't working

law of twosthe law that issues about a particular topic come in twosthe law that issues about a particular topic come in twos

quagmirereally hard to make the issue work "correctly" without lots of complication, riskreally hard to make the issue work "correctly" without lots of complication, risk

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

sqlite

Status: Open.

#11677 In sqlalchemy/sqlalchemy;

· Student1-vFinance opened on Aug 1, 2024

implement decent inspection API for registry -> mapped classes

feature

orm

Status: Open.

#6080 In sqlalchemy/sqlalchemy;

· cuchoi opened on Mar 17, 2021

create oracle_dblink table option

feature

oracle

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

schemathings related to the DDL related objects like Table, Column, CreateIndex, etc.things related to the DDL related objects like Table, Column, CreateIndex, etc.

sql

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.

#7718 In sqlalchemy/sqlalchemy;

· zzzeek opened on Feb 15, 2022

support Postgresql / MySQL DELETE...USING [LEFT OUTER] JOIN

mysql

postgresql

PRs (with tests!) welcomea fix or feature which is appropriate to be implemented by volunteersa fix or feature which is appropriate to be implemented by volunteers

sql

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.

#8130 In sqlalchemy/sqlalchemy;

· tgross35 opened on Jun 13, 2022

Type annotations are not preserved by <code>declared_attr</code>, <code>hybrid_property</code>, and potentially other decorators

awaiting infowaiting for the submitter to give more informationwaiting for the submitter to give more information

help wantedExtra attention is neededExtra attention is needed

orm

typingpep -484 typing issues. independent of "mypy"pep -484 typing issues. independent of "mypy"

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.

#5999 In sqlalchemy/sqlalchemy;

· woodruffw opened on Mar 3, 2021

some means of applying SQL functions to association proxy

association proxy

orm

sqlalchemy.extextension modules, most of which are ORM relatedextension modules, most of which are ORM related

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.

#5541 In sqlalchemy/sqlalchemy;

· zzzeek opened on Aug 27, 2020

implement "sticky" option for load_only / defer (persists after expiration?)

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.

#5964 In sqlalchemy/sqlalchemy;

· wangjiancn opened on Feb 21, 2021

instance_state can't raise an informative exception due to performance concerns. write C function?

bugSomething isn't workingSomething isn't working

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

quagmirereally hard to make the issue work "correctly" without lots of complication, riskreally hard to make the issue work "correctly" without lots of complication, risk

Status: Open.

#4855 In sqlalchemy/sqlalchemy;

· jtrakk opened on Sep 10, 2019

Can not select negated boolean column in MS SQL Server

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.

#5352 In sqlalchemy/sqlalchemy;

· mkapi opened on May 27, 2020

Improve SQLAlchemy consistency regarding database specific supported constructs

big joba major change that requires a lot of knowledge and worka major change that requires a lot of knowledge and work

documentation

sql

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.

#5583 In sqlalchemy/sqlalchemy;

· CaselIT opened on Sep 14, 2020

favor module names over table names when looking at the class target of a relationship, or dot separated names ? unsure

bugSomething isn't workingSomething isn't working

declarativehas to do with the declarative API, scanning classes and mixins for attributes to be mappedhas to do with the declarative API, scanning classes and mixins for attributes to be mapped

quagmirereally hard to make the issue work "correctly" without lots of complication, riskreally hard to make the issue work "correctly" without lots of complication, risk

Status: Open.

#5806 In sqlalchemy/sqlalchemy;

· quantumdark opened on Dec 30, 2020

Support transaction read only access mode API, implement for MySQL, PostgreSQL, Oracle, others

engineengines, connections, transactions, isolation levels, execution optionsengines, connections, transactions, isolation levels, execution options

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.

#5815 In sqlalchemy/sqlalchemy;

· itamarLaufer opened on Jan 5, 2021

Optimize selectinload with many to many relationship to avoid unnecessary join

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

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

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.

#5987 In sqlalchemy/sqlalchemy;

· CaselIT opened on Feb 26, 2021

allow clauseelements in hint text

sql

temporal table modifiersa more requsted featurea more requsted feature

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.

#6040 In sqlalchemy/sqlalchemy;

· zzzeek opened on Mar 13, 2021

version_id_col should accept string attr name like polymorphic_on does, make sure all mapper args that point to a column can work like this

fairly easymaybe a little more involved than "easy' but still doable for motivated newcomersmaybe a little more involved than "easy' but still doable for motivated newcomers

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.

#6084 In sqlalchemy/sqlalchemy;

· benpreisler opened on Mar 18, 2021

Support lambdas in <code>column_property</code>

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.

#6120 In sqlalchemy/sqlalchemy;

· CaselIT opened on Mar 23, 2021

support MySQL 8.0.13's new magical syntax for function server defaults

fairly easymaybe a little more involved than "easy' but still doable for motivated newcomersmaybe a little more involved than "easy' but still doable for motivated newcomers

mysql

PRs (with tests!) welcomea fix or feature which is appropriate to be implemented by volunteersa fix or feature which is appropriate to be implemented by volunteers

schemathings related to the DDL related objects like Table, Column, CreateIndex, etc.things related to the DDL related objects like Table, Column, CreateIndex, etc.

Status: Open.

#8341 In sqlalchemy/sqlalchemy;

· zzzeek opened on Aug 3, 2022

Named window functions

PRs (with tests!) welcomea fix or feature which is appropriate to be implemented by volunteersa fix or feature which is appropriate to be implemented by volunteers

sql

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.

#8352 In sqlalchemy/sqlalchemy;

· CaselIT opened on Aug 4, 2022

Default MetaData kwarg naming_convention can create issues with certain databases

documentation

Status: Open.

#4784 In sqlalchemy/sqlalchemy;

· jvanasco opened on Jul 26, 2019

Improve error messages on create_table

bugSomething isn't workingSomething isn't working

naming conventionsthings to do with the metadata.naming_convention featurethings to do with the metadata.naming_convention feature

sql

Status: Open.

#4790 In sqlalchemy/sqlalchemy;

· jvanasco opened on Aug 1, 2019

Coordinating Changelog info

documentation

Status: Open.

#5235 In sqlalchemy/sqlalchemy;

· jvanasco opened on Apr 6, 2020

Documentation: use ORM declarative attributes in .values instead of kwargs in "ORM-enabled UPDATE statements"?

documentation

SQLA mypy pluginmypy plugin issues only. general pep-484 issues should be "typing"mypy plugin issues only. general pep-484 issues should be "typing"

typingpep -484 typing issues. independent of "mypy"pep -484 typing issues. independent of "mypy"

Status: Open.

#6332 In sqlalchemy/sqlalchemy;

· MaicoTimmerman opened on Apr 21, 2021

implement include_join=False for selectin_polymorphic

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

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

Status: Open.

#8431 In sqlalchemy/sqlalchemy;

· zzzeek opened on Aug 24, 2022

Support MySQL Multi-Valued Indexes

mysql

PRs (with tests!) welcomea fix or feature which is appropriate to be implemented by volunteersa fix or feature which is appropriate to be implemented by volunteers

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

schemathings related to the DDL related objects like Table, Column, CreateIndex, etc.things related to the DDL related objects like Table, Column, CreateIndex, etc.

Status: Open.

#8457 In sqlalchemy/sqlalchemy;

· CaselIT opened on Aug 29, 2022

self-referential / mutually dependent FK flush() should not require post_update for an UPDATE only query

bugSomething isn't workingSomething isn't working

orm

post-updateissues with the post-update featureissues with the post-update feature

quagmirereally hard to make the issue work "correctly" without lots of complication, riskreally hard to make the issue work "correctly" without lots of complication, risk

unit of workthe persistence phase within the ORM.the persistence phase within the ORM.

Status: Open.

#1063 In sqlalchemy/sqlalchemy;

· sqlalchemy-bot opened on May 28, 2008