A read-only, public-safe backlog compression view. It turns individual notifications into an auditable maintainer work plan with linked evidence underneath. No GitHub writes are performed.
This static run compresses 186 open issues and 32 open PRs into 99 review groups, then into 11 recommended maintainer moves. Start with maintainer-owned unblock work, then repair-ready failing PRs, then PR lineages, then batch issue sweeps, then volunteer-ready bundles.
Stalled work where the next action is maintainer-owned, such as repo-owner test approval or final review.
Example: PRs waiting on repo-owner test approval are separated from contributor-blocked PRs, so maintainers can unblock them without rereading the full thread.
Open PRs with named failing checks, merge state, or concrete repair direction.
Older, superseded, or overlapping PR attempts that should be reviewed together.
Grouped issue families where one policy, duplicate, close, or clarification pass can cover several rows.
Contributor-ready issue slices with shared scope, labels, and test expectations.
The output does not act on GitHub. It turns individual notifications into evidence-bound review units.
The row is the compact decision object: move, why, next action, affected scope, confidence, and compact evidence. Expand a row to inspect its bundles; review threads and raw public evidence rows stay underneath for audit.
Ordered by maintainer workflow lane, then by attention score. Each row expands from action summary to bundle evidence without exposing raw API payloads.
PRs are stalled on repository-owner test approval rather than contributor changes.
Inspect or approve the gated run, then decide the linked PR and issues with the evidence thread open.
12 bundles | 24 issues | 18 PRs
high
pending: gerrit_reviewowner gatepending checks: gerrit_review12 package receipts
The local packet found no failed-check blocker; the next step is maintainer review, merge, close, rebase request, or takeover.
Review changed files, linked issues, and latest comments, then choose merge, close, rebase request, or maintainer takeover.
4 bundles | 3 issues | 4 PRs
medium
no failed-check blockerreviewDecision=mergeStateStatus=UNSTABLEpending=code_review4 package receipts
The failing job names are known, so maintainers can ask for or apply a focused check fix before re-review.
Fix or request fixes for the named static/type checks, rerun, then return to review only after the branch is green.
3 bundles | 2 issues | 4 PRs
high
pending: gerrit_reviewfailed static/type checksfailed checks: mypy-3.14pending owner gate: gerrit_review.3 package receipts
The blocker is merge state, so review should wait until the branch is updated against main.
Rebase or update the branch, rerun checks, then re-enter maintainer review.
3 bundles | 2 issues | 5 PRs
high
merge-state blockedmergeStateStatus=DIRTYbranch=feature/GH-11122/table-withbranch=issue_29433 package receipts
Multiple active or referenced PR attempts are connected, so maintainers should choose the current path before separate reviews diverge.
Review the current PR, older attempts, superseding links, and review guidance together; close, park, or merge in one lineage decision.
9 bundles | 24 issues | 15 PRs
high
pending: gerrit_reviewowner gatefailed static/type checksmerge-state blockedpending checks: gerrit_review9 package receipts
The next work is contributor-owned unless a maintainer chooses to take over or close the stale path.
Keep parked, close with context, or explicitly take over only when the evidence warrants maintainer work.
1 bundle | 1 issue | 1 PR
medium
requested changesreviewDecision=CHANGES_REQUESTEDstale_days=4791 package receipt
Old low-urgency rows can be handled as a policy batch instead of reopened one at a time.
Close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local draft.
25 bundles | 111 issues | 0 PRs
medium
issue #12972: stale/low urgencylabels: use case, asynciotitle: Move asyncio out of ext into the library properissue #12710: stale/low urgency25 package receipts
Related reports can share one canonical answer, close path, or implementation direction.
Pick the canonical issue, preserve the strongest reproduction, and close or link duplicates in one pass.
1 bundle | 2 issues | 0 PRs
medium
issues #8326 and #10335 share title/component terms: or...1 package receipt
These rows are waiting for reporter information unless existing evidence is enough for maintainer reproduction.
Park or close unless a maintainer can reproduce from the evidence already collected.
3 bundles | 3 issues | 0 PRs
medium
issue #10531: waiting on contributorlabels: bug, documentation, awaiting info, orm - annota...title: Issue with relationship typing when using Declar...issue #11136: waiting on contributor3 package receipts
The local evidence is concrete enough to plan a patch or design branch without writing to GitHub.
Draft locally, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.
11 bundles | 16 issues | 0 PRs
medium
patch-plan readyit's #4384issue #13113: needs maintainer decisionlabels: sqlite, use case, dml11 package receipts
The grouped issues share low-risk scope, labels, or documentation/test expectations suitable for contributors.
Publish or keep a local contributor-ready bundle with scope, expected files, tests, and linked issue context.
12 bundles | 22 issues | 0 PRs
medium
patch-plan readyThanks for the great explanation mike. I've taken the l...eems like contains_eager() + join() is more appropriate...issue #7604: good volunteer slice12 package receipts
Every open issue and PR is assigned to the smallest practical maintainer action bundle we would use to review, resolve, merge, close, link, park, or turn into a local PR draft package.
These are the units maintainers would review first. Raw rows and edges stay underneath for audit.
Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.
Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.
Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.
Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.
Keep parked or close after maintainer review if the contributor path is no longer active; do not ask for maintainer work first.
Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.
Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.
Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.
Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.
Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.
Every row is local-only and carries proof/test status; no action is sent to GitHub.
| Bundle | Kind | Covers | Diagnosis | Recommended Next Step | Local Proof/Test | GitHub Action Allowed |
|---|---|---|---|---|---|---|
| SIM-001 | Existing PR owner-test gate waiting on repo-owner test approval | #8992 PR #13323 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-002 | Existing PR blocked review waiting on maintainer review | #10748 PR #13402 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-003 | Existing PR contributor wait waiting on repo-owner test approval | #13157 PR #13303 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-004 | Existing PR contributor wait waiting on repo-owner test approval | #9410#9493#9930#10094#13227 PR #13289 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-005 | Existing PR contributor wait waiting on contributor | #6274 PR #12433 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-006 | Existing PR owner-test gate waiting on repo-owner test approval | #6511#9693 PR #12697PR #12698PR #13418 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-007 | Existing PR blocked review waiting on maintainer review | #13420 PR #13421 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-008 | Existing PR owner-test gate waiting on repo-owner test approval | #13407 PR #13405 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-009 | Existing PR owner-test gate waiting on repo-owner test approval | #13406 PR #13404 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-010 | Existing PR owner-test gate waiting on repo-owner test approval | #13048 PR #13399 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-011 | Existing PR owner-test gate waiting on repo-owner test approval | #13419 PR #13398 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-012 | Existing PR owner-test gate waiting on repo-owner test approval | #11132 PR #13368 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-013 | Existing PR contributor wait waiting on repo-owner test approval | #13169 PR #13288 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-014 | Existing PR contributor wait waiting on CI/check fix | #13049 PR #13051 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-015 | Existing PR decision waiting on maintainer review | #11620 PR #12297 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-016 | Existing PR contributor wait waiting on branch update | #11122 PR #11296 | PR #11296 appears blocked by merge state `DIRTY`. | Rebase/update the branch against main, then rerun checks before maintainer review. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-017 | Existing PR decision waiting on repo-owner test approval | #6120#6810#9301#9587#10351#10527#10888#11686#13357 PR #12731 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-018 | Existing PR blocked review waiting on CI/check fix | #12398 PR #12401 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-019 | Existing PR blocked review waiting on branch update | #2943 PR #10574 | PR #10574 appears blocked by merge state `DIRTY`. | Rebase/update the branch against main, then rerun checks before maintainer review. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-020 | Existing PR blocked review waiting on CI/check fix | none PR #8136PR #12645 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-021 | Existing PR contributor wait waiting on branch update | none PR #11107PR #11297PR #11437 | PR #11437 appears blocked by merge state `DIRTY`. | Rebase/update the branch against main, then rerun checks before maintainer review. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-022 | Existing PR owner-test gate waiting on repo-owner test approval | none PR #13137PR #13312PR #13415PR #13416PR #13417 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-023 | Existing stale PR sweep waiting on maintainer review | none PR #11180 | 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. | simulated_plan_only: Use the existing PR checks, review decision, changed-file list, and any pending/failed status as the proof gate before merge/close. | False |
| SIM-024 | Duplicate/related issue sweep good volunteer slice | #8326#10335 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-025 | New code/decision package needs maintainer decision | #13212 none | 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. | simulated_plan_only: Run focused tests for datatypes paths plus one regression test per resolved issue cluster. | False |
| SIM-026 | New code/decision package needs maintainer decision | #13113 none | 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. | simulated_plan_only: Run focused tests for dml paths plus one regression test per resolved issue cluster. | False |
| SIM-027 | New code/decision package needs maintainer decision | #10676 none | 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. | simulated_plan_only: Run focused tests for general paths plus one regression test per resolved issue cluster. | False |
| SIM-028 | New code/decision package needs maintainer decision | #13204#13210 none | 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. | simulated_plan_only: Run focused tests for loader options paths plus one regression test per resolved issue cluster. | False |
| SIM-029 | New code/decision package needs maintainer decision | #13153 none | 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. | simulated_plan_only: Run focused ORM tests plus regression tests named from the linked issue titles. | False |
| SIM-030 | New code/decision package needs maintainer decision | #10541#13311 none | 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. | simulated_plan_only: Run focused tests for performance paths plus one regression test per resolved issue cluster. | False |
| SIM-031 | New code/decision package needs maintainer decision | #7366#9468 none | 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. | simulated_plan_only: Run focused tests for reflection paths plus one regression test per resolved issue cluster. | False |
| SIM-032 | New code/decision package duplicate/cluster candidate | #8795#12585 none | 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. | simulated_plan_only: Run the focused dialect test slice for sqlite, plus any changed-file tests inferred from lib/sqlalchemy/dialects/sqlite/, test/dialect/test_sqlite.py. | False |
| SIM-033 | New code/decision package needs maintainer decision | #9154 none | 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. | simulated_plan_only: Run focused tests for tests paths plus one regression test per resolved issue cluster. | False |
| SIM-034 | New code/decision package needs maintainer decision | #13253#13281 none | 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. | simulated_plan_only: Run typing-oriented tests and the smallest runtime regression test for affected public behavior. | False |
| SIM-035 | New maintainer code PR high-priority/blocker | #9548 none | 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. | simulated_plan_only: Run focused tests for loader options paths plus one regression test per resolved issue cluster. | False |
| SIM-036 | New docs PR needs maintainer decision | #5583#12101 none | 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. | simulated_plan_only: Build docs locally and run focused documentation/link checks for the touched doc paths. | False |
| SIM-037 | New volunteer-ready PR good volunteer slice | #7604 none | 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. | simulated_plan_only: Run focused asyncio extension tests and a regression test for the linked failure mode. | False |
| SIM-038 | New volunteer-ready PR good volunteer slice | #10675 none | 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. | simulated_plan_only: Run focused tests for dml paths plus one regression test per resolved issue cluster. | False |
| SIM-039 | New volunteer-ready PR good volunteer slice | #5139#9078#9212#9213 none | 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. | simulated_plan_only: Build docs locally and run focused documentation/link checks for the touched doc paths. | False |
| SIM-040 | New volunteer-ready PR good volunteer slice | #5123 none | 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. | simulated_plan_only: Run focused tests for engine paths plus one regression test per resolved issue cluster. | False |
| SIM-041 | New volunteer-ready PR good volunteer slice | #7149 none | 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. | simulated_plan_only: Run focused tests for general paths plus one regression test per resolved issue cluster. | False |
| SIM-042 | New volunteer-ready PR good volunteer slice | #8341#8457#10310 none | 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. | simulated_plan_only: Run the focused dialect test slice for mysql, plus any changed-file tests inferred from lib/sqlalchemy/dialects/mysql/, test/dialect/mysql/. | False |
| SIM-043 | New volunteer-ready PR good volunteer slice | #5133#11312 none | 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. | simulated_plan_only: Run the focused dialect test slice for oracle, plus any changed-file tests inferred from lib/sqlalchemy/dialects/oracle/, test/dialect/oracle/. | False |
| SIM-044 | New volunteer-ready PR good volunteer slice | #6084#7732 none | 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. | simulated_plan_only: Run focused ORM tests plus regression tests named from the linked issue titles. | False |
| SIM-045 | New volunteer-ready PR good volunteer slice | #4434 none | 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. | simulated_plan_only: Run the focused dialect test slice for postgresql, plus any changed-file tests inferred from lib/sqlalchemy/dialects/postgresql/, test/dialect/postgresql/. | False |
| SIM-046 | New volunteer-ready PR good volunteer slice | #10341 none | 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. | simulated_plan_only: Run focused tests for schema paths plus one regression test per resolved issue cluster. | False |
| SIM-047 | New volunteer-ready PR good volunteer slice | #5564#5846#8352 none | 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. | simulated_plan_only: Run focused tests for sql paths plus one regression test per resolved issue cluster. | False |
| SIM-048 | Stale issue resolution sweep stale/low urgency | #6121#12710#12803#12972 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-049 | Stale issue resolution sweep stale/low urgency | #8693 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-050 | Stale issue resolution sweep stale/low urgency | #4652#6874#7223#8936#11597#12628 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-051 | Stale issue resolution sweep stale/low urgency | #5806#6411#9147 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-052 | Stale issue resolution sweep stale/low urgency | #8321#10680 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-053 | Stale issue resolution sweep stale/low urgency | #10446#12096 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-054 | Stale issue resolution sweep stale/low urgency | #4567#4706#4784#4790#5235#6332#7360#7517#8894#9839+4 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-055 | Stale issue resolution sweep stale/low urgency | #5815#6489 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-056 | Stale issue resolution sweep stale/low urgency | #5006 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-057 | Stale issue resolution sweep stale/low urgency | #2814#10064#10835 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-058 | Stale issue resolution sweep stale/low urgency | #3037#5964#7426#8431 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-059 | Stale issue resolution sweep stale/low urgency | #7228#12561 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-060 | Stale issue resolution sweep stale/low urgency | #1909#4272 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-061 | Stale issue resolution sweep stale/low urgency | #7718#12341 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-062 | Stale issue resolution sweep stale/low urgency | #1063#1140#2501#2792#3458#4641#5005#5541#6080#6137+21 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-063 | Stale issue resolution sweep stale/low urgency | #4855 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-064 | Stale issue resolution sweep stale/low urgency | #4289#5350#6612#7475#9944 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-065 | Stale issue resolution sweep stale/low urgency | #8680 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-066 | Stale issue resolution sweep stale/low urgency | #10435#10742#11385#11677 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-067 | Stale issue resolution sweep stale/low urgency | #9233#13007 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-068 | Stale issue resolution sweep stale/low urgency | #1452#6040#6336#6700#7113#9425#10326#10780 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-069 | Stale issue resolution sweep stale/low urgency | #5352 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-070 | Stale issue resolution sweep stale/low urgency | #10544 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-071 | Stale issue resolution sweep stale/low urgency | #5174#6468#6505#7035#7135#8805#9370 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-072 | Stale issue resolution sweep stale/low urgency | #8909#10417 none | 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. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-073 | Waiting-info issue sweep waiting on contributor | #10531 none | This documentation batch is waiting for reporter/contributor information. | Park or close unless existing evidence is enough for maintainers to reproduce without another ping. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-074 | Waiting-info issue sweep waiting on contributor | #11136 none | This general batch is waiting for reporter/contributor information. | Park or close unless existing evidence is enough for maintainers to reproduce without another ping. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
| SIM-075 | Waiting-info issue sweep waiting on contributor | #5999 none | This orm batch is waiting for reporter/contributor information. | Park or close unless existing evidence is enough for maintainers to reproduce without another ping. | simulated_plan_only: No code patch is simulated; proof is the issue/PR evidence pack, duplicate links, stale age, labels, and maintainer-visible closure/reopen criteria. | False |
This is the next step after compression: each bundle gets the best local diagnosis we can make from checks, merge state, review comments, linked issues, files, and stale/label evidence.
| Bundle | Diagnosis Kind | Diagnosis | Recommended Next Step | Covers | Confidence | Evidence |
|---|---|---|---|---|---|---|
| SIM-018 Existing PR blocked review | failed_static_checks | 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. | #12398 PR #12401 | high | 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... |
| SIM-020 Existing PR blocked review | failed_static_checks | 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. | none PR #8136PR #12645 | high | failed checks: pep484-3.12; pending owner gate: gerrit_review. |
| SIM-014 Existing PR contributor wait | failed_static_checks | 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. | #13049 PR #13051 | high | failed checks: mypy-3.14; pending owner gate: gerrit_review. |
| SIM-019 Existing PR blocked review | merge_state_blocked | PR #10574 appears blocked by merge state `DIRTY`. | Rebase/update the branch against main, then rerun checks before maintainer review. | #2943 PR #10574 | high | mergeStateStatus=DIRTY; branch=issue_2943 |
| SIM-016 Existing PR contributor wait | merge_state_blocked | PR #11296 appears blocked by merge state `DIRTY`. | Rebase/update the branch against main, then rerun checks before maintainer review. | #11122 PR #11296 | high | mergeStateStatus=DIRTY; branch=feature/GH-11122/table-with |
| SIM-021 Existing PR contributor wait | merge_state_blocked | PR #11437 appears blocked by merge state `DIRTY`. | Rebase/update the branch against main, then rerun checks before maintainer review. | none PR #11107PR #11297PR #11437 | high | mergeStateStatus=DIRTY; branch=fix-examples-2 |
| SIM-001 Existing PR owner-test gate | owner_test_approval_gate | 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. | #8992 PR #13323 | high | pending checks: gerrit_review |
| SIM-006 Existing PR owner-test gate | owner_test_approval_gate | 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. | #6511#9693 PR #12697PR #12698PR #13418 | high | pending checks: gerrit_review |
| SIM-008 Existing PR owner-test gate | owner_test_approval_gate | 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. | #13407 PR #13405 | high | pending checks: gerrit_review |
| SIM-009 Existing PR owner-test gate | owner_test_approval_gate | 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. | #13406 PR #13404 | high | pending checks: gerrit_review |
| SIM-010 Existing PR owner-test gate | owner_test_approval_gate | 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. | #13048 PR #13399 | high | pending checks: gerrit_review |
| SIM-011 Existing PR owner-test gate | owner_test_approval_gate | 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. | #13419 PR #13398 | high | pending checks: gerrit_review |
| SIM-012 Existing PR owner-test gate | owner_test_approval_gate | 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. | #11132 PR #13368 | high | pending checks: gerrit_review |
| SIM-003 Existing PR contributor wait | owner_test_approval_gate | 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. | #13157 PR #13303 | high | pending checks: gerrit_review |
| SIM-022 Existing PR owner-test gate | owner_test_approval_gate | 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. | none PR #13137PR #13312PR #13415PR #13416PR #13417 | high | pending checks: gerrit_review |
| SIM-004 Existing PR contributor wait | owner_test_approval_gate | 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. | #9410#9493#9930#10094#13227 PR #13289 | high | pending checks: gerrit_review |
| SIM-013 Existing PR contributor wait | owner_test_approval_gate | 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. | #13169 PR #13288 | high | pending checks: gerrit_review |
| SIM-017 Existing PR decision | owner_test_approval_gate | 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. | #6120#6810#9301#9587#10351#10527#10888#11686#13357 PR #12731 | high | pending checks: gerrit_review |
| SIM-005 Existing PR contributor wait | contributor_update_needed | 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. | #6274 PR #12433 | medium | reviewDecision=CHANGES_REQUESTED; stale_days=479 |
| SIM-002 Existing PR blocked review | maintainer_decision_needed | 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. | #10748 PR #13402 | medium | reviewDecision=; mergeStateStatus=UNSTABLE; pending=code_review; stale_days=8 |
| SIM-007 Existing PR blocked review | maintainer_decision_needed | 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. | #13420 PR #13421 | medium | reviewDecision=; mergeStateStatus=UNSTABLE; pending=code_review; stale_days=0 |
| SIM-015 Existing PR decision | maintainer_decision_needed | 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. | #11620 PR #12297 | medium | reviewDecision=; mergeStateStatus=CLEAN; pending=; stale_days=473 |
| SIM-023 Existing stale PR sweep | maintainer_decision_needed | 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. | none PR #11180 | medium | reviewDecision=; mergeStateStatus=CLEAN; pending=; stale_days=595 |
| SIM-035 New maintainer code PR | local_pr_draft_candidate | 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. | #9548 none | medium | issue #9548: high-priority/blocker; labels: bug, high priority, orm, loader options; title: relationship loader options do a "recursive" thing inconsistently |
| SIM-038 New volunteer-ready PR | local_pr_draft_candidate | 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. | #10675 none | medium | 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? |
| SIM-042 New volunteer-ready PR | local_pr_draft_candidate | 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. | #8341#8457#10310 none | medium | 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... |
| SIM-025 New code/decision package | local_pr_draft_candidate | 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. | #13212 none | medium | it's #4384 |
| SIM-026 New code/decision package | local_pr_draft_candidate | 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. | #13113 none | medium | issue #13113: needs maintainer decision; labels: sqlite, use case, dml; title: SQLite insert supports multiple on-conflict clauses in inserts |
| SIM-027 New code/decision package | local_pr_draft_candidate | 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. | #10676 none | medium | issue #10676: needs maintainer decision; labels: setup; title: Add reasonable min version for the internal dialects packages / databases |
| SIM-028 New code/decision package | local_pr_draft_candidate | 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. | #13204#13210 none | medium | 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... |
| SIM-029 New code/decision package | local_pr_draft_candidate | 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. | #13153 none | medium | issue #13153: needs maintainer decision; labels: orm, use case; title: `composite` with in-place custom values getter |
| SIM-030 New code/decision package | local_pr_draft_candidate | 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. | #10541#13311 none | medium | 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 |
| SIM-031 New code/decision package | local_pr_draft_candidate | 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. | #7366#9468 none | medium | 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.... |
| SIM-033 New code/decision package | local_pr_draft_candidate | 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. | #9154 none | medium | 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... |
| SIM-034 New code/decision package | local_pr_draft_candidate | 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. | #13253#13281 none | medium | 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 |
| SIM-036 New docs PR | local_pr_draft_candidate | 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. | #5583#12101 none | medium | 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... |
| SIM-037 New volunteer-ready PR | local_pr_draft_candidate | 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. | #7604 none | medium | issue #7604: good volunteer slice; labels: postgresql, PRs (with tests!) welcome, use case, asyncio; title: add execution option for asyncpg_timeout |
| SIM-039 New volunteer-ready PR | local_pr_draft_candidate | 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. | #5139#9078#9212#9213 none | medium | 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... |
| SIM-040 New volunteer-ready PR | local_pr_draft_candidate | 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. | #5123 none | medium | 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... |
| SIM-041 New volunteer-ready PR | local_pr_draft_candidate | 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. | #7149 none | medium | issue #7149: good volunteer slice; labels: feature, sqlalchemy.ext, fairly easy; title: Automap: prefer snake_case over lower() for relationship attribute names |
| SIM-043 New volunteer-ready PR | local_pr_draft_candidate | 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. | #5133#11312 none | medium | 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 |
| SIM-044 New volunteer-ready PR | local_pr_draft_candidate | 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. | #6084#7732 none | medium | 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 |
| SIM-045 New volunteer-ready PR | local_pr_draft_candidate | 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. | #4434 none | medium | issue #4434: good volunteer slice; labels: postgresql, feature, schema, PRs (with tests!) welcome; title: Support for functions in UniqueConstraint |
| SIM-046 New volunteer-ready PR | local_pr_draft_candidate | 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. | #10341 none | medium | 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 |
| SIM-047 New volunteer-ready PR | local_pr_draft_candidate | 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. | #5564#5846#8352 none | medium | 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 |
| SIM-032 New code/decision package | local_pr_draft_candidate | 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. | #8795#12585 none | medium | Possible related issues #12585 and #8795 shared tokens: autocommit, sqlite, support |
| SIM-024 Duplicate/related issue sweep | duplicate_consolidation | 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. | #8326#10335 none | medium | issues #8326 and #10335 share title/component terms: orm, support |
| SIM-062 Stale issue resolution sweep | stale_batch_policy | 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. | #1063#1140#2501#2792#3458#4641#5005#5541#6080#6137+21 none | medium | 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... |
| SIM-064 Stale issue resolution sweep | stale_batch_policy | 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. | #4289#5350#6612#7475#9944 none | medium | **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... |
| SIM-048 Stale issue resolution sweep | stale_batch_policy | 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. | #6121#12710#12803#12972 none | medium | 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... |
| SIM-049 Stale issue resolution sweep | stale_batch_policy | 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. | #8693 none | medium | 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) |
| SIM-050 Stale issue resolution sweep | stale_batch_policy | 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. | #4652#6874#7223#8936#11597#12628 none | medium | 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... |
| SIM-051 Stale issue resolution sweep | stale_batch_policy | 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. | #5806#6411#9147 none | medium | 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... |
| SIM-052 Stale issue resolution sweep | stale_batch_policy | 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. | #8321#10680 none | medium | 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 |
| SIM-053 Stale issue resolution sweep | stale_batch_policy | 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. | #10446#12096 none | medium | 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 |
| SIM-054 Stale issue resolution sweep | stale_batch_policy | 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. | #4567#4706#4784#4790#5235#6332#7360#7517#8894#9839+4 none | medium | 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-... |
| SIM-055 Stale issue resolution sweep | stale_batch_policy | 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. | #5815#6489 none | medium | 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 |
| SIM-056 Stale issue resolution sweep | stale_batch_policy | 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. | #5006 none | medium | issue #5006: stale/low urgency; labels: SQL Server, functions, use case; title: support for unusual function namespace separators |
| SIM-057 Stale issue resolution sweep | stale_batch_policy | 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. | #2814#10064#10835 none | medium | 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... |
| SIM-058 Stale issue resolution sweep | stale_batch_policy | 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. | #3037#5964#7426#8431 none | medium | 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... |
| SIM-059 Stale issue resolution sweep | stale_batch_policy | 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. | #7228#12561 none | medium | 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 |
| SIM-060 Stale issue resolution sweep | stale_batch_policy | 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. | #1909#4272 none | medium | 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 |
| SIM-061 Stale issue resolution sweep | stale_batch_policy | 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. | #7718#12341 none | medium | 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 |
| SIM-063 Stale issue resolution sweep | stale_batch_policy | 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. | #4855 none | medium | 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? |
| SIM-065 Stale issue resolution sweep | stale_batch_policy | 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. | #8680 none | medium | issue #8680: stale/low urgency; labels: public api, typing; title: Better organize pep 484 types in the packages |
| SIM-066 Stale issue resolution sweep | stale_batch_policy | 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. | #10435#10742#11385#11677 none | medium | 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... |
| SIM-067 Stale issue resolution sweep | stale_batch_policy | 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. | #9233#13007 none | medium | 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 |
| SIM-068 Stale issue resolution sweep | stale_batch_policy | 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. | #1452#6040#6336#6700#7113#9425#10326#10780 none | medium | 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... |
| SIM-069 Stale issue resolution sweep | stale_batch_policy | 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. | #5352 none | medium | 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... |
| SIM-070 Stale issue resolution sweep | stale_batch_policy | 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. | #10544 none | medium | 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 ```... |
| SIM-071 Stale issue resolution sweep | stale_batch_policy | 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. | #5174#6468#6505#7035#7135#8805#9370 none | medium | 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... |
| SIM-072 Stale issue resolution sweep | stale_batch_policy | 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. | #8909#10417 none | medium | 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) |
| SIM-073 Waiting-info issue sweep | waiting_for_reporter_info | This documentation batch is waiting for reporter/contributor information. | Park or close unless existing evidence is enough for maintainers to reproduce without another ping. | #10531 none | medium | issue #10531: waiting on contributor; labels: bug, documentation, awaiting info, orm - annotated declarative; title: Issue with relationship typing when using Declarative-Imparative Mapping |
| SIM-074 Waiting-info issue sweep | waiting_for_reporter_info | This general batch is waiting for reporter/contributor information. | Park or close unless existing evidence is enough for maintainers to reproduce without another ping. | #11136 none | medium | issue #11136: waiting on contributor; labels: awaiting info, use case; title: Delete Propagation to Parent Table for Joined Table Inheritance |
| SIM-075 Waiting-info issue sweep | waiting_for_reporter_info | This orm batch is waiting for reporter/contributor information. | Park or close unless existing evidence is enough for maintainers to reproduce without another ping. | #5999 none | medium | 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 |
Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. Every open issue appears in one or more review threads; raw issue rows remain downloadable below.
| Review Thread | Issues | Issue Numbers | Active PRs | Next Action | Confidence |
|---|---|---|---|---|---|
| PR #13323 - Apply tuple bind expressions to expanding IN values linked work thread · waiting on repo-owner test approval | 1 | #8992 | PR #13323 | Approve or inspect gated test run(s) for PR #13323, then review the thread evidence together. | high |
| PR #13402 - Allow inspection registrations from module reloads linked work thread · waiting on CI/check fix | 1 | #10748 | PR #13402 | Review active PRs and linked issues as one maintainer work thread. | high |
| PR #13303 - Fix PostgreSQL CHECK constraint reflection stripping unrelated parens linked work thread · waiting on contributor | 1 | #13157 | PR #13303 | Wait for contributor update on PR #13303; keep related issue/PR context attached. | high |
| PR #13289 - fix: raise clear error when default_factory/default passed to WriteOnlyMapped/DynamicMapped relationship linked work thread · waiting on contributor | 5 | #9410#9493#9930#10094#13227 | PR #13289 | Wait for contributor update on PR #13289; keep related issue/PR context attached. | high |
| PR #12433 - Coerce aliased Select and CompoundSelect to subquery linked work thread · waiting on contributor | 1 | #6274 | PR #12433 | Wait for contributor update on PR #12433; keep related issue/PR context attached. | high |
| PR #12697 - Support schema-qualified collation in types for PostgreSQL linked work thread · waiting on repo-owner test approval | 2 | #6511#9693 | PR #12697PR #12698PR #13418 | Approve or inspect gated test run(s) for PR #13418, then review the thread evidence together. | high |
| PR #13421 - Fix oracledb async dialect entering cursors synchronously linked work thread · waiting on CI/check fix | 1 | #13420 | PR #13421 | Review active PRs and linked issues as one maintainer work thread. | high |
| PR #13405 - Cython batch instance processor — ~10–30% on most loads (collection joinedload −5%) linked work thread · waiting on repo-owner test approval | 1 | #13407 | PR #13405 | Approve or inspect gated test run(s) for PR #13405, then review the thread evidence together. | high |
| PR #13404 - Subqueryload without per-row Row construction — ~26% on subqueryload linked work thread · waiting on repo-owner test approval | 1 | #13406 | PR #13404 | Approve or inspect gated test run(s) for PR #13404, then review the thread evidence together. | high |
| PR #13399 - UniqueConstraint and Index withheld from table via attach_to_table flag, and appended to table via append_constraint linked work thread · waiting on repo-owner test approval | 1 | #13048 | PR #13399 | Approve or inspect gated test run(s) for PR #13399, then review the thread evidence together. | high |
| PR #13398 - fix catastrophic backtracking in sqlite inline unique reflection regex linked work thread · waiting on repo-owner test approval | 1 | #13419 | PR #13398 | Approve or inspect gated test run(s) for PR #13398, then review the thread evidence together. | high |
| PR #13368 - Document deprecated MySQL (M,D) float syntax and improve error message linked work thread · waiting on repo-owner test approval | 1 | #11132 | PR #13368 | Approve or inspect gated test run(s) for PR #13368, then review the thread evidence together. | high |
| PR #13288 - fix(pool): use time.monotonic() instead of time.time() for connection timestamps linked work thread · waiting on contributor | 1 | #13169 | PR #13288 | Wait for contributor update on PR #13288; keep related issue/PR context attached. | high |
| PR #13051 - Added implementations for avg & abs linked work thread · waiting on contributor | 1 | #13049 | PR #13051 | Wait for contributor update on PR #13051; keep related issue/PR context attached. | high |
| PR #12297 - refactor(MSExecutionContext): improve identity insert handling and va… linked work thread · has linked issue | 1 | #11620 | PR #12297 | Review active PRs and linked issues as one maintainer work thread. | high |
| PR #11296 - Ability to specify `WITH` when creating a table + fixes `WITH` when creating an index linked work thread · waiting on contributor | 1 | #11122 | PR #11296 | Wait for contributor update on PR #11296; keep related issue/PR context attached. | high |
| PR #12731 - fix(typing): allow DeclarativeBase subclasses in with_for_update(of=...) linked work thread · draft/noise | 9 | #6120#6810#9301#9587#10351#10527#10888#11686#13357 | PR #12731 | Review active PRs and linked issues as one maintainer work thread. | high |
| PR #12401 - Make loader strategy error message more verbose linked work thread · waiting on CI/check fix | 1 | #12398 | PR #12401 | Review active PRs and linked issues as one maintainer work thread. | high |
| PR #10574 - fixes: #2943, allow overriding validates for inheritance linked work thread · waiting on CI/check fix | 1 | #2943 | PR #10574 | Review active PRs and linked issues as one maintainer work thread. | high |
| Review thread: 1 issue - Issue #7035 - Use innodb in the test suite when using mysql/mariadb linked work thread · stale/low urgency | 1 | #7035 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #11677 - SQLITE: SQLiteDialect.get_check_constraints incorrectly reflects multiline check constraints linked work thread · stale/low urgency | 1 | #11677 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #10544 - pysqlcipher open fail with err: TypeError: function takes at most 3 arguments (4 given) in dbapi_connection.create_function linked work thread · stale/low urgency | 1 | #10544 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #10675 - syntax error with mysql bulk update via INSERT ... SELECT ... ON DUPLICATE KEY UPDATE related issue thread · good volunteer slice | 1 | #10675 | none | good volunteer slice | high |
| Review thread: 2 issues - Issue #13204 - Immediateload fails to load when combined with inheritance related issue thread · needs maintainer decision | 2 | #13204#13210 | none | needs maintainer decision | high |
| Review thread: 2 issues - Issue #12101 - Better support of locking clauses (FOR UPDATE/SHARE) when supported related issue thread · needs maintainer decision | 2 | #5583#12101 | none | needs maintainer decision | high |
| Review thread: 1 issue - Issue #9154 - 11 test failures with PyPy3.9 7.3.11 in 2.0.0 (and git main) related issue thread · needs maintainer decision | 1 | #9154 | none | needs maintainer decision | high |
| Review thread: 1 issue - Issue #7366 - extend_existing will add copies of indexes, constraints, etc. as there is no deduplication on name related issue thread · needs maintainer decision | 1 | #7366 | none | needs maintainer decision | high |
| Review thread: 1 issue - Issue #13212 - Support for native JSON in mssql related issue thread · needs maintainer decision | 1 | #13212 | none | needs maintainer decision | high |
| Review thread: 2 issues - Issue #9212 - add additional type migration section to whatsnew detailing declared_attr format changes, others related issue thread · good volunteer slice | 2 | #9212#9213 | none | good volunteer slice | high |
| Review thread: 2 issues - Issue #4289 - support None for index name related issue thread · stale/low urgency | 2 | #4289#5350 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #5123 - apply informative re-raise if a result processor function fails related issue thread · good volunteer slice | 1 | #5123 | none | good volunteer slice | high |
| Review thread: 2 issues - Issue #6040 - allow clauseelements in hint text related issue thread · stale/low urgency | 2 | #6040#7113 | none | stale/low urgency | high |
| Review thread: 2 issues - Issue #4784 - Default MetaData kwarg naming_convention can create issues with certain databases related issue thread · stale/low urgency | 2 | #4784#4790 | none | stale/low urgency | high |
| Review thread: 2 issues - Issue #12585 - support SQLite .autocommit=False mode, improve documentation related issue thread · duplicate/cluster candidate | 2 | #8795#12585 | none | Compare related issues before writing separate answers. | high |
| Review thread: 2 issues - Issue #10859 - move lazy="select" to lazy="mapper_default"; add mapper "default_lazy" related issue thread · stale/low urgency | 2 | #4641#10859 | none | stale/low urgency | high |
| Review thread: 2 issues - Issue #1063 - self-referential / mutually dependent FK flush() should not require post_update for an UPDATE only query related issue thread · stale/low urgency | 2 | #1063#10936 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #9839 - document network-related caveats for insertmanyvalues related issue thread · stale/low urgency | 1 | #9839 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #9690 - reroute group_by coercion to expand fromclause using ORM-enabled plugin points related issue thread · stale/low urgency | 1 | #9690 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #9147 - declarative builds permanent strong ref to classes that use declare_first or declare_last related issue thread · stale/low urgency | 1 | #9147 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #9082 - eager_defaults shouldn't be needed for pk returning even if cols are not actual pks related issue thread · stale/low urgency | 1 | #9082 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #8431 - implement include_join=False for selectin_polymorphic related issue thread · stale/low urgency | 1 | #8431 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #7718 - create oracle_dblink table option related issue thread · stale/low urgency | 1 | #7718 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #7475 - Support for postgresql aggregate options related issue thread · stale/low urgency | 1 | #7475 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #7223 - unified approach for Emulated (was: Interval type should not subclass from `TypeDecorator`) related issue thread · stale/low urgency | 1 | #7223 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #6997 - investigate very intricate correlation / any() / self referential case related issue thread · stale/low urgency | 1 | #6997 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #6612 - Cannot build SQL expression NOT(x IS NULL) on Postgres related issue thread · stale/low urgency | 1 | #6612 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #6489 - support autocommit w/ explicit isolation levels related issue thread · stale/low urgency | 1 | #6489 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #5352 - Can not select negated boolean column in MS SQL Server related issue thread · stale/low urgency | 1 | #5352 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #5005 - alter ORM-level "returned rows" checks to only warn if driver returns -1 or None related issue thread · stale/low urgency | 1 | #5005 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #4652 - Unclear How to Properly Include an ON UPDATE Clause in DDL for Column related issue thread · stale/low urgency | 1 | #4652 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #4567 - SQLite on_conflict not working with ORM related issue thread · stale/low urgency | 1 | #4567 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #13007 - Change the default to False of addconstraint / dropconstraint isolate_from_table related issue thread · stale/low urgency | 1 | #13007 | none | stale/low urgency | high |
| Review thread: 1 issue - Issue #12097 - can't adapt type for enum in case() related issue thread · stale/low urgency | 1 | #12097 | none | stale/low urgency | high |
| orm stale/low urgency queue (2 issues) duplicate/related candidate · stale/low urgency | 2 | #8070#8311 | none | Compare the related issue set before writing separate maintainer responses. | medium |
| orm good volunteer slice queue (2 issues) duplicate/related candidate · good volunteer slice | 2 | #8326#10335 | none | Compare the related issue set before writing separate maintainer responses. | medium |
| mysql good volunteer slice batch action queue · good volunteer slice | 3 | #8341#8457#10310 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | medium |
| typing needs maintainer decision batch action queue · needs maintainer decision | 2 | #13253#13281 | none | Batch triage by component/action queue. | medium |
| performance needs maintainer decision batch action queue · needs maintainer decision | 2 | #10541#13311 | none | Batch triage by component/action queue. | medium |
| sql good volunteer slice batch action queue · good volunteer slice | 3 | #5564#5846#8352 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | medium |
| orm good volunteer slice batch action queue · good volunteer slice | 2 | #6084#7732 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | medium |
| oracle good volunteer slice batch action queue · good volunteer slice | 2 | #5133#11312 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | medium |
| documentation good volunteer slice batch action queue · good volunteer slice | 2 | #5139#9078 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | medium |
| orm stale/low urgency batch 1 batch action queue · stale/low urgency | 14 | #2501#6080#6137#9197#9348#9833#10380#10617#10960#11536#11623#12186#12575#12689 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| documentation stale/low urgency batch action queue · stale/low urgency | 9 | #4706#5235#6332#7360#7517#8894#10116#11062#11284 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| orm stale/low urgency batch 2 batch action queue · stale/low urgency | 7 | #1140#2792#3458#5541#6860#7309#9369 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| tests stale/low urgency batch action queue · stale/low urgency | 6 | #5174#6468#6505#7135#8805#9370 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| sql stale/low urgency batch action queue · stale/low urgency | 6 | #1452#6336#6700#9425#10326#10780 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| datatypes stale/low urgency batch action queue · stale/low urgency | 4 | #6874#8936#11597#12628 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| asyncio stale/low urgency batch action queue · stale/low urgency | 4 | #6121#12710#12803#12972 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| reflection stale/low urgency batch action queue · stale/low urgency | 3 | #10435#10742#11385 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| loader options stale/low urgency batch action queue · stale/low urgency | 3 | #3037#5964#7426 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| typing stale/low urgency batch action queue · stale/low urgency | 2 | #8909#10417 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| mysql stale/low urgency batch action queue · stale/low urgency | 2 | #1909#4272 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| mariadb stale/low urgency batch action queue · stale/low urgency | 2 | #7228#12561 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| dml stale/low urgency batch action queue · stale/low urgency | 2 | #10446#12096 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| dialects stale/low urgency batch action queue · stale/low urgency | 2 | #8321#10680 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| declarative stale/low urgency batch action queue · stale/low urgency | 2 | #5806#6411 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| bug stale/low urgency batch action queue · stale/low urgency | 2 | #10064#10835 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | medium |
| loader options high-priority/blocker single issue review · high-priority/blocker | 1 | #9548 | none | Review early as a priority/risk queue. | low |
| reflection needs maintainer decision single issue review · needs maintainer decision | 1 | #9468 | none | Needs human review. | low |
| orm needs maintainer decision single issue review · needs maintainer decision | 1 | #13153 | none | Needs human review. | low |
| general needs maintainer decision single issue review · needs maintainer decision | 1 | #10676 | none | Needs human review. | low |
| dml needs maintainer decision single issue review · needs maintainer decision | 1 | #13113 | none | Needs human review. | low |
| schema good volunteer slice single issue review · good volunteer slice | 1 | #10341 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | low |
| postgresql good volunteer slice single issue review · good volunteer slice | 1 | #4434 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | low |
| feature good volunteer slice single issue review · good volunteer slice | 1 | #7149 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | low |
| asyncio good volunteer slice single issue review · good volunteer slice | 1 | #7604 | none | Batch as volunteer-ready work; keep maintainer review focused on scope and tests. | low |
| schema stale/low urgency single issue review · stale/low urgency | 1 | #9233 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| public api stale/low urgency single issue review · stale/low urgency | 1 | #8680 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| postgresql stale/low urgency single issue review · stale/low urgency | 1 | #9944 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| performance stale/low urgency single issue review · stale/low urgency | 1 | #4855 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| oracle stale/low urgency single issue review · stale/low urgency | 1 | #12341 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| functions stale/low urgency single issue review · stale/low urgency | 1 | #5006 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| feature stale/low urgency single issue review · stale/low urgency | 1 | #2814 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| engine stale/low urgency single issue review · stale/low urgency | 1 | #5815 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| connection pool stale/low urgency single issue review · stale/low urgency | 1 | #8693 | none | Batch sweep for close/reproduce/docs-update decisions; keep any live evidence attached. | low |
| use case waiting on contributor single issue review · waiting on contributor | 1 | #11136 | none | Leave waiting unless maintainers can reproduce independently. | low |
| orm waiting on contributor single issue review · waiting on contributor | 1 | #5999 | none | Leave waiting unless maintainers can reproduce independently. | low |
| documentation waiting on contributor single issue review · waiting on contributor | 1 | #10531 | none | Leave waiting unless maintainers can reproduce independently. | low |
This is the attachable no-write proof: all open issues plus stale open PRs get a proposed maintainer-facing action, with evidence, but no GitHub write is allowed.
| Scope | Item | Dry-Run Action | Would Do | Why It Helps | GitHub Action Allowed |
|---|---|---|---|---|---|
| all_open_issues | issue #1063: self-referential / mutually dependent FK flush() should not require post_update for an UPDATE only query | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #1140: implement in_() for relations | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #1452: mysql update... order by | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #1909: reflection issue with mysql, url with no schema failure | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #2501: the DELETE before INSERT problem | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #2792: settable polymorphic identity | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #2814: support for overriding existing @compiles directives | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #2943: @validates on inherited subclasses | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #3037: support setting load options on instances | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #3458: super-self-referential m2m joins need to use annotations | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4272: suport MySQL inline indexes e.g. KEY(col) in DDL | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4289: support None for index name | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4434: Support for functions in UniqueConstraint | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #4567: SQLite on_conflict not working with ORM | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4641: add feature to mapper registry to allow for mapper_args that take place by default | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4652: Unclear How to Properly Include an ON UPDATE Clause in DDL for Column | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4706: synonym descriptors automatically blend existing properties - undocumented? | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4784: Default MetaData kwarg naming_convention can create issues with certain databases | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4790: Improve error messages on create_table | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #4855: instance_state can't raise an informative exception due to performance concerns. write C function? | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5005: alter ORM-level "returned rows" checks to only warn if driver returns -1 or None | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5006: support for unusual function namespace separators | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5123: apply informative re-raise if a result processor function fails | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #5133: Add APPLY operator support for mssql | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #5139: Document how to add dialect keywords get_columns() column information | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #5174: Move testing requirements to the dialects | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5235: Coordinating Changelog info | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5350: `NoReferencedColumnError` when using `referred_column_0[[_]N]_name` in FK naming convention | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #5352: Can not select negated boolean column in MS SQL Server | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5541: some means of applying SQL functions to association proxy | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5564: add limit() / offset() to CTE, as CTE.union() produces a CTE and not a CompoundSelect | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #5583: Improve SQLAlchemy consistency regarding database specific supported constructs | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5806: favor module names over table names when looking at the class target of a relationship, or dot separated names ? unsure | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5815: Support transaction read only access mode API, implement for MySQL, PostgreSQL, Oracle, others | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5846: Support reverse bitwise operations | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #5964: implement "sticky" option for load_only / defer (persists after expiration?) | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #5999: Type annotations are not preserved by `declared_attr`, `hybrid_property`, and potentially other decorators | park_waiting_for_info | Leave waiting unless a maintainer can reproduce independently; no automated ping. | Reporter or contributor input is still needed. | False |
| all_open_issues | issue #6040: allow clauseelements in hint text | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6080: implement decent inspection API for registry -> mapped classes | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6084: 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 | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #6120: Support lambdas in `column_property` | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #6121: SQLAlchemy Runtime Inspection API doesn't support `AsyncEngine` | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6137: support for a m2m relationship that back populates to itself? | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6274: Fix the error message when aliased() is invoked against a select() or union() and do legacy coercion | review_pr_backed_thread | Wait for contributor update on PR #12433; keep related issue/PR context attached. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #6332: Documentation: use ORM declarative attributes in .values instead of kwargs in "ORM-enabled UPDATE statements"? | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6336: consider if update() / insert() can infer datatypes from values() when columns have no type | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6411: add new attribute_declared event for decalrative, intercepts all declared attrs but particularly Column | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6468: test_limit_render_multiple_times needs order by and seems to be the only union type test. | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6489: support autocommit w/ explicit isolation levels | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6505: Always include where cluases in delete statements -- at least in test cleanup | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6511: add support for reflection of collation in types | review_pr_backed_thread | Approve or inspect gated test run(s) for PR #13418, then review the thread evidence together. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #6612: Cannot build SQL expression NOT(x IS NULL) on Postgres | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6700: Improve creation of custom select object | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6810: Complete SQLAlchemy inline pep484 typing | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #6860: smoother with_parent() failure modes | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6874: Please work harder to figure out parameter types for sequences | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #6997: investigate very intricate correlation / any() / self referential case | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7035: Use innodb in the test suite when using mysql/mariadb | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7113: Rename/Replace "with_hint()" to "with_table_criteria()" | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7135: mysql/test_for_update is very slow on ci | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7149: Automap: prefer snake_case over lower() for relationship attribute names | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #7223: unified approach for Emulated (was: Interval type should not subclass from `TypeDecorator`) | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7228: Incorrect code for sa.values on SQLite and MariaDB | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7309: sqlalchemy.orm.relationship: "overlaps" errors and behavior are confusing | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7360: replace use of the term "primary key identifier" with "identity key" for ORM documentation / methods that refer to the identity map | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7366: extend_existing will add copies of indexes, constraints, etc. as there is no deduplication on name | human_triage_decision | Decide issue category, owner, and response pattern; no automated GitHub action. | The issue is represented and auditable, but the evidence does not justify an automated action. | False |
| all_open_issues | issue #7426: targeting of highly self-referential id column within a subquery w contains_eager | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7475: Support for postgresql aggregate options | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7517: Better document `expanding=True` on a bind parameter | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7604: add execution option for asyncpg_timeout | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #7718: create oracle_dblink table option | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #7732: add new execution option "log_note", implement for ORM queries | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #8070: add Session method .expire_on_criteria() | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8311: add with_hint() method to the exists() construct | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #8321: Unify INSERT ... ON CONFLICT / UPSERT / MERGE functionality in single implementation | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8326: support TextualSelect with ORM mappings | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #8341: support MySQL 8.0.13's new magical syntax for function server defaults | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #8352: Named window functions | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #8431: implement include_join=False for selectin_polymorphic | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8457: Support MySQL Multi-Valued Indexes | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #8680: Better organize pep 484 types in the packages | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8693: sp_reset_connection not called on reused connections in pool. (MSSQL) | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8795: support sqlite .autocommit parameter (Python 3.12) | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8805: Some tests for dialect ignores lack of support of CHECK CONSTRAINT | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8894: Improve documentation to make classes use the "public" module | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8909: using @declared_attr does not recognize method as a classmethod unless one writes @classmethod explicitly (hence the workaround) | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8936: Make the new PG Range aware of the its bounds data type | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #8992: tuple expanding params do not render bind_expression() for elements | review_pr_backed_thread | Approve or inspect gated test run(s) for PR #13323, then review the thread evidence together. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #9078: [2.0] Classes which are generics should document their type parameters | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #9082: eager_defaults shouldn't be needed for pk returning even if cols are not actual pks | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9147: declarative builds permanent strong ref to classes that use declare_first or declare_last | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9154: 11 test failures with PyPy3.9 7.3.11 in 2.0.0 (and git main) | human_triage_decision | Decide issue category, owner, and response pattern; no automated GitHub action. | The issue is represented and auditable, but the evidence does not justify an automated action. | False |
| all_open_issues | issue #9197: Support for mapping frozen dataclasses | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9212: add additional type migration section to whatsnew detailing declared_attr format changes, others | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #9213: document `@classmethod` add for all `@declared_attr` to work w/ typing | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9233: Expression index does not list all the columns | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9301: Support mapped attributes that have deferred definitions | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #9348: modify expunge() operation in uow to cascade along delete-orphan in addition to expunge | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9369: allow_unmapped seems to not be honored in all cases | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9370: Create a way to run all the examples in the pipeline | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9410: document dataclass gotchas so far | review_pr_backed_thread | Wait for contributor update on PR #13289; keep related issue/PR context attached. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #9425: tighten up compoundselect + textualselect use cases | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9468: Implementation for get_unique_constraints for MS SQL Server | human_triage_decision | Decide issue category, owner, and response pattern; no automated GitHub action. | The issue is represented and auditable, but the evidence does not justify an automated action. | False |
| all_open_issues | issue #9493: MappedAsDataclass inherits dataclasses attributes, while the spec says they don't | review_pr_backed_thread | Wait for contributor update on PR #13289; keep related issue/PR context attached. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #9548: relationship loader options do a "recursive" thing inconsistently | priority_human_review | Review early as release/regression risk; no automated GitHub action. | High priority or blocker signal should stay in a human-owned queue. | False |
| all_open_issues | issue #9587: Use python type in Mapped to boolean expression catching thinks like `Mapped[int] == 'a string'` | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #9690: reroute group_by coercion to expand fromclause using ORM-enabled plugin points | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9693: Text type columns using schema qualified collations compile a quoted DDL statement on Postgres | review_pr_backed_thread | Approve or inspect gated test run(s) for PR #13418, then review the thread evidence together. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #9833: Ignore classvar attributes defined in declarative classes | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9839: document network-related caveats for insertmanyvalues | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #9930: need docs /warnings that `__init__` is not called on load | review_pr_backed_thread | Wait for contributor update on PR #13289; keep related issue/PR context attached. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #9944: Reflect don't recognize foreign tables in postgresql | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10064: MappedAsDataclass, prohibit constructor use and/or creation for non-mapped classes, abstract, mixins | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10094: document asyncio gotchas so far | review_pr_backed_thread | Wait for contributor update on PR #13289; keep related issue/PR context attached. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #10116: re-entrant handle_error call if an exception is raised in result.all() within a DML process | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10310: Select Values in Mysql | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #10326: Allow InstrumentedAttribute in corresponding_column | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10335: Support `Final[Mapped[...]]` in the ORM | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #10341: add official API to have naming conventions work for alternate constraint types | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #10351: allow Nullable to be used with column_property() | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #10380: Declaring Composite Column Types as Optional leads to NULL data type for constituent columns in table definition | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10417: mypy: coerced legacy syntax with subquery can not be typed | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10435: sql server metadata.reflect() fails if your SQL Server connection uses "tempdb" as the primary connection's database | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10446: Support synonym with bulk_insert_mappings and insert | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10527: Wrong typing for `with_for_update()`'s `of` argument. | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #10531: Issue with relationship typing when using Declarative-Imparative Mapping | park_waiting_for_info | Leave waiting unless a maintainer can reproduce independently; no automated ping. | Reporter or contributor input is still needed. | False |
| all_open_issues | issue #10541: Improve scalars performance by trying to avoid the creation of a Row | human_triage_decision | Decide issue category, owner, and response pattern; no automated GitHub action. | The issue is represented and auditable, but the evidence does not justify an automated action. | False |
| all_open_issues | issue #10544: pysqlcipher open fail with err: TypeError: function takes at most 3 arguments (4 given) in dbapi_connection.create_function | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10617: Improve how `Select.refresh` works with relationships | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10675: syntax error with mysql bulk update via INSERT ... SELECT ... ON DUPLICATE KEY UPDATE | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #10676: Add reasonable min version for the internal dialects packages / databases | human_triage_decision | Decide issue category, owner, and response pattern; no automated GitHub action. | The issue is represented and auditable, but the evidence does not justify an automated action. | False |
| all_open_issues | issue #10680: upgrade default driver for psycopg, oracledb | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10742: Bad PrimaryKeyConstraint metadata for MSSQL temporary table | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10748: schemes that attempt to reload modules are blocked by the inspection registry | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #10780: name with flat for aliased() | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10835: sqlalchemy.util.OrderedSet does not work with v2 in ORM mappings | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10859: move lazy="select" to lazy="mapper_default"; add mapper "default_lazy" | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10888: OrderingList typing incorrect / incomplete and implementation doesn't accept non-int indices | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #10936: post_update double UPDATE on delete of object with bi-directional | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #10960: "implicit combining column" warning not emitting for two columns from two different aliases against same parent table | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #11062: Could not de-stringify annotation | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #11122: Postregresql create table add "with" argument | review_pr_backed_thread | Wait for contributor update on PR #11296; keep related issue/PR context attached. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #11132: MySQL DOUBLE accepts deprecated params that dont propagate from the base DOUBLE type, document this caveat | review_pr_backed_thread | Approve or inspect gated test run(s) for PR #13368, then review the thread evidence together. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #11136: Delete Propagation to Parent Table for Joined Table Inheritance | park_waiting_for_info | Leave waiting unless a maintainer can reproduce independently; no automated ping. | Reporter or contributor input is still needed. | False |
| all_open_issues | issue #11284: Missing batch_op.f() | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #11312: reflecting oracle synonym of synonym over dblink | prepare_volunteer_slice | Package as contributor-ready scope with test expectations; do not assign or comment automatically. | Labels indicate a scoped external contribution may be welcome. | False |
| all_open_issues | issue #11385: Add additional information to the `ReflectedColumn` | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #11536: support module-qualified paths inside of Mapped[], including with/without future mode / pep563 etc | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #11597: sqltypes.Enum not generic enough | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #11620: Deprecate MSSQL enable_identity_insert by default, gate it behind a flag | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #11623: omit column_property from rendering inside subquery() / CTE() ? | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #11677: SQLITE: SQLiteDialect.get_check_constraints incorrectly reflects multiline check constraints | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #11686: Unexpected relationship kwarg with mypy from a mixin | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #12096: delete with join and returning clause doesn't work on SQLAlchemy 2 | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #12097: can't adapt type for enum in case() | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #12101: Better support of locking clauses (FOR UPDATE/SHARE) when supported | human_triage_decision | Decide issue category, owner, and response pattern; no automated GitHub action. | The issue is represented and auditable, but the evidence does not justify an automated action. | False |
| all_open_issues | issue #12186: Improve `eager_default=True` behavior in insert / updates | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #12341: Add dialect-specific support for Oracle's FETCH EXACT/APPROXIMATE | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
| all_open_issues | issue #12398: Add existing strategy to conflicting strategies error message | review_pr_backed_thread | Review active PRs and linked issues as one maintainer work thread. | Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. | False |
| all_open_issues | issue #12561: Recover two-phase in mysql is currently unusable since it uses a legacy row index method | batch_stale_issue_sweep | Review in its collapse group for close/reproduce/docs-update decision; do not post automatically. | Old or low-urgency issue can be handled in a component sweep instead of rediscovering context alone. | False |
Graph-connected issue/PR units with referenced context and review or CI gates attached.
| Thread | Score | Issues | PRs | Next Action | Edges |
|---|---|---|---|---|---|
| PR #13323 - Apply tuple bind expressions to expanding IN values waiting on repo-owner test approval | 94 | #8992 | PR #13323 | Approve or inspect gated test run(s) for PR #13323, then review the thread evidence together. | 4 |
| PR #13402 - Allow inspection registrations from module reloads waiting on CI/check fix | 73 | #10748 | PR #13402 | Review active PRs and linked issues as one maintainer work thread. | 8 |
| PR #13421 - Fix oracledb async dialect entering cursors synchronously waiting on CI/check fix | 73 | #13420 | PR #13421 | Review active PRs and linked issues as one maintainer work thread. | 5 |
| PR #12697 - Support schema-qualified collation in types for PostgreSQL waiting on repo-owner test approval | 70 | #6511#9693 | PR #12697PR #12698PR #13418 | Approve or inspect gated test run(s) for PR #13418, then review the thread evidence together. | 43 |
| PR #13368 - Document deprecated MySQL (M,D) float syntax and improve error message waiting on repo-owner test approval | 70 | #11132 | PR #13368 | Approve or inspect gated test run(s) for PR #13368, then review the thread evidence together. | 3 |
| PR #13399 - UniqueConstraint and Index withheld from table via attach_to_table flag, and appended to table via append_constraint waiting on repo-owner test approval | 70 | #13048 | PR #13399 | Approve or inspect gated test run(s) for PR #13399, then review the thread evidence together. | 3 |
| PR #13404 - Subqueryload without per-row Row construction — ~26% on subqueryload waiting on repo-owner test approval | 70 | #13406 | PR #13404 | Approve or inspect gated test run(s) for PR #13404, then review the thread evidence together. | 4 |
| PR #13405 - Cython batch instance processor — ~10–30% on most loads (collection joinedload −5%) waiting on repo-owner test approval | 70 | #13407 | PR #13405 | Approve or inspect gated test run(s) for PR #13405, then review the thread evidence together. | 4 |
| PR #13398 - fix catastrophic backtracking in sqlite inline unique reflection regex waiting on repo-owner test approval | 70 | #13419 | PR #13398 | Approve or inspect gated test run(s) for PR #13398, then review the thread evidence together. | 7 |
| PR #12401 - Make loader strategy error message more verbose waiting on CI/check fix | 65 | #12398 | PR #12401 | Review active PRs and linked issues as one maintainer work thread. | 4 |
| PR #13303 - Fix PostgreSQL CHECK constraint reflection stripping unrelated parens waiting on contributor | 62 | #13157 | PR #13303 | Wait for contributor update on PR #13303; keep related issue/PR context attached. | 13 |
| PR #13415 - scalars/mappings performance improvement. waiting on repo-owner test approval | 60 | none | PR #13415 | Approve or inspect gated test run(s) for PR #13415, then review the thread evidence together. | 1 |
| PR #13416 - Perf/eager collection bulk extend waiting on repo-owner test approval | 60 | none | PR #13416 | Approve or inspect gated test run(s) for PR #13416, then review the thread evidence together. | 3 |
| PR #13417 - Add type annotations to sqlalchemy.ext.serializer waiting on repo-owner test approval | 60 | none | PR #13417 | Approve or inspect gated test run(s) for PR #13417, then review the thread evidence together. | 3 |
| PR #10574 - fixes: #2943, allow overriding validates for inheritance waiting on CI/check fix | 55 | #2943 | PR #10574 | Review active PRs and linked issues as one maintainer work thread. | 6 |
| PR #12645 - enable mypy "ignore-without-code" rule waiting on CI/check fix | 55 | none | PR #12645 | PR blocked | 1 |
| PR #13289 - fix: raise clear error when default_factory/default passed to WriteOnlyMapped/DynamicMapped relationship waiting on contributor | 52 | #9410#9493#9930#10094#13227 | PR #13289 | Wait for contributor update on PR #13289; keep related issue/PR context attached. | 20 |
| PR #12433 - Coerce aliased Select and CompoundSelect to subquery waiting on contributor | 52 | #6274 | PR #12433 | Wait for contributor update on PR #12433; keep related issue/PR context attached. | 9 |
| Issue #9548 - relationship loader options do a "recursive" thing inconsistently high-priority/blocker | 52 | #9548 | none | high-priority/blocker | 0 |
| PR #13137 - Use _effective_decimal_return_scale in Numeric.result_processor waiting on repo-owner test approval | 52 | none | PR #13137 | Approve or inspect gated test run(s) for PR #13137, then review the thread evidence together. | 1 |
| PR #13312 - test: add coverage for delete with nested alias exists waiting on repo-owner test approval | 52 | none | PR #13312 | Approve or inspect gated test run(s) for PR #13312, then review the thread evidence together. | 1 |
| PR #11296 - Ability to specify `WITH` when creating a table + fixes `WITH` when creating an index waiting on contributor | 45 | #11122 | PR #11296 | Wait for contributor update on PR #11296; keep related issue/PR context attached. | 6 |
| PR #13051 - Added implementations for avg & abs waiting on contributor | 45 | #13049 | PR #13051 | Wait for contributor update on PR #13051; keep related issue/PR context attached. | 6 |
| PR #13288 - fix(pool): use time.monotonic() instead of time.time() for connection timestamps waiting on contributor | 45 | #13169 | PR #13288 | Wait for contributor update on PR #13288; keep related issue/PR context attached. | 5 |
| PR #12297 - refactor(MSExecutionContext): improve identity insert handling and va… has linked issue | 44 | #11620 | PR #12297 | Review active PRs and linked issues as one maintainer work thread. | 7 |
| PR #8136 - Add tools for documentation formatting and validation draft/noise | 43 | none | PR #8136 | draft/noise | 3 |
| PR #12731 - fix(typing): allow DeclarativeBase subclasses in with_for_update(of=...) draft/noise | 38 | #6120#6810#9301#9587#10351#10527#10888#11686#13357 | PR #12731 | Review active PRs and linked issues as one maintainer work thread. | 41 |
| Issue #10675 - syntax error with mysql bulk update via INSERT ... SELECT ... ON DUPLICATE KEY UPDATE good volunteer slice | 38 | #10675 | none | good volunteer slice | 1 |
| Issue #8341 - support MySQL 8.0.13's new magical syntax for function server defaults good volunteer slice | 38 | #8341 | none | good volunteer slice | 0 |
| PR #11107 - migration note on subqueries waiting on contributor | 35 | none | PR #11107 | Wait for contributor update on PR #11107; keep related issue/PR context attached. | 2 |
| PR #11297 - Optionally include rollback exception in closed transaction invalid request error message when possible waiting on contributor | 35 | none | PR #11297 | Wait for contributor update on PR #11297; keep related issue/PR context attached. | 0 |
| PR #11437 - initial commit to update the SQLAlchemy examples waiting on contributor | 35 | none | PR #11437 | Wait for contributor update on PR #11437; keep related issue/PR context attached. | 2 |
| Issue #12101 - Better support of locking clauses (FOR UPDATE/SHARE) when supported needs maintainer decision | 28 | #5583#12101 | none | needs maintainer decision | 4 |
| Issue #13204 - Immediateload fails to load when combined with inheritance needs maintainer decision | 28 | #13204#13210 | none | needs maintainer decision | 3 |
| Issue #10541 - Improve scalars performance by trying to avoid the creation of a Row needs maintainer decision | 28 | #10541 | none | needs maintainer decision | 0 |
| Issue #10676 - Add reasonable min version for the internal dialects packages / databases needs maintainer decision | 28 | #10676 | none | needs maintainer decision | 0 |
| Issue #13113 - SQLite insert supports multiple on-conflict clauses in inserts needs maintainer decision | 28 | #13113 | none | needs maintainer decision | 0 |
| Issue #13153 - `composite` with in-place custom values getter needs maintainer decision | 28 | #13153 | none | needs maintainer decision | 0 |
| Issue #13212 - Support for native JSON in mssql needs maintainer decision | 28 | #13212 | none | needs maintainer decision | 1 |
| Issue #13253 - im not sure we can type hybrid_methods fully needs maintainer decision | 28 | #13253 | none | needs maintainer decision | 0 |
| Issue #13281 - Modernize type annotations to PEP 604 union syntax needs maintainer decision | 28 | #13281 | none | needs maintainer decision | 0 |
| Issue #13311 - Provide a many-table version for has_table needs maintainer decision | 28 | #13311 | none | needs maintainer decision | 0 |
| Issue #7366 - extend_existing will add copies of indexes, constraints, etc. as there is no deduplication on name needs maintainer decision | 28 | #7366 | none | needs maintainer decision | 2 |
| Issue #9154 - 11 test failures with PyPy3.9 7.3.11 in 2.0.0 (and git main) needs maintainer decision | 28 | #9154 | none | needs maintainer decision | 1 |
| Issue #9468 - Implementation for get_unique_constraints for MS SQL Server needs maintainer decision | 28 | #9468 | none | needs maintainer decision | 0 |
| Issue #4289 - support None for index name stale/low urgency | 20 | #4289#5350 | none | stale/low urgency | 5 |
| Issue #9212 - add additional type migration section to whatsnew detailing declared_attr format changes, others good volunteer slice | 20 | #9212#9213 | none | good volunteer slice | 2 |
| Issue #10310 - Select Values in Mysql good volunteer slice | 20 | #10310 | none | good volunteer slice | 0 |
| Issue #10335 - Support `Final[Mapped[...]]` in the ORM good volunteer slice | 20 | #10335 | none | good volunteer slice | 0 |
| Issue #10341 - add official API to have naming conventions work for alternate constraint types good volunteer slice | 20 | #10341 | none | good volunteer slice | 0 |
| Issue #11312 - reflecting oracle synonym of synonym over dblink good volunteer slice | 20 | #11312 | none | good volunteer slice | 0 |
| Issue #4434 - Support for functions in UniqueConstraint good volunteer slice | 20 | #4434 | none | good volunteer slice | 0 |
| Issue #5123 - apply informative re-raise if a result processor function fails good volunteer slice | 20 | #5123 | none | good volunteer slice | 1 |
| Issue #5133 - Add APPLY operator support for mssql good volunteer slice | 20 | #5133 | none | good volunteer slice | 0 |
| Issue #5139 - Document how to add dialect keywords get_columns() column information good volunteer slice | 20 | #5139 | none | good volunteer slice | 0 |
| Issue #5564 - add limit() / offset() to CTE, as CTE.union() produces a CTE and not a CompoundSelect good volunteer slice | 20 | #5564 | none | good volunteer slice | 0 |
| Issue #5846 - Support reverse bitwise operations good volunteer slice | 20 | #5846 | none | good volunteer slice | 0 |
| Issue #6084 - 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 good volunteer slice | 20 | #6084 | none | good volunteer slice | 0 |
| Issue #7149 - Automap: prefer snake_case over lower() for relationship attribute names good volunteer slice | 20 | #7149 | none | good volunteer slice | 0 |
| Issue #7604 - add execution option for asyncpg_timeout good volunteer slice | 20 | #7604 | none | good volunteer slice | 0 |
Sorted by maintainer attention signal, still read-only and evidence-bound.
Public-safe normalized rows for auditability.
| Issue | Bucket | Score | Linked | Labels | Excerpt |
|---|---|---|---|---|---|
| Issue #13420: oracledb async dialect enters cursors synchronously, silently breaking async cursor wrappers | has linked PR | 44 | PR #13421 | bug, task, oracle, asyncio | ### Describe the use case ### AsyncAdapt_oracledb_cursor._aenter_cursor uses sync __enter__() instead of async __aenter__() **Where:** https://github.com/sqlalchemy/sqlalchemy/blob/c8e26d5c9ffcde0a82b4b7fa5de27f0c6bc46bec/lib/sqlalchemy/dialects/oracle/oracledb.py#L754-L758 Compare to the base class it overrides, wh... |
| Issue #13419: catastrophic regex backtracking in sqlite inline UNIQUE reflection (ReDoS on get_unique_constraints) | has linked PR | 44 | PR #13398 | bug, reflection | ### Describe the bug `get_unique_constraints` on the SQLite dialect scans the stored `CREATE TABLE` text (taken verbatim from `sqlite_master.sql`) with an inline-`UNIQUE` regex whose tail is `[\t ]+[a-z0-9_ ]+?[\t ]+UNIQUE`. The lazy middle class itself contains a space, so all three quantifiers can lay claim to the... |
| Issue #13407: Cython batch instance processor — ~10–30% on most loads | has linked PR | 44 | PR #13405 | orm, performance | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/13378 <div type='discussions-op-text'> <sup>Originally posted by **ollz272** June 16, 2026</sup> Add `orm/_loading_cy.py` with `_InstancesBatch`, a whole-chunk row processor built by `_instance_processor()` for the non-refresh, non-polymorphic loa... |
| Issue #13406: use new _raw_all_tuples with subqueryloads | has linked PR | 44 | PR #13404 | orm, performance | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/13375 <div type='discussions-op-text'> <sup>Originally posted by **ollz272** June 16, 2026</sup> `_SubqCollections._load` iterated the `Query`, which routes through `Query.__iter__ -> result.unique()` and builds a `Row` object (plus runs the uniqu... |
| Issue #13357: Type check error when passing lists to `any_`/`all_` | needs maintainer decision | 28 | none | documentation, functions, typing | ### Ensure stubs packages are not installed - [x] No sqlalchemy stub packages is installed (both `sqlalchemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [x] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should... |
| Issue #13311: Provide a many-table version for has_table | needs maintainer decision | 28 | none | reflection, performance, use case | ### Describe the use case This could be used for example to speed-up the check done by the `create_all` metadata something similar to the multi-reflection api, the method could be called `has_multi_table` discussed in #13295 ### Databases / Backends / Drivers targeted any ### Example Use ```py inspect(conn).has_muti... |
| Issue #13281: Modernize type annotations to PEP 604 union syntax | needs maintainer decision | 28 | none | typing | ## Summary SQLAlchemy now targets Python >= 3.10, so legacy `typing.Union` and `typing.Optional` annotations can be modernized to PEP 604 union syntax. Examples: - `Optional[T]` -> `T | None` - `Union[A, B]` -> `A | B` - `typing.Optional[T]` -> `T | None` - `typing.Union[A, B]` -> `A | B` ## Scope Audit and update P... |
| Issue #13253: im not sure we can type hybrid_methods fully | needs maintainer decision | 28 | none | bug, quagmire, typing | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/13249 trying to do this, cannot get any typing combination to be accepted by pyright much less mypy: ```py from typing import overload from sqlalchemy import func, Integer, column from sqlalchemy import select from sqlalchemy.ext.hybrid import hyb... |
| Issue #13227: WriteOnlyMapped: default_factory=list broken in 2.1 due to new declarative_scan validation | has linked PR | 44 | PR #13289 | orm, use case | ### Describe the bug The new `default_factory` validation introduced in commit [95ad9fe](https://github.com/sqlalchemy/sqlalchemy/commit/95ad9fe42b888d7cdea60b7a71c833cbb8667887) (related to #12168) breaks `WriteOnlyMapped` relationships that use `default_factory=list` in Declarative Dataclass Mapping. ### Optional... |
| Issue #13212: Support for native JSON in mssql | needs maintainer decision | 28 | none | SQL Server, datatypes, use case | ### Describe the use case Sql server 2025 seems to have added native json support https://learn.microsoft.com/en-us/sql/t-sql/data-types/json-data-type?view=sql-server-ver17 I guess we should decide what to do with the existing JSON type: https://docs.sqlalchemy.org/en/20/dialects/mssql.html#sqlalchemy.dialects.mssq... |
| Issue #13210: Applying a loader option to a parent relationship when using with_polymorphic does not work properly | needs maintainer decision | 28 | none | bug, orm, loader options | > Asked claude to fuzz this and it did find a similar case, let me know if you prefer me to open another issue or if we should re-open this one. Seem very similar: it accesses the parent relationship via `poly.Cls.parent_rel` that's similar to what was fixed here `poly.Cls.cls_rel` > > while strange I think it shoul... |
| Issue #13204: Immediateload fails to load when combined with inheritance | needs maintainer decision | 28 | none | bug, orm, loader options, fuzzer | 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 eager loading: `select(Meta).option(anyloader(Meta.parent_cls).immediateload(ParentCls.relationship))` - loading using immediatel... |
| Issue #13169: Connection pool soft invalidation uses `time.time()` comparison that can silently fail on low-resolution clocks (e.g. Windows ~16 ms) | has linked PR | 44 | PR #13288 | connection pool, use case | In `lib/sqlalchemy/pool/base.py`, `_ConnectionRecord.get_connection` detects soft invalidation via: ```python # base.py, line 852 elif self._soft_invalidate_time > self.starttime: do_connect = True ``` `_soft_invalidate_time` is set with `time.time()` (line 812) and `starttime` is also set with `time.time()` (line 8... |
| Issue #13157: PostgreSQL check constraint reflection strips brackets naively | has linked PR | 62 | PR #13303 | bug, postgresql, reflection, great mcve | ### Describe the bug Check constraint reflection strips brackets from some expressions such that they are syntactically invalid ### Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected _No response_ ### SQLAlchemy Version in Use 2.0.48 ### DBAPI (i.e. the database driver) psyc... |
| Issue #13153: `composite` with in-place custom values getter | needs maintainer decision | 28 | none | orm, use case | ### Describe the use case Currently, nested composites or custom classes require implementing `__composite_values__`, which is not always an option. Internally there is `_generated_composite_accessor` which is generated if no such method provided. I suggest adding `values_getter` as an argument to `composite()` so i... |
| Issue #13113: SQLite insert supports multiple on-conflict clauses in inserts | needs maintainer decision | 28 | none | sqlite, use case, dml | ### Describe the use case Apparently sqlite supports multiple on-conflict clauses in inserts: https://sqlite.org/lang_upsert.html > If the insert operation would cause the conflict target uniqueness constraint to fail, then the insert is omitted and the corresponding DO NOTHING or DO UPDATE operation is performed in... |
| Issue #13049: Provide an implementation for avg / abs function with proper type | has linked PR | 44 | PR #13051 | functions, use case | ### Describe the use case Currently `avg` and `abs` do not have an implementation in the functions module Since these are fairly common i thing we could provide an implementation so that the correct type can be inferred. - avg is numeric (or Double) - abs instead derives its type from the input ### Databases / Backe... |
| Issue #13048: Add option for disabling automatic addition of constraint/indexes to the table | has linked PR | 44 | PR #13399 | schema, use case | ### Describe the use case Add a flag in the constraints and index to prevent them from automatically being added to the table collections. They can be added manually either by providing them to the table constructor or using the table methods to add constraints ### Databases / Backends / Drivers targeted Any ### Exa... |
| Issue #13007: Change the default to False of addconstraint / dropconstraint isolate_from_table | stale/low urgency | 2 | none | schema, use case | Follow up of #13006 Set to False the default value and remove the warning |
| Issue #12972: Move asyncio out of ext into the library proper | stale/low urgency | 2 | none | use case, asyncio | a long term solution would be to pull the asyncio extension out of the .ext/ namespace so that the imports would be `from sqlalchemy.asyncio import create_async_engine` and `from sqlalchemy.orm.asycnio import AsyncSession`. Then `sqlalchemy.ext.asyncio` would be a compatibility shim that isn't needed, the same way D... |
| Issue #12803: Expose Two Phase Transaction in async layer | stale/low urgency | 2 | none | use case, asyncio | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/12797 <div type='discussions-op-text'> <sup>Originally posted by **OscarRomaFever** August 12, 2025</sup> Hi! I would like to know if it is possible to manage a Two-Phase Commit (2PC) transaction using asynchronous connections with PostgreSQL in S... |
| Issue #12710: add extra shielding to async connection create | stale/low urgency | 2 | none | bug, engine, asyncio | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/12709 Locally I can only reproduce this using a trusted connection against a PG database running in a local container, which I can run like this: podman run -d --rm -e POSTGRES_HOST_AUTH_METHOD=trust -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=... |
| Issue #12689: WriteOnlyScalar companion to WriteOnlyMapped (which would be Collection?) , as WOM suits an async use case that applies to scalars as well | stale/low urgency | 2 | none | orm, use case | ### Describe the use case Traditional strategies ('select', 'raise', 'subquery') for accessing a lazy-loaded relationship relationship don't work in an async context, as the database call loading the related instance yields to the event loop before a necessarily synchronous attribute access would otherwise return. T... |
| Issue #12628: Add support for MariaDB Vector data type | stale/low urgency | 2 | none | oracle, datatypes, use case, mariadb | ### Describe the use case MariaDB has introduced a new Vector data type in version 11.7. Details can be found here: https://mariadb.org/projects/mariadb-vector/ The main issue I'm running into now is that reflection fails when reflecting on any table that has a vector column. The reflection fails to retrieve the col... |
| Issue #12585: support SQLite .autocommit=False mode, improve documentation | stale/low urgency | 2 | none | task, sqlite, big job | ### Describe the use case see https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.autocommit for the new feature (which was many years in the making) from discussion at https://github.com/sqlalchemy/alembic/issues/1655 : 1. SQLAlchemy's documentation needs to be updated to reflect that the "correct tra... |
| Issue #12575: prefixing Composite Column Types | stale/low urgency | 2 | none | orm, use case | ### Describe the use case ```python @dataclasses.dataclass class Person: first_name: int last_name: str # ... class Housing(Base): person: composite(Person, column_prefix='person') ``` would result in mapped column names `person_first_name` and `person_last_name` right now, the API is a bit verbose and hard to read:... |
| Issue #12561: Recover two-phase in mysql is currently unusable since it uses a legacy row index method | stale/low urgency | 2 | none | bug, mysql, mariadb | This has likely been broken since v2 https://github.com/sqlalchemy/sqlalchemy/blob/a84444fca1c436179ad847ce99e8a013a84b5b33/lib/sqlalchemy/dialects/mysql/base.py#L2772-L2774 Apparently there is no test that covers this |
| Issue #12398: Add existing strategy to conflicting strategies error message | has linked PR | 26 | PR #12401 | orm, use case | ### Describe the use case I just received the following error of in my project and have an improvement request similar to #10668 : ``` sqlalchemy.exc.InvalidRequestError: Loader strategies for ORM Path[Mapper[Cable(cable)] -> Cable.cablesides -> Mapper[CadCableSide(cad_cable_side)]] conflict ``` While this tells me... |
| Issue #12341: Add dialect-specific support for Oracle's FETCH EXACT/APPROXIMATE | stale/low urgency | 2 | none | oracle, use case | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/12337 support for FETCH EXACT/APPROXIMATE feature described at https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6__BABBADDD |
| Issue #12186: Improve `eager_default=True` behavior in insert / updates | stale/low urgency | 2 | none | orm, unit of work, use case, eager_defaults | ## update Currently `eager_default=True` in case of an update of multiple rows does the following: - when the driver supports returning, runs single updates with returning, one for each row. Results in n queries - when the driver does not support returning, runs execute many updates and one select for each rows. Res... |
| Issue #12101: Better support of locking clauses (FOR UPDATE/SHARE) when supported | needs maintainer decision | 28 | none | postgresql, oracle, use case | ### Describe the use case The [Postgres docs](https://www.postgresql.org/docs/17/sql-select.html) specifically say that you should be able to have both a FOR UPDATE and a FOR SHARE in the same query: > Multiple locking clauses can be written if it is necessary to specify different locking behavior for different tabl... |
| Issue #12097: can't adapt type for enum in case() | stale/low urgency | 2 | none | question, documentation, expected behavior, law of twos | ### Describe the bug I can't use an enum type as part of a `case()` without casting. Looks very similar to https://github.com/sqlalchemy/sqlalchemy/issues/6515 ### Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected _No response_ ### SQLAlchemy Version in Use 2.0.36 ### DBAPI... |
| Issue #12096: delete with join and returning clause doesn't work on SQLAlchemy 2 | stale/low urgency | 2 | none | bug, orm, hard orm, dml | ### Describe the bug I have a statement like the following, which works on SQLAlchemy 1.4 but not on 2.0 ```python delete(Author).where(Author.id == Book.author_id).returning(Book.title) ``` ### Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected https://docs.sqlalchemy.org/e... |
| Issue #11686: Unexpected relationship kwarg with mypy from a mixin | stale/low urgency | 2 | none | dataclasses, typing | ### Ensure stubs packages are not installed - [X] No sqlalchemy stub packages is installed (both `sqlalchemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [X] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should... |
| Issue #11677: SQLITE: SQLiteDialect.get_check_constraints incorrectly reflects multiline check constraints | stale/low urgency | 2 | none | bug, sqlite, reflection, quagmire, law of twos | ### Describe the bug The `get_check_constraints` method of SQLiteDialect, does not correctly handle multi line CHECK constraints in SQLAlchemy reflection. When performing a alembic batch_op for example, multi line check constraints will not be or wrongly reflected and can result in SQL errors. ### Optional link from... |
| Issue #11623: omit column_property from rendering inside subquery() / CTE() ? | stale/low urgency | 2 | none | orm, performance, expected behavior | ### Describe the bug Given a model `A` with a column_property `B`, a query that loads an `aliased` of `A` will emit the `B` expression multiple times (exact number depends on the complexity of the query). ### Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected _No response_ #... |
| Issue #11620: Deprecate MSSQL enable_identity_insert by default, gate it behind a flag | has linked PR | 44 | PR #12297 | sql, SQL Server, fairly easy | Discussed in #11613 Add a boolean flag in the mssql dialect, the default will be set to `warn` meaning that a warning will be raised when `_enable_identity_insert` is detected set to true. User can opt into the current behaviour or disable it |
| Issue #11597: sqltypes.Enum not generic enough | stale/low urgency | 2 | none | bug, datatypes, typing | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/11548 The generic type for `Enum` needs to be a typevar for pyright: ```py from __future__ import annotations import enum from sqlalchemy import Enum from sqlalchemy import func from sqlalchemy.orm import column_property from sqlalchemy.orm import... |
| Issue #11536: support module-qualified paths inside of Mapped[], including with/without future mode / pep563 etc | stale/low urgency | 2 | none | orm, use case, orm - annotated declarative | ### Describe the bug When using PEP563 postponed annotations (i.e. `from __future__ import annotations`), mapped classes with the same name in different modules cannot be used in relationships using type annotations alone. For example, if `mod1` and `mod2` both contain mapped classes called `Model`, then `attr: Mapp... |
| Issue #11385: Add additional information to the `ReflectedColumn` | stale/low urgency | 2 | none | reflection, use case | The reflected column dict https://docs.sqlalchemy.org/en/20/core/reflection.html#sqlalchemy.engine.interfaces.ReflectedColumn includes only the already reflected type instance from the dialect. This means that for unknown sql types, the sqlalchemy nulltype is provided, losing any information about what was reflected... |
| Issue #11312: reflecting oracle synonym of synonym over dblink | good volunteer slice | 20 | none | oracle, reflection, PRs (with tests!) welcome | ### Describe the bug I get a table not found error when trying to reflect a synonym of a synonym on a dblink. I try reflecting the table as such ``` self._engine = sql.create_engine(uri, echo='debug') sql.Table(table_name, self._metadata, schema=self._schema, autoload_with=self._engine, oracle_resolve_synonyms=True)... |
| Issue #11284: Missing batch_op.f() | stale/low urgency | 2 | none | bug, documentation, tests, schema | ### Discussed in https://github.com/sqlalchemy/alembic/discussions/1458 the [conv](https://docs.sqlalchemy.org/en/20/core/constraints.html#sqlalchemy.schema.conv) construct applies truncation rules to identifiers, and users are using it this way. We can't change that, so document it and ensure unit tests are present... |
| Issue #11136: Delete Propagation to Parent Table for Joined Table Inheritance | waiting on contributor | 0 | none | awaiting info, use case | ### Describe the use case When a polymorphic table is created via joined table inheritance, I would expect that deleting a row in the subclass table would also delete the row in the parent table. I've found that when the subclass row is explicitly deleted, the delete propgates to the parent table as I would expect.... |
| Issue #11132: MySQL DOUBLE accepts deprecated params that dont propagate from the base DOUBLE type, document this caveat | has linked PR | 44 | PR #13368 | documentation, mysql, datatypes, PRs (with tests!) welcome | ### Describe the bug Hi im trying to get startet with sql alchemy and alembic and just found a bug. during the translation of a double precision=17, and decimal_return_scale=7 into mysql i always get an exception. `sqlalchemy.exc.ArgumentError: You must specify both precision and scale or omit both altogether.` When... |
| Issue #11122: Postregresql create table add "with" argument | has linked PR | 44 | PR #11296 | postgresql, PRs (with tests!) welcome, use case | ### Describe the use case In postgresql documentation (https://www.postgresql.org/docs/current/sql-createtable.html) create table have the "with" option that is not supported by sqlalchemy currently. The change is simple: https://github.com/sqlalchemy/sqlalchemy/commit/45b70d4e7c0ac31005f8a93253fe477dfc27afb4 ### Da... |
| Issue #11062: Could not de-stringify annotation | stale/low urgency | 2 | none | documentation, orm, orm - annotated declarative | ### Describe the bug Hey, the following code raises an `NameError: Could not de-stringify annotation 'long str'`. But as soon as I changed `Annotated[str, "long str"]` to `Annotated[str, "long_str"]` it works. Any idea about what's going on here? fin swimmer ### Optional link from https://docs.sqlalchemy.org which d... |
| Issue #10960: "implicit combining column" warning not emitting for two columns from two different aliases against same parent table | stale/low urgency | 2 | none | bug, orm | ### Describe the bug ## Description The following code yields a strange result. I'm expecting `bar_1`, `bar_2`, and `bar_3` to be mapped as `CompositeBar(value_1="a", value_2="b")`, `CompositeBar(value_1="c", value_2="d")`, and `CompositeBar(value_1="e", value_2="f")` respectively, but actually it ended up with ever... |
| Issue #10936: post_update double UPDATE on delete of object with bi-directional | stale/low urgency | 2 | none | bug, quagmire, unit of work, post-update | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/10934 looks like this was never tested. might not have an immediate solution ```py def test_no_double_update_on_delete_bidirectional_post_update(self): person, ball, Ball, Person = ( self.tables.person, self.tables.ball, self.classes.Ball, self.cl... |
| Issue #10888: OrderingList typing incorrect / incomplete and implementation doesn't accept non-int indices | good volunteer slice | 20 | none | sqlalchemy.ext, PRs (with tests!) welcome, typing | ### Describe the bug There are a number of issues with the sqlalchemy.ext.orderinglist:OrderingList type hints and implementation: 1. The ordering function is documented as being allowed to return any type of object, and the tests demonstrate this by returning strings. The type annotation requires it to return integ... |
| Issue #10859: move lazy="select" to lazy="mapper_default"; add mapper "default_lazy" | stale/low urgency | 2 | none | feature, orm | this can come in alongside #4641 this would make a change to `relationship` such that it does not set up `strategy_key` until mapper config stage, where it gets a look at its parent mapper. should be mentioned in docs particularly here: https://github.com/sqlalchemy/sqlalchemy/blob/d9ed5cb521d5e7a2b62646b43eaebc1ccf... |
| Issue #10835: sqlalchemy.util.OrderedSet does not work with v2 in ORM mappings | stale/low urgency | 2 | none | bug, cextensions, orm - annotated declarative | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/10833 This apparently was possible in 1.4 but not in 2.0 when cython extensions are built: ```py # sqlalchemy 2.0.25 from sqlalchemy import ForeignKey from sqlalchemy import inspect from sqlalchemy.orm import DeclarativeBase from sqlalchemy.orm im... |
| Issue #10780: name with flat for aliased() | stale/low urgency | 2 | none | sql, use case | ### Describe the use case aliased() currently prohibits a name in conjunction with `flat=True`. Presumably this is because it would require some arbitrary naming convention. In reality, `flat=True` already has an arbitrary naming convention (suffix with numbers) which is useful for the query compiler, but not so muc... |
| Issue #10748: schemes that attempt to reload modules are blocked by the inspection registry | has linked PR | 62 | PR #13402 | bug, orm, PRs (with tests!) welcome, external library/application issues | ### Describe the bug There's a nasty interaction between the following: * some import-time caching in SQLAlchemy (in [`sqlalchemy.inspection._registrars`](https://github.com/sqlalchemy/sqlalchemy/blob/66be1482db06adb908432b2e3b41d9393d1319f7/lib/sqlalchemy/inspection.py#L53)), * the way Coverage.py handles editable... |
| Issue #10742: Bad PrimaryKeyConstraint metadata for MSSQL temporary table | stale/low urgency | 2 | none | bug, SQL Server, reflection | ### Describe the bug If I create a temporary table (name starting with a `#`) using MSSQL, then inspect the table metadata, it has a constraint `{PrimaryKeyConstraint()}`. However, none of the columns are detected as primary keys and the primary key constraint has no name. The names of the primary key constraints ar... |
| Issue #10680: upgrade default driver for psycopg, oracledb | stale/low urgency | 2 | none | use case, dialects | The current default drivers selection for some database is outdated or not really useful anymore. An idea for 2.1 is to start raising a deprecation warning when a default drivers is selected. Optionally the default behaviour is something that can be kept were it makes sense. In particular oracle and sqlite seem the... |
| Issue #10676: Add reasonable min version for the internal dialects packages / databases | needs maintainer decision | 28 | none | setup | Will compile a table with min version. Let's target at least 2 years for dialect packages and something sensible for the databases Databases |db | best_effort | normal |full| notes | |---|-------------|--------|----|-------| |mssql|2005 -> 2008| - | -|remove warning on _setup_version_attributes| |mysql|5.0.2->5.1|-|... |
| Issue #10675: syntax error with mysql bulk update via INSERT ... SELECT ... ON DUPLICATE KEY UPDATE | good volunteer slice | 38 | none | bug, mysql, PRs (with tests!) welcome, dml | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/10514 <div type='discussions-op-text'> <sup>Originally posted by **anentropic** October 20, 2023</sup> I am trying to bulk update via an insert on duplicate, but using `from_select` (instead of list of values as seen here https://github.com/sqlalc... |
| Issue #10617: Improve how `Select.refresh` works with relationships | stale/low urgency | 2 | none | orm, use case | Since version 1.4 that added support for relationship refresh, the implementation is sub-optimal, since it will always perform a query to the model table, followed by a query to the related table. ```py from __future__ import annotations from sqlalchemy import create_engine from sqlalchemy import ForeignKey from sql... |
| Issue #10544: pysqlcipher open fail with err: TypeError: function takes at most 3 arguments (4 given) in dbapi_connection.create_function | stale/low urgency | 2 | none | bug, sqlite | ### Describe the bug using windows and pysqlcipher in python 3.11 get error to create engine with very basic usage ### Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected _No response_ ### SQLAlchemy Version in Use 2.0.22 ### DBAPI (i.e. the database driver) pysqlcipher ### D... |
| Issue #10541: Improve scalars performance by trying to avoid the creation of a Row | needs maintainer decision | 28 | none | performance, result fetching API improvements | The current code when executing something like `conn.execute(...).scalars().all()` will create a Row object, at least in some cases, that is then discarded. The code should try to avoid doing the unnecessary row creation |
| Issue #10531: Issue with relationship typing when using Declarative-Imparative Mapping | waiting on contributor | 0 | none | bug, documentation, awaiting info, orm - annotated declarative | ### Describe the bug Hi :wave: First of all thank you for the huge amount of work done on SQLAlchemy, I really enjoy using this library :rocket: I'm trying to implement a many-to-many relationship (like explained [here](https://docs.sqlalchemy.org/en/20/orm/basic_relationships.html#setting-bi-directional-many-to-man... |
| Issue #10527: Wrong typing for `with_for_update()`'s `of` argument. | good volunteer slice | 38 | none | bug, PRs (with tests!) welcome, typing | ### Ensure stubs packages are not installed - [X] No sqlalchemy stub packages is installed (both `sqlalchemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [X] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should... |
| Issue #10446: Support synonym with bulk_insert_mappings and insert | stale/low urgency | 2 | none | orm, use case, dml | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/10439 <div type='discussions-op-text'> <sup>Originally posted by **flyly0755** October 9, 2023</sup> There is such a situation, data of different sources need to insert to one table, but the data column is a little different, for example: Data fro... |
| Issue #10435: sql server metadata.reflect() fails if your SQL Server connection uses "tempdb" as the primary connection's database | stale/low urgency | 2 | none | SQL Server, reflection | ### Describe the bug When trying to fetch all the tables from a MSSQL database (clean database via Docker https://hub.docker.com/_/microsoft-mssql-server) with the MetaData().reflect(bind=engine) it raises a NoSuchTableError on a temporary table (starting with a #) that indeed does not exist. This worked on SQLAlche... |
| Issue #10417: mypy: coerced legacy syntax with subquery can not be typed | stale/low urgency | 2 | none | wontfix / out of scope, expected behavior, typing | ### Describe the bug I found a typing oddity with 2.0 that is not in the guide. Legacy code utilizing a `Session().query().subquery()` will run fine (and emit warnings that is it making a coercion) - but does not pass mypy becauce of the coercion. I'm not sure if this is a typing bug or not, as the legacy format is... |
| Issue #10380: Declaring Composite Column Types as Optional leads to NULL data type for constituent columns in table definition | stale/low urgency | 2 | none | bug, orm, orm - annotated declarative | ### Describe the bug I was going through the tutorial for adding composite column types where sets of columns can be associated with a single user-defined datatype (FYR https://docs.sqlalchemy.org/en/20/orm/composites.html#composite-column-types). I tweaked the example a bit to make the composite column types option... |
| Issue #10351: allow Nullable to be used with column_property() | stale/low urgency | 2 | none | orm, use case, typing | ### Ensure stubs packages are not installed - [X] No sqlalchemy stub packages is installed (both `sqlalchemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [X] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should... |
| Issue #10341: add official API to have naming conventions work for alternate constraint types | good volunteer slice | 20 | none | schema, naming conventions, PRs (with tests!) welcome | Using them is poorly tested and the use case seems quite limited. |
| Issue #10335: Support `Final[Mapped[...]]` in the ORM | good volunteer slice | 20 | none | orm, PRs (with tests!) welcome, orm - annotated declarative | In some cases generics are consired invariant since the mapped descriptors are not declared as final. While this use case for this is likely very small, it should not be too hard to support the following form: ```py from sqlalchemy import ForeignKey from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column,... |
| Issue #10326: Allow InstrumentedAttribute in corresponding_column | stale/low urgency | 2 | none | sql, use case | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/10325 <div type='discussions-op-text'> <sup>Originally posted by **CaselIT** September 8, 2023</sup> Currently InstrumentedAttribute is not a KeyedColumnElement so trying to use `corresponding_column` and similar raises a typing error This does no... |
| Issue #10310: Select Values in Mysql | good volunteer slice | 20 | none | mysql, sql, PRs (with tests!) welcome, use case | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/10309 <div type='discussions-op-text'> <sup>Originally posted by **RasulGafarov** September 4, 2023</sup> The following code: ``` my_select = select( Values( sqlalchemy.column("column_1", String), sqlalchemy.column("column_1", String), name="temp_... |
| Issue #10116: re-entrant handle_error call if an exception is raised in result.all() within a DML process | stale/low urgency | 2 | none | bug, documentation, engine | this is from https://review.opendev.org/c/openstack/oslo.db/+/888580 so far, the reproducer so far is this docker container: ``` FROM ubuntu:22.04 SHELL ["/bin/bash", "-c"] RUN apt-get update && apt-get install -y python3 tox git WORKDIR /root RUN git clone --depth 1 https://opendev.org/openstack/barbican WORKDIR /r... |
| Issue #10094: document asyncio gotchas so far | stale/low urgency | 2 | none | documentation, asyncio | - gether is messy to use with multiple sessions not created inside the task. Ref https://github.com/sqlalchemy/sqlalchemy/discussions/9312#discussioncomment-6419638 |
| Issue #10064: MappedAsDataclass, prohibit constructor use and/or creation for non-mapped classes, abstract, mixins | stale/low urgency | 2 | none | bug, dataclasses, orm - annotated declarative | see #10027. MappedAsDataclass basically cannot support the dataclass "init" feature on a class that isn't mapped, and likely can't support *any* dataclass features on such a class as instantiated. Propose instantiation of mixins / abstract emit a warning if they are also "dataclass" produced under 2.0, error in 2.1. |
| Issue #9944: Reflect don't recognize foreign tables in postgresql | stale/low urgency | 2 | none | postgresql, schema, reflection, use case | ### Describe the use case Currently, when I call the MetaData().reflect() function, the foreign tables are not reflected. It would be interesting to have an argument in the function to be able to search for foreign tables as well. This way facilitates DML operations on foreign tables. ### Databases / Backends / Driv... |
| Issue #9930: need docs /warnings that `__init__` is not called on load | high-priority/blocker | 52 | none | documentation, high priority, orm | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/9928 since we retired https://docs.sqlalchemy.org/en/20/orm/constructors.html#mapping-constructors this information has been lost. also update links to that page such as https://docs.sqlalchemy.org/en/20/orm/events.html#sqlalchemy.orm.InstanceEven... |
| Issue #9839: document network-related caveats for insertmanyvalues | stale/low urgency | 2 | none | documentation, SQL Server, performance, insertmanyvalues | ### Describe the bug We upgraded our sql alchemy version and observed a massive spike in execution time on the database. We are bulk uploading several 100k rows. We are using sql server on azure and pyodbc. We believe it relates to changes made in https://github.com/sqlalchemy/sqlalchemy/issues/9603 or https://githu... |
| Issue #9833: Ignore classvar attributes defined in declarative classes | stale/low urgency | 2 | none | orm, use case, orm - annotated declarative | Something that certainly **should** work, but does not, is to declare the type as a ``ClassVar[]``, since we scan these also in declarative: ```py class AlertItem2(Base): __tablename__ = "alert_items2" id = Column(BigInteger, primary_key=True, autoincrement=True) signature = Column(String) data_source_model_id = Col... |
| Issue #9693: Text type columns using schema qualified collations compile a quoted DDL statement on Postgres | has linked PR | 44 | PR #12697PR #13418 | postgresql, schema, datatypes, PRs (with tests!) welcome, use case | ### Describe the bug If you use a `Text` type that includes a fully schema qualified collation (ie. `Text(collation="my_schema.my_collation")`), the DDL statement created when running `metadata.create_all()` is incorrect for Postgres. The statement created presently is: `TEXT COLLATE "my_schema.my_collation"` Which... |
| Issue #9690: reroute group_by coercion to expand fromclause using ORM-enabled plugin points | stale/low urgency | 2 | none | orm, sql, use case | ### Describe the bug What I want to do is to associate an ORM entity _USER_ with columns of FromClause produced by subquery() as described in tutorial. But when I use associated \<AliasedClass\> instance in group_by() of new _stmt_ it 'unpacks' all columns that are selected in a subquery instead of unpacking just Us... |
| Issue #9587: Use python type in Mapped to boolean expression catching thinks like `Mapped[int] == 'a string'` | stale/low urgency | 2 | none | use case, typing | ### Ensure stubs packages are not installed - [X] No sqlalchemy stub packages is installed (both `sqlalchemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [X] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should... |
| Issue #9548: relationship loader options do a "recursive" thing inconsistently | high-priority/blocker | 52 | none | bug, high priority, orm, loader options | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/9528 the wildcard option '*' acts recursively in some sitiuations (with no way to not be recursive) and non-recursively in others: ```py from sqlalchemy import Column from sqlalchemy import create_engine from sqlalchemy import ForeignKey from sqla... |
| Issue #9493: MappedAsDataclass inherits dataclasses attributes, while the spec says they don't | good volunteer slice | 20 | none | bug, orm, PRs (with tests!) welcome, dataclasses, orm - annotated declarative | We also seem to make inherit dataclasses attributes, while we probably should not. Not sure if it's connected to this other issue #9350 ```py from dataclasses import dataclass import sqlalchemy as sa import sqlalchemy.orm as sao import inspect class Base(sao.MappedAsDataclass, sao.DeclarativeBase, kw_only=True): pas... |
| Issue #9468: Implementation for get_unique_constraints for MS SQL Server | needs maintainer decision | 28 | none | SQL Server, reflection, use case | ### Describe the use case It would be useful to have the method [Inspector.get_unique_constraints](https://github.com/sqlalchemy/sqlalchemy/blob/rel_2_0_5/lib/sqlalchemy/engine/interfaces.py#L1562) implemented for SQL Server. My immediate use case is that alembic [uses this method](https://github.com/sqlalchemy/alem... |
| Issue #9425: tighten up compoundselect + textualselect use cases | stale/low urgency | 2 | none | bug, sql | The following is not allowed ```py t = sa.Table( "x", sa.MetaData(), sa.Column("a", sa.Integer), sa.Column("b", sa.Integer) ) sql = """ SELECT 1 as x, 2 as y UNION ALL SELECT 3, 4 """ q = sa.select(t).union_all(sa.text(sql)) ``` but it seems to render correctly if the coerce is removed for debug |
| Issue #9410: document dataclass gotchas so far | good volunteer slice | 20 | none | documentation, PRs (with tests!) welcome, dataclasses | 1. relationship = None issue : #9383 , #9856 - issue created: https://github.com/sqlalchemy/sqlalchemy/issues/12168 2. declared_attr on a mixin w/ dataclasses: #9408 3. order matters regarding the default value and init generated. this all comes from dataclasses, but it may be worth reiterate that 4. mention that al... |
| Issue #9370: Create a way to run all the examples in the pipeline | stale/low urgency | 2 | none | bug, tests | There are some examples that are not compatible with 2.0, like nested sets https://github.com/sqlalchemy/sqlalchemy/blob/8b108297d075ae68178cd18a9cb4d06feee7e075/examples/nested_sets/nested_sets.py#L56-L73 Creating a way of running the tests as part of the pipeline work help avoiding having old examples laying around |
| Issue #9369: allow_unmapped seems to not be honored in all cases | stale/low urgency | 2 | none | bug, orm, orm - annotated declarative | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/9368 ```py from typing import List from sqlalchemy import Column, ForeignKey from sqlalchemy.orm import relationship from sqlalchemy.types import Integer from sqlalchemy.orm import declarative_base # qualify the base with __allow_unmapped__. Can a... |
| Issue #9348: modify expunge() operation in uow to cascade along delete-orphan in addition to expunge | stale/low urgency | 2 | none | bug, orm, unit of work | ### Describe the bug In SQLAlchemy, when adding new objects to relationship with default cascades and then deleting them, they are kept inside session and then inserted on flush. But when having delete-orphan cascade, the desired behavior is to remove relative object from session as it is removed from relationship c... |
| Issue #9301: Support mapped attributes that have deferred definitions | stale/low urgency | 2 | none | documentation, orm, use case, typing | ### Describe the use case In multiple cases it may be required to assign to a mapped class an attribute after the class definition, to for example break circular imports or similar, that is usually done by assigning the attribute to the class `ModelCls.attribute_lazy = ...` This is currently a bit awkward to impleme... |
| Issue #9233: Expression index does not list all the columns | stale/low urgency | 2 | none | bug, schema | ### Describe the bug Only the first column in an expression is considered ### To Reproduce ```python import sqlalchemy as sa def go(idx): sa.Table( "x", sa.MetaData(), sa.Column("x", sa.Integer), sa.Column("y", sa.Integer), idx, ) print([str(c) for c in idx.columns]) go(sa.Index("x", sa.func.div(sa.column("x"), sa.c... |
| Issue #9213: document `@classmethod` add for all `@declared_attr` to work w/ typing | stale/low urgency | 2 | none | documentation, typing | ### Describe the typing issue Next issue, it seems I get an error when using a `Mapped` class attribute in `Index`. ### To Reproduce Stripped down version of what I'm running: ```python @sa.orm.declarative_mixin class _Rhyme: __tablename__: str ph1: Mapped[int] ph2: Mapped[Optional[int]] @sa.orm.declared_attr def __... |
| Issue #9212: add additional type migration section to whatsnew detailing declared_attr format changes, others | good volunteer slice | 20 | none | documentation, orm, PRs (with tests!) welcome, typing | ### Describe the typing issue I'm going through a small project with strict type checking, so will probably end up opening a few nitpick issues. It still seems difficult to me at the moment, to figure out what types should be used for certain annotations. Maybe a new page in the docs could be added to list these typ... |
| Issue #9197: Support for mapping frozen dataclasses | stale/low urgency | 2 | none | orm, use case, dataclasses | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/9192 Using frozen dataclasses may be useful in some cases, but implementing it will be non trivial. See mike [reply in the discussion](https://github.com/sqlalchemy/sqlalchemy/discussions/9192#discussioncomment-4820606) |
| Issue #9154: 11 test failures with PyPy3.9 7.3.11 in 2.0.0 (and git main) | needs maintainer decision | 28 | none | tests, pypy | ### Describe the bug When running the test suite (as of 6779fa861d11668f67d780d77e4ae76965cee6f7) under PyPy3.9 7.3.11, I get the following test failures: ``` FAILED test/ext/test_associationproxy.py::DictOfTupleUpdateTest::test_update_multi_elem_varg - AssertionError: 'update expected at most 1 arguments?, got 2' !... |
| Issue #9147: declarative builds permanent strong ref to classes that use declare_first or declare_last | stale/low urgency | 2 | none | bug, orm, declarative | the event hook here: https://github.com/sqlalchemy/sqlalchemy/blob/689ebc30dcd6b9cedf01d729f748b31826720b5c/lib/sqlalchemy/orm/decl_base.py#L567-L582 that's making a global event against Mapper. Declarative should make at most just *one* event hook against Mapper, then use its own collections to locate classes for w... |
| Issue #9082: eager_defaults shouldn't be needed for pk returning even if cols are not actual pks | stale/low urgency | 2 | none | bug, orm, eager_defaults | ### Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/9080 simple case can be reproduced on sqlite w/ new returning support ```py from sqlalchemy import Column from sqlalchemy import create_engine from sqlalchemy import DateTime from sqlalchemy import func from sqlalchemy import String from sqlalchem... |
| Issue #9078: [2.0] Classes which are generics should document their type parameters | good volunteer slice | 20 | none | task, documentation, PRs (with tests!) welcome, typing | ### Describe the use case I'm working on a test branch for sqlalchemy 2.0 in a codebase which uses `mypy --strict`. This means that custom subclasses of generic types must provide type parameters (`--disallow-any-generics`). But it isn't clear what the type parameters are or mean in the 2.0 documentation branch. ###... |
| Issue #8992: tuple expanding params do not render bind_expression() for elements | has linked PR | 94 | PR #13323 | bug, high priority, sql | discovered during #8989, this is simply not implemented at all and the bind expression is ignored when it's an element of a tuple. Also, the impl of a TupleType() is not getting the internal types propagated along, which is part of what would be needed for this to work ```py from sqlalchemy import Column from sqlalc... |
| Issue #8936: Make the new PG Range aware of the its bounds data type | stale/low urgency | 2 | none | postgresql, datatypes, use case | ### Describe the use case The SA Range does not have an exact notion of its "type", i.e. there is no way to determine the data type of an empty or infinite range. ### Databases / Backends / Drivers targeted The `Range` class is specific to PostgreSQL, but is driver-agnostic. ### Example Use For example, my app shows... |
Public-safe normalized rows for auditability.
| Pull Request | Bucket | Score | Linked | Labels | Excerpt |
|---|---|---|---|---|---|
| Pull Request #13421: Fix oracledb async dialect entering cursors synchronously | waiting on CI/check fix | 73 | #13420 | `AsyncAdapt_oracledb_cursor._aenter_cursor()` called the synchronous `cursor.__enter__()` instead of awaiting `cursor.__aenter__()`, silently bypassing third-party async cursor wrappers (e.g. instrumentation libraries) that implement only the async context manager protocol. Removed the incorrect override so the curs... | |
| Pull Request #13418: Use identifier preparer for string type collations | waiting on repo-owner test approval | 70 | #9693 | ### Description Fixes #9693. String type collation rendering currently hardcodes quoted collation names, so a PostgreSQL schema-qualified collation such as `schema.collation` is treated as one quoted identifier. This changes string type collation rendering to use the dialect identifier preparer, matching the existi... | |
| Pull Request #13417: Add type annotations to sqlalchemy.ext.serializer | waiting on repo-owner test approval | 60 | none | ## Summary Adds a small set of inline type annotations to the legacy `sqlalchemy.ext.serializer` extension. ## Details This keeps the change intentionally small and focused. It adds future annotations, removes the module-level mypy ignore marker, and annotates the serializer/deserializer helper methods plus the publ... | |
| Pull Request #13416: Perf/eager collection bulk extend | waiting on repo-owner test approval | 60 | none | <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description ## What changed Every eagerly-loaded child paid two wasted Python frames: the generated instrumentation wrapper (`append`/`add`) plus its `__set` no-op shell, even though with `_sa_initiator=False` the wrapper's enti... | |
| Pull Request #13415: scalars/mappings performance improvement. | waiting on repo-owner test approval | 60 | none | <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description What changed Core .scalars() built a one-column Row per row only to unwrap it with itemgetter(0); .mappings() built a Row plus a second BaseRow (RowMapping) via attrgetter("_mapping"). New class-level _fetch_shape hi... | |
| Pull Request #13405: # Cython batch instance processor — ~10–30% on most loads (collection joinedload −5%) | waiting on repo-owner test approval | 70 | #13407 | <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description Add `orm/_loading_cy.py` with `_InstancesBatch`, a whole-chunk row processor built by `_instance_processor()` for the non-refresh, non-polymorphic load path. It replaces the per-row `[proc(row) for row in fetch]` com... | |
| Pull Request #13404: Subqueryload without per-row Row construction — ~26% on subqueryload | waiting on repo-owner test approval | 70 | #13406 | <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description <!-- Describe your changes in detail --> `_SubqCollections._load` iterated the `Query`, which routes through `Query.__iter__ -> result.unique()` and builds a `Row` object (plus runs the uniquing filter) for every row... | |
| Pull Request #13402: Allow inspection registrations from module reloads | waiting on CI/check fix | 73 | #10748 | ### Summary - allow the inspection registry to accept a replacement registrar when it has the same module and name as the existing registration - keep the existing duplicate-registration assertion for conflicting registrars - add regression coverage for module reload style registration and a changelog entry Closes #... | |
| Pull Request #13399: UniqueConstraint and Index withheld from table via attach_to_table flag, and appended to table via append_constraint | waiting on repo-owner test approval | 70 | #13048 | <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description <!-- Describe your changes in detail --> attach_to_table has been included for UniqueConstraint and Index to allow users to choose whether to include or withhold them from the Table (Table.constraints for UniqueConst... | |
| Pull Request #13398: fix catastrophic backtracking in sqlite inline unique reflection regex | waiting on repo-owner test approval | 70 | #13419 | Fixes: #13419 ### Description While reflecting a SQLite table, `get_unique_constraints` scans the stored `CREATE TABLE` text (taken verbatim from `sqlite_master.sql`) with an `INLINE_UNIQUE_PATTERN` to spot inline `UNIQUE` columns. The tail of that pattern is `[\t ]+[a-z0-9_ ]+?[\t ]+UNIQUE`, where the lazy middle c... | |
| Pull Request #13368: Document deprecated MySQL (M,D) float syntax and improve error message | waiting on repo-owner test approval | 70 | #11132 | ### Description Fixes #11132. Per maintainer guidance in the issue, this PR does two things: 1. **Documents the caveat**: adds a `.. warning::` to the MySQL dialect's `DOUBLE`, `REAL` and `FLOAT` datatype docs stating that the `DOUBLE(M,D)` / `REAL(M,D)` / `FLOAT(M,D)` precision/scale syntaxes are non-standard MySQL... | |
| Pull Request #13323: Apply tuple bind expressions to expanding IN values | waiting on repo-owner test approval | 62 | #8992 | ### Description Tuple-valued expanding parameters now apply each element type's `bind_expression()` when rendering expanded tuples. This matches scalar `IN` behavior for custom types and covers both `render_postcompile` and `literal_binds`. Fixes: #8992 ### Checklist This pull request is: - [ ] A documentation / typ... | |
| Pull Request #13312: test: add coverage for delete with nested alias exists | waiting on repo-owner test approval | 52 | none | ### Description Adds test coverage for compiling a `DELETE` statement with a correlated `EXISTS` subquery that uses an aliased table. This verifies that SQLAlchemy correctly renders the aliased table inside the nested `EXISTS` clause while correlating it against the outer `DELETE` target. ### Checklist This pull req... | |
| Pull Request #13303: Fix PostgreSQL CHECK constraint reflection stripping unrelated parens | waiting on contributor | 45 | #13157 | Fixes #13157. The second pass over the CHECK constraint body in `get_multi_check_constraints` used a naive ```python re.sub(r"^[\s\n]*\((.+)\)[\s\n]*$", r"\1", m.group(1)) ``` which greedily paired the leading `(` with the trailing `)`. For an expression like ``` (x IS NULL OR y IS NULL) AND (x IS NULL OR y IS NULL)... | |
| Pull Request #13289: fix: raise clear error when default_factory/default passed to WriteOnlyMapped/DynamicMapped relationship | waiting on contributor | 45 | #13227 | ### Description Fixes: #13227 When `default_factory=list` or `default` is passed to a `WriteOnlyMapped` or `DynamicMapped` relationship, it previously caused cryptic crashes (e.g., `TypeError: LoaderCallableStatus object is not iterable` in `_WriteOnlyAttributeImpl.set()`). This happens because these mapped types ha... | |
| Pull Request #13288: fix(pool): use time.monotonic() instead of time.time() for connection timestamps | waiting on contributor | 45 | #13169 | ### Description Replaced all `time.time()` calls in `pool/base.py` with `time.monotonic()` for connection record timestamp tracking. Also updated the comment block that documented the Windows precision caveat. `time.time()` on Windows has approximately 16 ms granularity, which can cause soft invalidation checks to f... | |
| Pull Request #13137: Use _effective_decimal_return_scale in Numeric.result_processor | waiting on repo-owner test approval | 52 | none | ### Description `Numeric.result_processor` computes the decimal return scale inline, bypassing the `decimal_return_scale` parameter, while `Float.result_processor` correctly uses `_effective_decimal_return_scale`. ### Current behavior ```python # Numeric.result_processor - ignores decimal_return_scale return process... | |
| Pull Request #13051: Added implementations for avg & abs | waiting on contributor | 45 | #13049 | <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description Added the implementations for `func.avg()` and `func.abs()`. Fixes: #13049 ### Checklist <!-- go over following points. check them with an `x` if they do apply, (they turn into clickable checkboxes once the PR is sub... | |
| Pull Request #12731: fix(typing): allow DeclarativeBase subclasses in with_for_update(of=...) | draft/noise | 33 | #12730 | This commit updates the `_ForUpdateOfArgument` type alias used in the `with_for_update(of=...)` method to explicitly allow `Type[DeclarativeBase]` subclasses. In SQLAlchemy 2.x, `DeclarativeBase` is the recommended way to define ORM models. While runtime behavior already accepts these classes as valid arguments for... | |
| Pull Request #12698: Handle schema-qualified collation value in collate() | draft/noise | 43 | none | based on #12697 (and #12510). | |
| Pull Request #12697: Support schema-qualified collation in types for PostgreSQL | waiting on contributor | 45 | #9693 | We add a `collation_schema` in types supporting `collation`, along with `postgresql.DOMAIN`, allowing to create respective elements with a schema-qualified collation name. Reflection is also handled for both types and domains. Fix #9693. | |
| Pull Request #12645: enable mypy "ignore-without-code" rule | waiting on CI/check fix | 55 | none | ### Description Enable mypy "ignore-without-code" rule and apply the necessary fixes. Not really a "small typing error fix" but I think that's the closest of the items from the checklist. ### Checklist This pull request is: - [x] A documentation / typographical / small typing error fix - Good to go, no issue or test... | |
| Pull Request #12433: Coerce aliased Select and CompoundSelect to subquery | waiting on contributor | 35 | none | Fixes issue #6274 ### Description When `aliased()` is used on a select statement or compound select statement, it currently throws an error. The proposed solution in #6274 was to instead return a subquery and emit a warning to the user that aliases are not supported for these types of statements. ### Checklist <!--... | |
| Pull Request #12401: Make loader strategy error message more verbose | waiting on CI/check fix | 65 | #12398 | Fixes: #12398 This PR makes the error message on conflicting loader strategies more verbose to help with debugging <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description <!-- Describe your changes in detail --> I changed the omitted error messages and the tests covering... | |
| Pull Request #12297: refactor(MSExecutionContext): improve identity insert handling and va… | has linked issue | 27 | #11620 | Fixes: #11620 ### Description - Refactored method in to improve readability and maintainability: - Extracted identity insert logic into helper methods: - : Determines if identity insert should be enabled. - : Handles warnings or errors based on . - Simplified the method by delegating responsibilities to these helper... | |
| Pull Request #11437: initial commit to update the SQLAlchemy examples | waiting on contributor | 35 | none | * most examples now work on 2.x * examples are mostly typed * README files are added for more instruction * examples now have metadata for automation * a preliminary fabric tool is used for testing and reporting Change-Id: Ib5a12cc59b2ea045c48ea90798b887e3b5d4fbbe ### Description There are quite a bit of things goin... | |
| Pull Request #11297: Optionally include rollback exception in closed transaction invalid request error message when possible | waiting on contributor | 35 | none | Following discussion https://github.com/sqlalchemy/sqlalchemy/discussions/11243 ### Description 1. Exposing private attribute `SessionTransaction._rollback_exception` using public property `rollback_exception` 2. In `TransactionalContext._trans_ctx_check()` when a closed transaction is detected. first checking a tra... | |
| Pull Request #11296: Ability to specify `WITH` when creating a table + fixes `WITH` when creating an index | waiting on contributor | 45 | #11122 | <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description Adding the ability to specify storage parameters via with + fix for specifying index storage parameters (should it be split into two different PRs?). Fixes: #11122 ### Checklist <!-- go over following points. check t... | |
| Pull Request #11180: Fix subquerload deprecation | stale/low urgency | 17 | none | Change-Id: I3d1b844dee6dc29da4a6aaa0c2916e6a1178aaec The deprecation info does not appear in 3 important sections: * The initial overview * API docstrings in 2 places. This PR notes the deprecation in the overview, and adds links/deprecation docstrings to the functions so they should show up in the API docs. ### Des... | |
| Pull Request #11107: migration note on subqueries | waiting on contributor | 35 | none | Change-Id: Id33779cb126a700d9adebe5f08f9d6c085589db4 Under 2.0, calls to `in_` and `not_in` no longer accept an explicit `.subquery()`. Passing a `.subquery()` will cause typing issues from MyPy AND will raise runtime warnings. There was no note of this in the migration guide. This may be an effect of another change... | |
| Pull Request #10574: fixes: #2943, allow overriding validates for inheritance | waiting on CI/check fix | 55 | none | Applied the patch mentioned in #2943, to allow overriding the validates method of a given Model, Added tests for same in test_validators. If a Child class overrides the parent class validates method only child class validator will be invoked unless child class explicitly invokes parent class validator <!-- Provide a... | |
| Pull Request #8136: Add tools for documentation formatting and validation | draft/noise | 43 | none | ### Description The goal of this PR is to add tools that help with contributing to documentation, from discussion started on #7659. Goals include: - Automatic formatting of code blocks in .rst documents and in docstrings (blacken-docs) - Flake8 validation of these code blocks (flake8-rst-docstrings, flake8-docstring... |
Why items were connected. Excerpts are short and hashed; raw API payloads stay local.
| Kind | Source | Target | Confidence | Evidence | Evidence Hash |
|---|---|---|---|---|---|
| references | issue #13419 | pr #13398 | medium | Fix is to tokenise the inter-keyword whitespace with disjoint classes so a space only ever belongs to a separator and never to a token. PR #13398. | 5438506bfae6788939d085b934c6a38ec5025f49ae5697eb445b93df01cfeb88 |
| references | issue #13357 | issue #6810 | medium | chemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [x] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should pass type checking ### Describe the typing issue the runtime SQ... | b6af024d295fe4523765892156245d9e94053d262e6a89b5b817c4c80c6554f3 |
| references | issue #13227 | issue #12168 | medium | dation introduced in commit [95ad9fe](https://github.com/sqlalchemy/sqlalchemy/commit/95ad9fe42b888d7cdea60b7a71c833cbb8667887) (related to #12168) breaks `WriteOnlyMapped` relationships that use `default_factory=list` in Declarative Dataclass Mapping. ### Optional link from h... | 416800bfd2ad52b0df2743f058ec1540841d1782647bd5e54b0c83bc655057ea |
| references | issue #13212 | issue #4384 | medium | it's #4384 | 608257f83fcd4eb21d244e469a1756dd4afae38a6b9ea9deea208d149aea9439 |
| competes with | issue #13210 | issue #13193 | medium | 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)_ | f126815a8d44ecba56ca77044d109a535870c3c84161fe740f6fefc7e1d40413 |
| references | issue #13204 | issue #13193 | medium | 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 eager loading: `select(Meta).option(anyloader(Meta.parent_cls).immediateload(ParentCls.re... | d6af10a01c4ee0b2ddd96c96d6dd926659a632a831f4840c75ab65e66fc64d2e |
| references | issue #13204 | issue #13202 | medium | 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 eager loading: `select(Meta).option(anyloader(Meta.parent_cls).immediateload(ParentCls.re... | d9a355cb09796333911efbbd7d89389df5d8d79dff5a19b2f0e677a81c853616 |
| references | issue #13157 | pr #13188 | medium | Fix submitted in #13188. | ada55c738bd7c92e605adf592e0af4304c58d91d245fa81b6e2c9bcf41c43c32 |
| references | issue #13007 | issue #13006 | medium | Follow up of #13006 Set to False the default value and remove the warning | 08a3a0f3008e5ad03d320153a4b167d40723e7db07a096ac2f297b805e5dc279 |
| references | issue #12398 | issue #10668 | medium | ### Describe the use case I just received the following error of in my project and have an improvement request similar to #10668 : ``` sqlalchemy.exc.InvalidRequestError: Loader strategies for ORM Path[Mapper[Cable(cable)] -> Cable.cablesides -> Mapper[CadCableSide(ca | 07ceea06d0f1bb244249ac24902ba1dd7392e1e6bc595e75652f640133c4aefd |
| references | issue #12101 | issue #5583 | medium | ### Describe the use case The [Postgres docs](https://www.postgresql.org/docs/17/sql-select.html) specifically say that you should be able to have both a FOR UPDATE and a FOR SHARE in the same query: > Multiple locking clauses can be written if it is necessary to specify diffe... | bf6e8cce81a4e4ad031c254f2be259769d213b550fd5865ff2541cf9300ffea9 |
| references | issue #12101 | issue #5583 | medium | 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'm not really sure i... | 17c075eae174372b9d516a0535f376d64013cfe63319a93676e646945ce4e8d2 |
| references | issue #12097 | issue #6515 | medium | ### Describe the bug I can't use an enum type as part of a `case()` without casting. Looks very similar to https://github.com/sqlalchemy/sqlalchemy/issues/6515 ### Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected _No response_ ### SQ... | d6e79d43b2f87411acce577b2cf3ca68a1757872a452446adf58cfc92d854ce0 |
| references | issue #11686 | issue #6810 | medium | chemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [X] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should pass type checking ### Describe the typing issue An unexpected... | 9cc73297c82d8d32cb900e1a3d8d7f70ccf7e50efab470ce5bbc458ff2ebcccf |
| references | issue #11677 | pr #11678 | medium | I openend a PR to fix this issue https://github.com/sqlalchemy/sqlalchemy/pull/11678 | 9e0b49d5448c315c6fd4d9122fa60aca6f1eca0749a1376d93a29f067cdfa3b6 |
| references | issue #11620 | pr #12297 | medium | I've posted an alternative strategy that I'd like to use, detailed on the gerrit and also on the PR at https://github.com/sqlalchemy/sqlalchemy/pull/12297#issuecomment-2733436569 | d33380533bafdb0eafe088320cf5a1205e00dd6082ea55c4ed4db7d3487562b8 |
| references | issue #10936 | issue #1063 | medium | I thought this was related to #1063 but i dont think it is, unfortunately, meaning we have *two* post_update quagmire kinds of issues. | ff2f157a0104101412fa05baf83be57e5c834ee97522d8588382577d696d898b |
| references | issue #10888 | issue #6810 | medium | checked it off from this list https://github.com/sqlalchemy/sqlalchemy/issues/6810 | 3eccacb1573ec32ea9f2b62aa24ea620fa5a223de2497afa639acd5f9210c46e |
| references | issue #10859 | issue #4641 | medium | this can come in alongside #4641 this would make a change to `relationship` such that it does not set up `strategy_key` until mapper config stage, where it gets a look at i | 4fa3c8f29c672e31a3f31e7da50b97ba1b44a32567b8767fa09bf25914eea3ee |
| references | issue #10675 | issue #8626 | medium | 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? | 442258191ff3c9cb059d2017041605161b946d2176fc45574c0afd12bb3c0d19 |
| references | issue #10544 | pr #10545 | medium | try this pr to fix https://github.com/sqlalchemy/sqlalchemy/pull/10545 | 3e9735aae1d10aeed55e137904c1f9bd9525d9e78dc227534f6432febada58b5 |
| references | issue #10527 | issue #6810 | medium | chemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [X] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should pass type checking ### Describe the typing issue Seems that `wi... | ca892f55a8ea3033aaff2fe75b100d85688e7c668c5fd04a3159ca754a8d06f6 |
| references | issue #10351 | issue #6810 | medium | chemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [X] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should pass type checking ### Describe the typing issue Return type `c... | febd269ba982be5754112533d6f642aad4040a0d39bc266a4eaedb789fde186f |
| references | issue #10351 | issue #6120 | medium | > though column_property() does not accept calalbles or lambdas, so still need to reduce that there was an issue for it in https://github.com/sqlalchemy/sqlalchemy/issues/6120 | 092642d30898c4a51a388cee4788856af8f73304d2191976f09152e65992762b |
| references | issue #10094 | issue #5811 | medium | I've been missing a documentation regarding testing with async, I eventually got it to what I wanted but I don't entirely understand how it works. I've read through [this discussion](https://github.com/sqlalchemy/sqlalchemy/issues/5811) and arrived at this slightly shorter ver... | 17c764e9c78ef099a9c681fa259465b3d34089012642f5fcdc4aa0e112e4157b |
| references | issue #9839 | issue #9603 | medium | ### Describe the bug We upgraded our sql alchemy version and observed a massive spike in execution time on the database. We are bulk uploading several 100k rows. We are using sql server on azure and pyodbc. We believe it relates to changes made in https://github.com/sqlalchemy... | 7e31b5a59b11bf53917b4a3bd010250dd36a2bc7ed020bcc169c90145e20b042 |
| references | issue #9839 | issue #9618 | medium | ### Describe the bug We upgraded our sql alchemy version and observed a massive spike in execution time on the database. We are bulk uploading several 100k rows. We are using sql server on azure and pyodbc. We believe it relates to changes made in https://github.com/sqlalchemy... | 0043375355e3832918f3256ccc3f7ac1ce10f88aad9b3bd511a5c6d0d1cddc57 |
| references | issue #9839 | issue #9603 | medium | he database. We are bulk uploading several 100k rows. We are using sql server on azure and pyodbc. We believe it relates to changes made in #9603 <https://github.com/sqlalchemy/sqlalchemy/issues/9603> or #9618 <https://github.com/sqlalchemy/sqlalchemy/issues/9618> which were i... | 966c7562f852a532fe7460aada50914eb4b1d12d1179c5f6a0bdc52467c759ba |
| references | issue #9839 | issue #9618 | medium | ng sql server on azure and pyodbc. We believe it relates to changes made in #9603 <https://github.com/sqlalchemy/sqlalchemy/issues/9603> or #9618 <https://github.com/sqlalchemy/sqlalchemy/issues/9618> which were implemented in 2.0.10. We are no using the ORM, but execute direc... | 8d3ad4d82c8c18fb087fda45f75cd2e3b5e480988fd71c2be1dc816ee39639ff |
| references | issue #9839 | issue #9586 | medium | faster than plain executemany, but still order of magnitude worse than fast executemany** performance. We can see this using the test from #9586, using the dataset at https://github.com/sqlalchemy/sqlalchemy/files/11130278/test_data.zip and the script below, which I've improve... | 630196046d1345f502f6005002a1dc7811442b102d5f4780a49be0abd6a40870 |
| references | issue #9839 | issue #9603 | medium | 0 rows in 0.1 seconds (17273.9 rows/s). SQLA: 2.0.15; imv=False; fast_em=True: Finished in 2.4 seconds. ``` When using 2.0.9 exactly, issue #9603 was released which **universally disabled insertmanyvalues** for SQL Server. Based on everything we know, **this means default perf... | 0fdf498e3d52c13988631ff4b24aa75f92e382bd4b8f8ab9899de07cfbde2fdf |
| references | issue #9839 | issue #9603 | medium | nsertmanyvalues" completely in version 2.0.9 of SQL Server alone. it was turned on in 2.0.8 as well as 2.0.10. the 2.0.9 shutoff was due to #9603. im not really sure how if cloud DBs have expensive round trips that plain executemany() is better, there must be some driver level... | 528fb380c65653a55798c0e7739b755d4df88a583e62926e3107f9ee1fd72fb0 |
| references | issue #9690 | issue #8285 | medium | for the column slice thing, super huge omission from #8285. needs an extra isinstance | f0b846ecb519431a598505424cbabbe2629bc8c12ed274da4a0feed8bf117e07 |
| references | issue #9587 | issue #6810 | medium | chemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [X] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should pass type checking ### Confirm this is not Mypy dataclasses iss... | 8f0ab012bcaefbb9dcc8fde82aebd9ec9c8df0924510f8c708fbb24da29daaf5 |
| references | issue #9493 | issue #9350 | medium | We also seem to make inherit dataclasses attributes, while we probably should not. Not sure if it's connected to this other issue #9350 ```py from dataclasses import dataclass import sqlalchemy as sa import sqlalchemy.orm as sao import inspect class Base(sao.MappedAsDataclas | f8076fc7d0dcdc0caf479d2dd1902d754d6d52303e877db2ec988e937c80470e |
| references | issue #9493 | issue #9410 | medium | We also seem to make inherit dataclasses attributes, while we probably should not. Not sure if it's connected to this other issue #9350 ```py from dataclasses import dataclass import sqlalchemy as sa import sqlalchemy.orm as sao import inspect class Base(sao.MappedAsDataclass,... | 7da7fa4bf320ac783e00f5247a2ede72640cfa78056a56b13cd1bb7503731229 |
| references | issue #9410 | issue #9563 | medium | nit generated. this all comes from dataclasses, but it may be worth reiterate that 4. mention that all the dataclass limitations apply. see #9563 also 5. #9785 , back_populates / recursion issue 6. when using mixins, it is likely a good idea to use kw_only on those fields so t... | 9b6db4545aaf428753491c4e682f91aee96491313572cf0eb87e8a93c8aa9846 |
| references | issue #9410 | issue #9785 | medium | this all comes from dataclasses, but it may be worth reiterate that 4. mention that all the dataclass limitations apply. see #9563 also 5. #9785 , back_populates / recursion issue 6. when using mixins, it is likely a good idea to use kw_only on those fields so that they are no... | 5bf4fd8898c49821d0a2a9c08b01149c5a9c38bdb880b5a924ffbae32ea057c0 |
| references | issue #9410 | issue #12168 | medium | 1. relationship = None issue : #9383 , #9856 - issue created: https://github.com/sqlalchemy/sqlalchemy/issues/12168 2. declared_attr on a mixin w/ dataclasses: #9408 3. order matters regarding the default value and init generated. this all comes from dataclasses, but it may be... | ba5a0365721007562e43ce750cb449600932045425b3815e98136ca7b4eb706e |
| references | issue #9410 | issue #9350 | medium | We also seem to make inherit dataclasses attributes, while we probably should not. Not sure if it's connected to this other issue #9350 ```py from dataclasses import dataclass import sqlalchemy as sa import sqlalchemy.orm as sao import inspect class Base(sao.MappedAsDataclas | a7323bb4ce0f34aed7725f869799a299a1b3771c5a977eab22cdff1010cf0a22 |
| references | issue #9410 | issue #9785 | medium | Maybe also: - #9785 | 0f0de7c8e307a01172f3cc983bf57fea8a684f31dbd26dc48265cb7bf49606e9 |
| references | issue #9410 | issue #9785 | medium | > Maybe also: > > * [Using back_populates with MappedAsDataclass and asdict causing RecursionError #9785](https://github.com/sqlalchemy/sqlalchemy/issues/9785) sure. would be good to find if this has been reported as a dataclasses bug though | e9a7edbb51c0fbb8e7d03b064b9330f51b825c0e6c00d0b07c37b43267da66a3 |
| references | issue #9410 | issue #9785 | medium | > Maybe also: > > * [Using back_populates with MappedAsDataclass and asdict causing RecursionError #9785](https://github.com/sqlalchemy/sqlalchemy/issues/9785) added to the list in the OP | ac8450cd750d88d9ca2b2d4e7346f082fe9ed5fc80b5375bf1c4c4b0ae258393 |
| references | issue #9410 | issue #9927 | medium | #9927 I encountered this one. I am trying to use dataclass-only fields for some state things (i.e not mapped). The state variable should always b | a89a9f0c7bf2fa5fd2f9fe35d14f25d8509ac9bd2eb66bbc0989f876c87f61c7 |
| references | issue #9410 | issue #9927 | medium | > #9927 > > I encountered this one. I am trying to use dataclass-only fields for some state things (i.e not mapped). The state variable should alwa | df46103bd062da4b2463301e827b7759968c3d338d610bea7dd705a2b063e9ea |
| references | issue #9410 | issue #9930 | medium | > #9927 > > I encountered this one. I am trying to use dataclass-only fields for some state things (i.e not mapped). The state variable should always be created on object creation using the `default_factory` option. This works when creating the object and persisting, but if yo... | 6aa77c0a8b6c929cac5e67b861c4fd336fb5caba5d81075396b493391fac72fc |
| references | issue #9301 | issue #6120 | medium | I guess https://github.com/sqlalchemy/sqlalchemy/issues/6120 could help reduce the need of this. In any case it's probably best to just document the TYPE_CHECKING version | d289d65b6458f7d56065c6c4619d8fa94a00ae33e4dddd5abc0411fd02d2b1d9 |
| references | issue #9301 | issue #6120 | medium | OK, column_property() is not mapped_column(), yeah I think let's document for now. i dont know what will happen with #6120 , added some notes there. | 7e042644bd11e611ba9c18d395a6a3bc760bebc00d3e78bccf165103980a14b4 |
| references | issue #9212 | issue #9213 | medium | in the narrative docs at https://docs.sqlalchemy.org/en/20/orm/declarative_mixins.html . it just needs the `@classmethod` part discussed at #9213. I think we have actionable items on #9213 but for this one i dont see the action to take, other than maybe some more supplementary... | ae0f421cec53604dd2d04d59cd343e4561bab2d6a1d2d0e7b76ecc0127c1e1e1 |
| references | issue #9212 | issue #9213 | medium | 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... | 6100c6531a0dae5875a8398ff5894b968f4fa0eee7b8c532e833a5147559d650 |
| references | issue #9154 | issue #8762 | medium | 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... | 7d8d9ed321cb0b04e5587d49886261fd766e7e35406eb9ef4f15d323f7525427 |
| references | issue #9147 | issue #9832 | medium | the event hook here: https://github.com/sqlalchemy/sqlalchemy/blob/689ebc30dcd6b9cedf01d729f748b31826720b5c/lib/sqlalchemy/orm/decl_base.py#L567-L582 that's making a global event against Mapper. Declarative should make at most just *one* event hook against Mapper, then use its... | 2a0fb580bcb3916223f6c8a5ea029d9fa15d3ce1c00befe4b5122f8e66805010 |
| references | issue #9147 | issue #9832 | medium | not sure we really need this but in any case depends on #9832 | ab3a692c29a9dc2a749adccf5b8588fb317205c32c0216f36f322d0ae22ec6e0 |
| references | issue #9082 | issue #8889 | medium | "auto" was added in #8889. i see this issue refers to "auto". nobody anywhere is going to put "eager_defaults=False" so this is a really non-impactful issue | f6bb8a11bdf770f7b0d1d113db5a9e835ec2ab601d7ee0c8b276f3ceed437849 |
| references | issue #8992 | issue #8989 | medium | discovered during #8989, this is simply not implemented at all and the bind expression is ignored when it's an element of a tuple. Also, the impl of a TupleType() | 46c36af5913ed4eacd3c91b7bbfe671ecce76e43945986c60a3484702423ff7b |
| references | issue #8431 | issue #4340 | medium | in #4340 21fbb5e38f04affb8ac4502428672b3a629c we implemented "omit_join" behavior for the selectinload loader strategy. We currently don't have this | be4402f25acc07f124af834cc472d01f0ce93a1dab7e9b2e830cb1cdabac7701 |
| references | issue #7718 | issue #4379 | medium | 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... | 2cd630fe6d98a397f5edef48e378cf59644ae84f32b281f302d6d65d94107318 |
| references | issue #7475 | issue #8574 | medium | isables the key generation. > > I guess support for this could also be something could be added while updating this issue this was fixed in #8574 | 28f4bc9847f9f7c094b5fb92c6cd8c6d06557baf9d89b1bfa8ade97a731923e4 |
| references | issue #7366 | issue #3861 | medium | ### 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.com/ques... | 2e7d032f1638d66b0e7cdc29f6cb343737dff5fb8f2c4642346db74f964741b3 |
| references | issue #7366 | issue #8925 | medium | 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. | 78927e68ee67bcd9d85b529707d67f214e0655e0acdeeffb040c0255cc7bf03d |
| references | issue #7223 | issue #7212 | medium | Interval is an emulated type, that also subclasses `TypeDecorator`: https://github.com/sqlalchemy/sqlalchemy/blob/7f8bf038b753d3f250e0e974102c16037d1aea5d/lib/sqlalchemy/sql/sqltypes.py#L2026 This is different from the other emulated types, like Boolean and Enum, so for v2 it... | 2a739c8ae6f9847b9cc92bcc42c8b20336391c2f99a707dfa83a85e5d17738cd |
| references | issue #7113 | issue #4797 | medium | i mean also, "with_hint()" is badly named. "with_table_criteria()" is a better name _Originally posted by @zzzeek in https://github.com/sqlalchemy/sqlalchemy/issues/4797#issuecomment-930432024_ perhaps we can generalize with_hint() into with_table_criteria() and then introduce... | 50e63eb4d468685fec040fcaa2af270b82315d792dcc6482f0724f6a049322eb |
| references | issue #7113 | issue #4797 | medium | "hints" like indexing hints. other kinds of per-table constructs are placed differently, such as the for_system_time() we are looking at in #4797. So where with_hint() sends these three indicators of intent: * subject table * text that is to be treated like an indexing hint or... | 89e934eead9c2694cb06fab9d5a4e9b1bb65448b5a42b79e2d873a19a103639f |
| references | issue #7113 | issue #6040 | medium | this is related to #6040 as well and this could supersede it (that is, we wouldnt' have to do #6040 as written, with_hint would stay the same). i dont necessarily w | 56d7ce3c7e84b5ce242d91706255611b6310561f64f25f363a8fbe7b80141570 |
| references | issue #7035 | pr #7009 | medium | Follow up from the discussion is https://github.com/sqlalchemy/sqlalchemy/pull/7009 | b8edf9fc581ea46cec663713f306e2a7bef10a64f63cef291b15e447a94c85b7 |
| references | issue #6997 | issue #6550 | medium | yeah it's #6550 and the line that makes this test case "work" is to reintroduce a clear bug: ```py diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalc | 3f8a2010611d5690759e89811881bce5dabdbe359ee47438b15f4dc1d5d54ff4 |
| references | issue #6810 | issue #7519 | medium | related issues: #7535 #7519 #7562 #7555 | a94817bcb124b28ea4a4cb3f9602542f33c5358e01bbee372e0507b6416d0e63 |
| references | issue #6810 | issue #7535 | medium | related issues: #7535 #7519 #7562 #7555 | d4aaebc5c78c4a4b079f6de04e8d2ec772f842bc827838aecc742bfbb7f1f8d4 |
| references | issue #6810 | issue #7555 | medium | related issues: #7535 #7519 #7562 #7555 | 86a8c38658bfe444b962d2f4fc6d64ed3732aa4a908bf0648049d1b015d09405 |
| references | issue #6810 | issue #7562 | medium | related issues: #7535 #7519 #7562 #7555 | 6745f63f6542c2f5a3f4a02a547444ae9bdc3eb2d982a0b3f8d8cced22af3d0a |
| references | issue #6810 | issue #7774 | medium | ensure assocaition proxy collection implement typing.List/Set/Dict, see #7774 | f9df48673284f4383ff4a733920118d8d97a587b346e89c872f38fe3ed900bd2 |
| references | issue #6810 | pr #12384 | medium | I started to work on the `postgresql` dialect, first PR https://github.com/sqlalchemy/sqlalchemy/pull/12384 about the `array` module. | f6ac59568cc3c2c9f51ff0c63f889bdaa2048955b40a374c358e7a5434c2b6d3 |
| references | issue #6810 | pr #12707 | medium | Hi @CaselIT, When you have a moment, could you please review my [PR for `sqlalchemy.sql.base`](https://github.com/sqlalchemy/sqlalchemy/pull/12707)? Once it's acknowledged, I’d like to plan follow-up typing contributions for another untyped module( [`sqlalchemy.sql.crud`](http... | ac0bc5840d337138bb5f3e8e1afc380e5ea1e5f43025253a6c0bdff304180daf |
| references | issue #6810 | pr #12759 | medium | Hi @zzzeek, @CaselIT Sorry to interrupt, but I’ve run into a typing-related question while working on the compiler module. I’ve opened a **temporary PR** to explain the issue and provide context: **Temp PR:** https://github.com/sqlalchemy/sqlalchemy/pull/12759 Would appreciate... | 20604fad3923d47bc94c818a11be233a515589bba4611ae0d1a92bb812ad0415 |
| references | issue #6612 | issue #5256 | medium | Hi, I remembered asking a similar question. Here it is: https://github.com/sqlalchemy/sqlalchemy/issues/5256 tldr: you can use `.self_group()` | 4f25441a9414f48a6ae7ca3c7cc1804700050c6f2c03aa5e4efbd23ccd552cb5 |
| references | issue #6612 | issue #3566 | medium | nks, I did not find the existing issue via search, but maybe my search terms were inadequate. Since your issue was closed to be tracked in, #3566, which in turn is marked resolved, should we keep one open as use case? Other than that, feel free to close. | bb574eebf4accfee90b97bac6bb48ffb38baa12807e20f718e164c6345d76a1a |
| references | issue #6612 | issue #3566 | medium | s, I did not find the existing issue via search, but maybe my search terms were inadequate. > Since your issue was closed to be tracked in, #3566, which in turn is marked resolved, should we keep one open as use case? Other than that, feel free to close. Don't worry, searching... | 98cea930c0dfe68467daf5ad430f7875f62fc2e83b94b62c2d2fa91c7b0cdd3f |
| references | issue #6612 | issue #3566 | medium | in #3566 it wasn't that clear to me what was going on but in this case I'd want to see if row valued types can signal to the compiler and/or express | 200739e1b639c2e2377c8975f2819b84d36089fe843b5a9bbbd95b792c2cad6c |
| references | issue #6612 | issue #5256 | medium | this is an example: https://github.com/sqlalchemy/sqlalchemy/issues/5256#issue-600623503 ```sql select * from some_table where some_table is not null ``` vs ```sql select * from some_table where not (some_table is null) ``` the return values is different if a row has all null... | aba04a72b7065614496b4568f6e340647dd8eb931de59224bc70545e4d7db692 |
| references | issue #6511 | pr #12510 | medium | In https://github.com/sqlalchemy/sqlalchemy/pull/12510, I am proposing to an implementation for PostgreSQL. On SQLite, AFAICT, this does not seem possible as the `table_info` or `table_xinfo` pragmas apparently do not return the collation information. (On other backends, I don... | 7612279ea163b2a36aa13bc4d5aedb5dbcdb37a7858195b36a2f873188688fc1 |
| references | issue #6489 | issue #3357 | medium | as discussed at #3357, an additional execution option `dbapi_autocommit=True` that sets autocommit independently of setting an explicit isolation level would be | 8ff3c555b9f2423a7d9baa5842fc200942813615af74e0c9cbc5377c84d03cc3 |
| references | issue #6120 | issue #3050 | medium | I originally wanted to do this in #3050, which got marked as a dupe of #3150, which allowed column_property to work with declared_attr, however, never added the lambda part of it. | d6043b3c5e5eb760d2d1e5e5dda8c0f1e069480dcce8d9be6c35e88ae11d9bc8 |
| references | issue #6120 | issue #3150 | medium | I originally wanted to do this in #3050, which got marked as a dupe of #3150, which allowed column_property to work with declared_attr, however, never added the lambda part of it. there was some reason that using lam | 4ef91175f586af8fc0706eb90b25acc883b7b3a6c4c0732fe8319acf5aad08e7 |
| references | issue #5583 | issue #5578 | medium | From Mike: this is not a v2 thing, this is all a right now thing. 1. all backends should be raising an error when a user behavioral intent that cannot be fulfilled is received by a dialect, so first off, the for_update_clause() in compiler.py should be looking at all of these... | 43b337203449b6ffcbeeebd4140b0bc78a9429f3b5a59e9619566b4600bba140 |
| references | issue #5352 | issue #4250 | medium | ` 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 sqlalchemy.orm import * from sqlalchemy.ext.declarative import declarative... | e52020d3fd0708eec18c9105a092d01b85cc7a4c85337b5ebff365ad86f645db |
| references | issue #5352 | issue #4250 | medium | 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 | d0e0973f42a5107dc8c1bd251d3913dab08f08188b55087c50723927b116baaa |
| references | issue #5350 | issue #3989 | medium | I've read https://github.com/sqlalchemy/sqlalchemy/issues/3989 but this seems unrelated. When defining a `ForeignKey` on a SQLAlchemy model, if the referenced column is given as a string (`{table_name}.{column_name}`) and the `Base.metadata` has been setup with a naming conven... | 5972bb2c571f399892edd00a843c01f3f22162699af8e979c1f0899e29f2f791 |
| references | issue #5350 | issue #7706 | medium | 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... | 52d7a18a4228166359944e7023eed67c299308d5d51a325e6bcb901fb83aec8d |
| references | issue #5123 | issue #3692 | medium | 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... | 47cd105d237e37c61dd3ffa204d22a8f68fa72f6f11762693b11b689346dee08 |
| references | issue #5005 | issue #5068 | medium | suspect #5068 is seeing the same thing, although in that issue the warning call is being emitted incorrectly as this warning has failed to be part of tes | 2a2e20c4f9f7580148f1cb76e4c0a376eedf9fb27f03d07d6b380a3a676dfc9d |
| references | issue #4790 | issue #4784 | medium | There are a handful of messages that could be improved. 1. `sqlalchemy.exc.InvalidRequestError: Naming convention including %(constraint_name)s token requires that constraint is explicitly named.` This doesn't give much of a context. Suggestion for improvement: Extend message... | b9ac29948f155235dbd3ff38cdc1712dbae235a24e0d2cd7c0e70ea745e57177 |
| references | issue #4790 | issue #4784 | medium | ok, here we go again... > for 2, when does it raise that error? This was an edge-case you discovered in this comment- https://github.com/sqlalchemy/sqlalchemy/issues/4784#issuecomment-516582228 > I don't understand the extra context you are adding in 1. wouldn't they want to k... | 80cc2c0f3542e192c1c89a8f6faf604ce69e95399ef910f26e254e54d480c48b |
| closes | issue #4790 | issue #4784 | high | **jonathan vanasco** has proposed a fix for this issue in the **master** branch: **Fixes #4784 regarding constraints:** https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/2224 | a3a655fd2257ef94dd89fad84f4ea7da479ff9bd0fa823f2bb9d8b2e14205148 |
| references | issue #4784 | issue #5151 | medium | Note: perhaps use the enum listener example in #5151 | 4755062d1415cf09bb4263b99b28d7ab58c9a0be01916ef7c506960fbe3ba1a4 |
| references | issue #4652 | issue #3155 | medium | for [Column](https://docs.sqlalchemy.org/en/13/core/metadata.html#sqlalchemy.schema.Column.params.server_default) and a couple issues here (#3155,#3444), it's still unclear how to "correctly" include an explicit "ON UPDATE" clause. The only solution I have come to so far was s... | 7091d0690f411f24f8b11e545157d276113f15ec5899800865ca62804a5f736f |
| references | issue #4652 | issue #3444 | medium | olumn](https://docs.sqlalchemy.org/en/13/core/metadata.html#sqlalchemy.schema.Column.params.server_default) and a couple issues here (#3155,#3444), it's still unclear how to "correctly" include an explicit "ON UPDATE" clause. The only solution I have come to so far was specifi... | b2fae7f6d189d6d3ac05440064fbc7b073e638a9420417585a3b72fa6ece71db |
| references | issue #4652 | issue #3155 | medium | for [Column](https://docs.sqlalchemy.org/en/13/core/metadata.html#sqlalchemy.schema.Column.params.server_default) and a couple issues here (#3155,#3444), it's still unclear how to "correctly" include an explicit "ON UPDATE" clause. > > The only solution I have come to so far w... | 2c508532add8eb8a6b9cb8419b946c56a1574b51cd1626ed76e6f8f586d4f43e |
| references | issue #4652 | issue #3444 | medium | olumn](https://docs.sqlalchemy.org/en/13/core/metadata.html#sqlalchemy.schema.Column.params.server_default) and a couple issues here (#3155,#3444), it's still unclear how to "correctly" include an explicit "ON UPDATE" clause. > > The only solution I have come to so far was spe... | f563149d0f6cbe61e526f83bcbbaca7ab4a92bab767e75b39283f5f169345a5b |
| references | issue #4641 | issue #4640 | medium | with #4640 we are going to start adding mapper flags that folks will want to be able to apply across the board. so to make this easier without the nee | f4a03b391bcfc9c72613f3f90008d3099b0c5c43d6308a90b7dcdbce1c6dbd3b |
| references | issue #4567 | issue #4360 | medium | to be ignored on the table slippy_tiles but nothing seems to take when creating the schema from ORM, even though it is supposedly fixed in #4360 I've tried renaming the kwarg in the column definitions to sqlite_on_conflict_primary_key, sqlite_on_conflict, on_conflict, editing... | c9f080d74242225e224317e71bbae1dff8e8de902467705e1acec704a5d69495 |
| references | issue #4289 | issue #3989 | medium | **Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** note in #3989 we don't truncate naming conventions for things other than indexes. | 2a2ff5f4f2087393917aca91e4535d41da63cec84bb0ac58c350cdad1f4d259f |
| references | issue #1063 | issue #3990 | medium | **Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** Issue #3990 was marked as a duplicate of this issue. | 5c17de2e384aa534011ab01aab6e73b9be174822a285c21303f68440e83d287b |
| references | issue #1063 | issue #3496 | medium | **Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** as tihs would also fix #3496 I'm motivated to work on this, but I'm struggling. https://gerrit.sqlalchemy.org/427 | 1f896a059c727a29e8fb06cc21f10cc6d37f3bd0ce9a926417b8152a8c1208a0 |
| references | issue #12730 | issue #6810 | medium | chemy-stubs` and `sqlalchemy2-stubs` are not compatible with v2) ### Verify if the api is typed - [x] The api is not in a module listed in [#6810](https://github.com/sqlalchemy/sqlalchemy/issues/6810) so it should pass type checking ### Describe the typing issue When passing m... | 3842d0eec177fae874259fa4e9ea3e33a879e328b11d034e013224deadda18ad |
| references | issue #9618 | issue #9603 | medium | ne in https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/4548. Among other things this will be a real solution to the problem faced at #9603 and will also be a hedge against any other database where we can't guarantee INSERT ordering. for use_insertmanyvalues, it then bec... | 275bc98ada6d49989345e61ebf9f2d01d61290bb1a826bbaaad6ec6f9492c7ec |
| references | issue #9618 | issue #9603 | medium | ning(table)", something like that 4. limit the use of insertmanyvalues **just in the unit of work**. after all that was the issue we had in #9603 | 09c040e81bdeaca0358effa59681e4df6040d3c0b8da7be8a8736504a8ccbb45 |
| references | issue #9618 | issue #9603 | medium | y, meaning if that order is off, any situation where those objects have further collections on them we'd be seeing the issue like we see in #9603. That's tens of millions of downloads per month where we would assume applications have tolerated concurrent VACUUMs and things lik... | b283236773c64ef1bd5167c56f142f85e7a8327de35e52c6b99be54049ade30d |
| references | issue #9603 | issue #9618 | medium | doing a lot of thinking over at #9618. I think we can definitely restore MS-SQLs "insertmanyvalues" feature as long as we dont use it in the unit of work to match up primary key | 8f2b5ac1afb6546a0cb8a56a1face423d713f2570269c2c95a9e327b810240ba |
| references | issue #9563 | issue #9410 | medium | s or similar dataclass limitations gets reported, so maybe people are not that familiar with them? In any case i've mentioned this issue in #9410 regarding re-raise we can decide later, since it's easy to add, not that easy to remove | a87dfd77e9c7ebeb1cbccc83ff4fdbf9ea394e9b70f9e682effbc302a3ff2f44 |
| references | issue #7774 | issue #6810 | medium | otation to an association proxy in all cases. whether or not associationproxy accommodates `Mapped[]` right now will be resolved as part of #6810, you can use a cast() in the interim: ```py from sqlalchemy.orm import Mapped class Parent(Base): __tablename__ = "parent" id = Col... | d91ccb3c45294a659d2db985ac618146ffca9ff9b3821c260d12aa0dcc093cf5 |
| references | issue #7774 | issue #6810 | medium | erialization. Here you're looking for AssocaitionList/set/dict to implement the appropriate typing collection. This will be done as part of #6810 in 2.0. | 31dd4ed3777db58146ebd086102cdbfaae9967c91b5624762c575ca5a1c24133 |
| references | issue #7774 | issue #6810 | medium | Hey, i'm not if this is the correct ticket to place this, so please tell me if not. According to https://github.com/sqlalchemy/sqlalchemy/issues/6810, the association_proxy (so probably also the AssociationList) is already fully typed. But in this case, shouldn't `tags` be suc... | 09fe6be2119eee9006741ec26ab30e864b1409e458d87a33a575401cb4a0af93 |
| references | issue #7706 | issue #5350 | medium | Ah sorry, I guess this may be a duplicate of #5350 | 82c1a816e027b666cc3b204fc6caf30893bf626d36bce2e7b80651255ace6baa |
| references | issue #7659 | pr #8136 | medium | Alright, started a draft PR here for discussion https://github.com/sqlalchemy/sqlalchemy/pull/8136 | 21d30cde20323ca02f40a17cb515a18a41b017ee4a6bab4b1910329b697deeb3 |
| references | issue #5578 | issue #5583 | medium | 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 | ef8f51719f405bfe5f711673830d9ee64ddf66ae430560b98189c25592d325ea |
| references | issue #5256 | issue #3566 | medium | -comparison.html after the tip note. just FYI there's a ton of PG stuff that we don't have built in right now that are along this line, see #3566 . if you want to work on this stuff it's definitely leveling up but 1.4 should be getting very good at this stuff by now :) > > Als... | 97660fc0b5c1e24698abdcd0de4b9acbf303260b77d379aa7908a023d6636e70 |
| references | issue #5256 | issue #3566 | medium | I want to ultiamtely do everything here and in #3566. this comes up all the time. it's just if it is done quickly without consdiering PG's syntactical concepts in total, we can paint ourselves | ae21bcd22215bc615a552e5650f90f51159ea476e1726896d7873c6fb008874d |
| references | issue #5256 | issue #3566 | medium | Added a comment in #3566. This can be closed, so we can track all the missing pg behaviors from a single place | 3dd4c09ac674e5ebeb1966793bea320cea8059b0304dbcc81afb95cba8c6218b |
| references | issue #5068 | issue #5005 | medium | hen UPDATE if "supports_sane_rowcount" is set to **True** Hi can you define "failed" please? Are you getting the same error as described in #5005 ? > In fact, it is common to disable "supports_sane_rowcount" as a workaround for `pyodbc` and `Microsoft ODBC Driver` does not sup... | 783bd19817db559cf44997e51a84a79c0418f8134675a253c04f3c4ef4d24b1f |
| references | issue #4797 | issue #6040 | medium | ere, which would be pretty weird. The "hint text" should be possible that it is a compiled object, not just a string and that is missing os #6040 is added. | 594f606bb1fa02fc0420bbd62bf368ea2661ec500b0b08968d61b562db5f4cae |
Older linked/duplicate cards remain available under the work-thread and issue-collapse layers.
| Cluster | Members | Items | Maintainer Use | Similarity |
|---|---|---|---|---|
| PR #13421 with linked issues linked_issue_pr | 2 | pr #13421, issue #13420 | Review the issue and PR together instead of triaging both separately. | |
| PR #13418 with linked issues linked_issue_pr | 2 | pr #13418, issue #9693 | Review the issue and PR together instead of triaging both separately. | |
| PR #13405 with linked issues linked_issue_pr | 2 | pr #13405, issue #13407 | Review the issue and PR together instead of triaging both separately. | |
| PR #13404 with linked issues linked_issue_pr | 2 | pr #13404, issue #13406 | Review the issue and PR together instead of triaging both separately. | |
| PR #13402 with linked issues linked_issue_pr | 2 | pr #13402, issue #10748 | Review the issue and PR together instead of triaging both separately. | |
| PR #13399 with linked issues linked_issue_pr | 2 | pr #13399, issue #13048 | Review the issue and PR together instead of triaging both separately. | |
| PR #13398 with linked issues linked_issue_pr | 2 | pr #13398, issue #13419 | Review the issue and PR together instead of triaging both separately. | |
| PR #13368 with linked issues linked_issue_pr | 2 | pr #13368, issue #11132 | Review the issue and PR together instead of triaging both separately. | |
| PR #13323 with linked issues linked_issue_pr | 2 | pr #13323, issue #8992 | Review the issue and PR together instead of triaging both separately. | |
| PR #13303 with linked issues linked_issue_pr | 2 | pr #13303, issue #13157 | Review the issue and PR together instead of triaging both separately. | |
| PR #13289 with linked issues linked_issue_pr | 2 | pr #13289, issue #13227 | Review the issue and PR together instead of triaging both separately. | |
| PR #13288 with linked issues linked_issue_pr | 2 | pr #13288, issue #13169 | Review the issue and PR together instead of triaging both separately. | |
| PR #13051 with linked issues linked_issue_pr | 2 | pr #13051, issue #13049 | Review the issue and PR together instead of triaging both separately. | |
| PR #12697 with linked issues linked_issue_pr | 2 | pr #12697, issue #9693 | Review the issue and PR together instead of triaging both separately. | |
| PR #12401 with linked issues linked_issue_pr | 2 | pr #12401, issue #12398 | Review the issue and PR together instead of triaging both separately. | |
| PR #12297 with linked issues linked_issue_pr | 2 | pr #12297, issue #11620 | Review the issue and PR together instead of triaging both separately. | |
| PR #11296 with linked issues linked_issue_pr | 2 | pr #11296, issue #11122 | Review the issue and PR together instead of triaging both separately. | |
| Possible related issues #10094 and #9410 duplicate_candidate | 2 | issue #10094, issue #9410 | Consider whether these can share one answer, close path, or implementation thread. | 0.6 |
| Possible related issues #12585 and #8795 duplicate_candidate | 2 | issue #12585, issue #8795 | Consider whether these can share one answer, close path, or implementation thread. | 0.333 |
Release boundary for this preview bundle.
| Field | Value |
|---|---|
| Repo | sqlalchemy/sqlalchemy |
| Generated | 2026-07-07T19:49:19+00:00 |
| Packet hash | 9b4298e4dd5929576ce90bfe1cbb17896dee99542f68bd4e1e06570e458bbad7 |
| Metrics hash | 56f2d20521473f8f90c56a9e875e9a4f23820af73add5ed8b7c2b777681c5cdf |
| Full collection | True |
| Raw API public | False |
| Public actions allowed | False |
The bundle includes these reduced public-safe artifacts. Full raw API payloads, diffs, and patches are not included.
| Artifact | Role |
|---|---|
data/summary_metrics.json | run metrics and safety flags |
data/maintainer_moves.csv | workflow-first maintainer moves grouped by same next action |
data/simulated_resolution_packages.csv | local maintainer action bundles with diagnoses and next steps |
data/dry_run_proof_actions.csv | no-write audit rows for all issues and stale PRs |
data/issue_collapse_groups.csv | public-safe maintainer review threads |
data/work_threads.csv | public-safe graph work threads |
data/relationship_edges.csv | evidence-backed item links |
data/issues.csv | all represented open issues |
data/pull_requests.csv | all represented open pull requests |
data/attention_queue.csv | ranked issue and PR attention queue |
data/cluster_cards.csv | legacy linked and duplicate candidate cards |
data/backlog_report.md | readable report |