PR #12401 is blocked by failing static/type checks: pep484-3.14, pep8-3.14; pending owner gate: gerrit_review.

Fix or ask the contributor to fix pep484-3.14, pep8-3.14, rerun checks, then revisit review/owner-gate approval once the branch is green.

failed checks: pep484-3.14, pep8-3.14; pending owner gate: gerrit_review. Review signal: this is fine though I think you need to install pre-commit and have it run because this will fail pep8 for line length | Thanks for the hint. I indeed forgot to lint my changes. Note that pre-commit did not work for me because of a version conflict with black: ``` stderr: ERROR: Package 'black' r...

PR #12645 is blocked by failing static/type checks: pep484-3.12; pending owner gate: gerrit_review.

Fix or ask the contributor to fix pep484-3.12, rerun checks, then revisit review/owner-gate approval once the branch is green.

failed checks: pep484-3.12; pending owner gate: gerrit_review.

PR #13051 is blocked by failing static/type checks: mypy-3.14; pending owner gate: gerrit_review.

Fix or ask the contributor to fix mypy-3.14, rerun checks, then revisit review/owner-gate approval once the branch is green.

failed checks: mypy-3.14; pending owner gate: gerrit_review.

PR #10574 appears blocked by merge state `DIRTY`.

Rebase/update the branch against main, then rerun checks before maintainer review.

mergeStateStatus=DIRTY; branch=issue_2943

PR #11296 appears blocked by merge state `DIRTY`.

Rebase/update the branch against main, then rerun checks before maintainer review.

mergeStateStatus=DIRTY; branch=feature/GH-11122/table-with

PR #11437 appears blocked by merge state `DIRTY`.

Rebase/update the branch against main, then rerun checks before maintainer review.

mergeStateStatus=DIRTY; branch=fix-examples-2

PR #13323 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13418 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13405 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13404 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13399 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13398 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13368 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13303 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13417 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13289 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #13288 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #12731 is waiting on repository-owner test approval: gerrit_review.

Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.

pending checks: gerrit_review

PR #12433 is contributor-owned until requested changes or review questions are answered.

Keep parked or close after maintainer review if the contributor path is no longer active; do not ask for maintainer work first.

reviewDecision=CHANGES_REQUESTED; stale_days=479

PR #13402 has no local failed-check diagnosis; it needs a maintainer merge/close/rebase decision.

Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.

reviewDecision=; mergeStateStatus=UNSTABLE; pending=code_review; stale_days=8

PR #13421 has no local failed-check diagnosis; it needs a maintainer merge/close/rebase decision.

Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.

reviewDecision=; mergeStateStatus=UNSTABLE; pending=code_review; stale_days=0

PR #12297 has no local failed-check diagnosis; it needs a maintainer merge/close/rebase decision.

Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.

reviewDecision=; mergeStateStatus=CLEAN; pending=; stale_days=473

PR #11180 has no local failed-check diagnosis; it needs a maintainer merge/close/rebase decision.

Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.

reviewDecision=; mergeStateStatus=CLEAN; pending=; stale_days=595

This loader options bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #9548: high-priority/blocker; labels: bug, high priority, orm, loader options; title: relationship loader options do a "recursive" thing inconsistently

This dml bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

ted SQL is valid; migrating the from_select case off the deprecated form (e.g. via the documented derived-table alias) seems to belong with #8626. Perhaps this one can be closed as fixed?

This mysql bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/dialects/mysql/, test/dialect/mysql/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #8341: good volunteer slice; labels: schema, mysql, fairly easy, PRs (with tests!) welcome; title: support MySQL 8.0.13's new magical syntax for function server defaults | issue #10310: good volunteer slice; labels: mysql, sql, PRs (with tests!) welcome, use case; title: Select Values in Mysql | issue #8457: good volunteer slice; labels: schema, mysql, reflection, PRs (with tests!) welcome; title: Support My...

This datatypes bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/sql/sqltypes.py, test/sql/test_types.py, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

it's #4384

This dml bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #13113: needs maintainer decision; labels: sqlite, use case, dml; title: SQLite insert supports multiple on-conflict clauses in inserts

This general bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #10676: needs maintainer decision; labels: setup; title: Add reasonable min version for the internal dialects packages / databases

This loader options bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

namespace.") > print(" Use ap.meta (base-class direct) instead of ap.Dog.meta.") > print("=" * 70) > ``` _Originally posted by @CaselIT in [#13193](https://github.com/sqlalchemy/sqlalchemy/issues/13193#issuecomment-4145377493)_ | There are a couple of cases where immediateload fails when using inheritance on relationships: - loading using immediateload a relationship on an inheritance chain that's being loaded via...

This orm bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/orm/, test/orm/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #13153: needs maintainer decision; labels: orm, use case; title: `composite` with in-place custom values getter

This performance bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/perf/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #13311: needs maintainer decision; labels: reflection, performance, use case; title: Provide a many-table version for has_table | issue #10541: needs maintainer decision; labels: performance, result fetching API improvements; title: Improve scalars performance by trying to avoid the creation of a Row

This reflection bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/engine/reflection.py, test/engine/test_reflection.py, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

what this issue is about, this issue is about constraints which are a totally different story. the extend_existing not deduping on name is #8925. | ### Describe the bug I'm getting duplicated index objects in the `MetaData` when using `DeferredReflection`. I think a similar issue might've been fixed in https://github.com/sqlalchemy/sqlalchemy/issues/3861. Similar problem has been reported in https://stackoverflow....

This tests bundle is concrete enough for a local PR draft package.

Draft locally against test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

r pypy? at some point we had to take pypy out of the testing pipeline Yes. I have two marked as failing in 1.4.46. One of them is linked to #8762, so might have been fixed already. The other was an exception message mismatch that I probably didn't report. Unfortunately, the te...

This typing bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/typing/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #13281: needs maintainer decision; labels: typing; title: Modernize type annotations to PEP 604 union syntax | issue #13253: needs maintainer decision; labels: bug, quagmire, typing; title: im not sure we can type hybrid_methods fully

This documentation bundle is concrete enough for a local PR draft package.

Draft locally against doc/, doc/build/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

Thanks for the great explanation mike. I've taken the liberty of creating a new issue to track this. See https://github.com/sqlalchemy/sqlalchemy/issues/5583 | eems like contains_eager() + join() is more appropriate here. 3. you're asking something about the very open ended warnings/error ticket in #5583 , I guess saying that the warning we have about FOR UPDATE doesnt apply to joinedload() if one is using "of". I...

This asyncio bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/ext/asyncio/, test/ext/asyncio/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #7604: good volunteer slice; labels: postgresql, PRs (with tests!) welcome, use case, asyncio; title: add execution option for asyncpg_timeout

This documentation bundle is concrete enough for a local PR draft package.

Draft locally against doc/, doc/build/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

in the narrative docs at https://docs.sqlalchemy.org/en/20/orm/declarative_mixins.html . it just needs the `@classmethod` part discussed at #9213. Yes, retrying with those changes, I've got it working. It's still not clear to me what generic type I should be using for an annot... | in the narrative docs at https://docs.sqlalchemy.org/en/20/orm/declarative_mixins.html . it just needs the `@classmethod` part discuss...

This engine bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/engine/, test/engine/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

I have a `Session` model with a `hash` column of the `Binary` type, and a `User` model with a relationship of `sessions`. If I get attributes through `inspect(user).attrs`, calling `attr.load_history()` on the `sessions` attribute will cause this [string argument without an en...

This general bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #7149: good volunteer slice; labels: feature, sqlalchemy.ext, fairly easy; title: Automap: prefer snake_case over lower() for relationship attribute names

This oracle bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/dialects/oracle/, test/dialect/oracle/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #5133: good volunteer slice; labels: sql, oracle, SQL Server, PRs (with tests!) welcome, use case, patch provided; title: Add APPLY operator support for mssql | issue #11312: good volunteer slice; labels: oracle, reflection, PRs (with tests!) welcome; title: reflecting oracle synonym of synonym over dblink

This orm bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/orm/, test/orm/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #7732: good volunteer slice; labels: feature, orm, fairly easy; title: add new execution option "log_note", implement for ORM queries | issue #6084: good volunteer slice; labels: orm, fairly easy, use case; title: 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

This postgresql bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/dialects/postgresql/, test/dialect/postgresql/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #4434: good volunteer slice; labels: postgresql, feature, schema, PRs (with tests!) welcome; title: Support for functions in UniqueConstraint

This schema bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/sql/schema.py, test/sql/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #10341: good volunteer slice; labels: schema, naming conventions, PRs (with tests!) welcome; title: add official API to have naming conventions work for alternate constraint types

This sql bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

issue #5564: good volunteer slice; labels: sql, fairly easy, use case; title: add limit() / offset() to CTE, as CTE.union() produces a CTE and not a CompoundSelect | issue #5846: good volunteer slice; labels: sql, fairly easy; title: Support reverse bitwise operations | issue #8352: good volunteer slice; labels: sql, PRs (with tests!) welcome, use case; title: Named window functions

This sqlite bundle is concrete enough for a local PR draft package.

Draft locally against lib/sqlalchemy/dialects/sqlite/, test/dialect/test_sqlite.py, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.

Possible related issues #12585 and #8795 shared tokens: autocommit, sqlite, support

The local evidence indicates likely related reports that should share one canonical answer or implementation path.

Pick the canonical issue, preserve the strongest reproduction, and close/link duplicates in one maintainer pass.

issues #8326 and #10335 share title/component terms: orm, support

This is a orm stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issues #8070 and #8311 share title/component terms: add, method | issue #9197: stale/low urgency; labels: orm, use case, dataclasses; title: Support for mapping frozen dataclasses | issue #12575: stale/low urgency; labels: orm, use case; title: prefixing Composite Column Types | issue #9348: stale/low urgency; labels: bug, orm, unit of work; title: modify expunge() operation in uow to cascade along delete-orphan i...

This is a postgresql stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** we *do* truncate specifically for indexes, see #4289. | the `ForeignKeyConstraint` separately via `__table_args__` works like a charm. I'd note that, when I saw this, I though that it could solve #7706. But, I still get `NoReferencedTableError`, so I assume there is in fact no way to use `referred_column`, unless you construct all... | **Michael Bayer...

This is a asyncio stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #12972: stale/low urgency; labels: use case, asyncio; title: Move asyncio out of ext into the library proper | issue #12710: stale/low urgency; labels: bug, engine, asyncio; title: add extra shielding to async connection create | issue #12803: stale/low urgency; labels: use case, asyncio; title: Expose Two Phase Transaction in async layer | issue #6121: stale/low urgency; labels: engine, reflection, use case...

This is a connection pool stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #8693: stale/low urgency; labels: help wanted, documentation, connection pool, SQL Server, use case; title: sp_reset_connection not called on reused connections in pool. (MSSQL)

This is a datatypes stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #12628: stale/low urgency; labels: oracle, datatypes, use case, mariadb; title: Add support for MariaDB Vector data type | issue #11597: stale/low urgency; labels: bug, datatypes, typing; title: sqltypes.Enum not generic enough | issue #8936: stale/low urgency; labels: postgresql, datatypes, use case; title: Make the new PG Range aware of the its bounds data type | issue #6874: stale/low urgency; labels: bug...

This is a declarative stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #6411: stale/low urgency; labels: declarative, use case; title: add new attribute_declared event for decalrative, intercepts all declared attrs but particularly Column | issue #5806: stale/low urgency; labels: bug, declarative, quagmire; title: favor module names over table names when looking at the class target of a relationship, or dot separated names ? unsure | not sure we really need this but in any case...

This is a dialects stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #8321: stale/low urgency; labels: sql, use case, upserts, dialects; title: Unify INSERT ... ON CONFLICT / UPSERT / MERGE functionality in single implementation | issue #10680: stale/low urgency; labels: use case, dialects; title: upgrade default driver for psycopg, oracledb

This is a dml stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #12096: stale/low urgency; labels: bug, orm, hard orm, dml; title: delete with join and returning clause doesn't work on SQLAlchemy 2 | issue #10446: stale/low urgency; labels: orm, use case, dml; title: Support synonym with bulk_insert_mappings and insert

This is a documentation stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #11284: stale/low urgency; labels: bug, documentation, tests, schema; title: Missing batch_op.f() | issue #6332: stale/low urgency; labels: documentation, SQLA mypy plugin, typing; title: Documentation: use ORM declarative attributes in .values instead of kwargs in "ORM-enabled UPDATE statements"? | issue #11062: stale/low urgency; labels: documentation, orm, orm - annotated declarative; title: Could not de-...

This is a engine stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

as discussed at #3357, an additional execution option `dbapi_autocommit=True` that sets autocommit independently of setting an explicit isolation level would be | issue #5815: stale/low urgency; labels: engine, use case; title: Support transaction read only access mode API, implement for MySQL, PostgreSQL, Oracle, others

This is a functions stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #5006: stale/low urgency; labels: SQL Server, functions, use case; title: support for unusual function namespace separators

This is a general stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #10835: stale/low urgency; labels: bug, cextensions, orm - annotated declarative; title: sqlalchemy.util.OrderedSet does not work with v2 in ORM mappings | issue #10064: stale/low urgency; labels: bug, dataclasses, orm - annotated declarative; title: MappedAsDataclass, prohibit constructor use and/or creation for non-mapped classes, abstract, mixins | issue #2814: stale/low urgency; labels: feature, sqlalche...

This is a loader options stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #7426: stale/low urgency; labels: bug, orm, loader options, hard orm; title: targeting of highly self-referential id column within a subquery w contains_eager | issue #3037: stale/low urgency; labels: feature, orm, loader options; title: support setting load options on instances | issue #5964: stale/low urgency; labels: orm, loader options, use case; title: implement "sticky" option for load_only / defer (pe...

This is a mariadb stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #12561: stale/low urgency; labels: bug, mysql, mariadb; title: Recover two-phase in mysql is currently unusable since it uses a legacy row index method | issue #7228: stale/low urgency; labels: feature, sqlite, mariadb; title: Incorrect code for sa.values on SQLite and MariaDB

This is a mysql stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #4272: stale/low urgency; labels: feature, schema, mysql; title: suport MySQL inline indexes e.g. KEY(col) in DDL | issue #1909: stale/low urgency; labels: bug, mysql, reflection, quagmire; title: reflection issue with mysql, url with no schema failure

This is a oracle stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

scussed in https://github.com/sqlalchemy/sqlalchemy/discussions/7717 this is very trivial and I think we will be able to make use of it for #4379 in any case: ```py from sqlalchemy import Column from sqlalchemy import DateTime from sqlalchemy import MetaData from sqlalchemy im... | issue #12341: stale/low urgency; labels: oracle, use case; title: Add dialect-specific support for Oracle's FETCH EXACT/APPROXIMATE

This is a performance stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #4855: stale/low urgency; labels: bug, performance, quagmire; title: instance_state can't raise an informative exception due to performance concerns. write C function?

This is a public api stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #8680: stale/low urgency; labels: public api, typing; title: Better organize pep 484 types in the packages

This is a reflection stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #11385: stale/low urgency; labels: reflection, use case; title: Add additional information to the `ReflectedColumn` | issue #10742: stale/low urgency; labels: bug, SQL Server, reflection; title: Bad PrimaryKeyConstraint metadata for MSSQL temporary table | issue #10435: stale/low urgency; labels: SQL Server, reflection; title: sql server metadata.reflect() fails if your SQL Server connection uses "tempdb" as...

This is a schema stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

Follow up of #13006 Set to False the default value and remove the warning | issue #9233: stale/low urgency; labels: bug, schema; title: Expression index does not list all the columns

This is a sql stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #10780: stale/low urgency; labels: sql, use case; title: name with flat for aliased() | issue #10326: stale/low urgency; labels: sql, use case; title: Allow InstrumentedAttribute in corresponding_column | issue #9425: stale/low urgency; labels: bug, sql; title: tighten up compoundselect + textualselect use cases | issue #6700: stale/low urgency; labels: sql, use case; title: Improve creation of custom select...

This is a sql server stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

hi there - how interesting that the exact test case from #4250 is still failing though I would assume in a different way from what was fixed there. this limitation has more to do with SQL Server not bei | ` operator is supported in SQLAlchemy. So the statement `SELECT ~a.flag AS anon_1 FROM a` works and gives correct results. I've come across #4250 which seems related. ```py from sqlalchemy import * from sqlalchem...

This is a sqlite stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

pr #10545 declares a closing reference to issue #10544. | <!-- Provide a general summary of your proposed changes in the Title field above --> to fix the pysqlcipher broken usage in 2.0.22 with pysqlcipher3 new master ### Description issue fix : https://github.com/sqlalchemy/sqlalchemy/issues/10544 ### Checklist <!-- go over followin... | hi - we cant hardcode arbitrary driver names here. please use this patch ```...

This is a tests stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #9370: stale/low urgency; labels: bug, tests; title: Create a way to run all the examples in the pipeline | issue #7135: stale/low urgency; labels: bug, tests; title: mysql/test_for_update is very slow on ci | issue #6505: stale/low urgency; labels: tests, use case; title: Always include where cluases in delete statements -- at least in test cleanup | issue #6468: stale/low urgency; labels: bug, tests; title...

This is a typing stale issue batch, not a single code diagnosis.

Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.

issue #10417: stale/low urgency; labels: wontfix / out of scope, expected behavior, typing; title: mypy: coerced legacy syntax with subquery can not be typed | issue #8909: stale/low urgency; labels: help wanted, quagmire, typing; title: using @declared_attr does not recognize method as a classmethod unless one writes @classmethod explicitly (hence the workaround)

This documentation batch is waiting for reporter/contributor information.

Park or close unless existing evidence is enough for maintainers to reproduce without another ping.

issue #10531: waiting on contributor; labels: bug, documentation, awaiting info, orm - annotated declarative; title: Issue with relationship typing when using Declarative-Imparative Mapping

This general batch is waiting for reporter/contributor information.

Park or close unless existing evidence is enough for maintainers to reproduce without another ping.

issue #11136: waiting on contributor; labels: awaiting info, use case; title: Delete Propagation to Parent Table for Joined Table Inheritance

This orm batch is waiting for reporter/contributor information.

Park or close unless existing evidence is enough for maintainers to reproduce without another ping.

issue #5999: waiting on contributor; labels: help wanted, orm, awaiting info, use case, typing; title: Type annotations are not preserved by `declared_attr`, `hybrid_property`, and potentially other decorators