| <div class='bi-wrap'><section class='bi-band'><div class='bi-title'><div><h2>Actionable Diagnostics</h2><p>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.</p></div><span class='status-pill'>evidence-bound advice</span></div><div class='metric-grid'><div class='metric'><div class='metric-value'>75</div><div class='metric-label'>Diagnosed bundles</div><div class='metric-note'>recommended next step attached</div></div><div class='metric'><div class='metric-value'>18</div><div class='metric-label'>High-confidence diagnoses</div><div class='metric-note'>local evidence is specific</div></div><div class='metric'><div class='metric-value'>0</div><div class='metric-label'>GitHub writes</div><div class='metric-note'>local-only; no GitHub writes</div></div></div><div class='scroll-table'><table class='bi-table'><thead><tr><th>Bundle</th><th>Diagnosis Kind</th><th>Diagnosis</th><th>Recommended Next Step</th><th>Covers</th><th>Confidence</th><th>Evidence</th></tr></thead><tbody><tr><td><strong>SIM-018</strong><div class='muted'>Existing PR blocked review</div></td><td>failed_static_checks</td><td><div class='wide'>PR #12401 is blocked by failing static/type checks: pep484-3.14, pep8-3.14; pending owner gate: gerrit_review.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#12398</span></span></div><div><span class='chip-row'><span class='chip'>PR #12401</span></span></div></td><td>high</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-020</strong><div class='muted'>Existing PR blocked review</div></td><td>failed_static_checks</td><td><div class='wide'>PR #12645 is blocked by failing static/type checks: pep484-3.12; pending owner gate: gerrit_review.</div></td><td><div class='wide'>Fix or ask the contributor to fix pep484-3.12, rerun checks, then revisit review/owner-gate approval once the branch is green.</div></td><td><div><span class='chip-row'><span class='muted'>none</span></span></div><div><span class='chip-row'><span class='chip'>PR #8136</span><span class='chip'>PR #12645</span></span></div></td><td>high</td><td><div class='wide'>failed checks: pep484-3.12; pending owner gate: gerrit_review.</div></td></tr><tr><td><strong>SIM-014</strong><div class='muted'>Existing PR contributor wait</div></td><td>failed_static_checks</td><td><div class='wide'>PR #13051 is blocked by failing static/type checks: mypy-3.14; pending owner gate: gerrit_review.</div></td><td><div class='wide'>Fix or ask the contributor to fix mypy-3.14, rerun checks, then revisit review/owner-gate approval once the branch is green.</div></td><td><div><span class='chip-row'><span class='chip'>#13049</span></span></div><div><span class='chip-row'><span class='chip'>PR #13051</span></span></div></td><td>high</td><td><div class='wide'>failed checks: mypy-3.14; pending owner gate: gerrit_review.</div></td></tr><tr><td><strong>SIM-019</strong><div class='muted'>Existing PR blocked review</div></td><td>merge_state_blocked</td><td><div class='wide'>PR #10574 appears blocked by merge state `DIRTY`.</div></td><td><div class='wide'>Rebase/update the branch against main, then rerun checks before maintainer review.</div></td><td><div><span class='chip-row'><span class='chip'>#2943</span></span></div><div><span class='chip-row'><span class='chip'>PR #10574</span></span></div></td><td>high</td><td><div class='wide'>mergeStateStatus=DIRTY; branch=issue_2943</div></td></tr><tr><td><strong>SIM-016</strong><div class='muted'>Existing PR contributor wait</div></td><td>merge_state_blocked</td><td><div class='wide'>PR #11296 appears blocked by merge state `DIRTY`.</div></td><td><div class='wide'>Rebase/update the branch against main, then rerun checks before maintainer review.</div></td><td><div><span class='chip-row'><span class='chip'>#11122</span></span></div><div><span class='chip-row'><span class='chip'>PR #11296</span></span></div></td><td>high</td><td><div class='wide'>mergeStateStatus=DIRTY; branch=feature/GH-11122/table-with</div></td></tr><tr><td><strong>SIM-021</strong><div class='muted'>Existing PR contributor wait</div></td><td>merge_state_blocked</td><td><div class='wide'>PR #11437 appears blocked by merge state `DIRTY`.</div></td><td><div class='wide'>Rebase/update the branch against main, then rerun checks before maintainer review.</div></td><td><div><span class='chip-row'><span class='muted'>none</span></span></div><div><span class='chip-row'><span class='chip'>PR #11107</span><span class='chip'>PR #11297</span><span class='chip'>PR #11437</span></span></div></td><td>high</td><td><div class='wide'>mergeStateStatus=DIRTY; branch=fix-examples-2</div></td></tr><tr><td><strong>SIM-001</strong><div class='muted'>Existing PR owner-test gate</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13323 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#8992</span></span></div><div><span class='chip-row'><span class='chip'>PR #13323</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-006</strong><div class='muted'>Existing PR owner-test gate</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13418 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#6511</span><span class='chip'>#9693</span></span></div><div><span class='chip-row'><span class='chip'>PR #12697</span><span class='chip'>PR #12698</span><span class='chip'>PR #13418</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-008</strong><div class='muted'>Existing PR owner-test gate</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13405 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#13407</span></span></div><div><span class='chip-row'><span class='chip'>PR #13405</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-009</strong><div class='muted'>Existing PR owner-test gate</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13404 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#13406</span></span></div><div><span class='chip-row'><span class='chip'>PR #13404</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-010</strong><div class='muted'>Existing PR owner-test gate</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13399 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#13048</span></span></div><div><span class='chip-row'><span class='chip'>PR #13399</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-011</strong><div class='muted'>Existing PR owner-test gate</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13398 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#13419</span></span></div><div><span class='chip-row'><span class='chip'>PR #13398</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-012</strong><div class='muted'>Existing PR owner-test gate</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13368 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#11132</span></span></div><div><span class='chip-row'><span class='chip'>PR #13368</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-003</strong><div class='muted'>Existing PR contributor wait</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13303 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#13157</span></span></div><div><span class='chip-row'><span class='chip'>PR #13303</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-022</strong><div class='muted'>Existing PR owner-test gate</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13417 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='muted'>none</span></span></div><div><span class='chip-row'><span class='chip'>PR #13137</span><span class='chip'>PR #13312</span><span class='chip'>PR #13415</span><span class='chip'>PR #13416</span><span class='chip'>PR #13417</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-004</strong><div class='muted'>Existing PR contributor wait</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13289 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#9410</span><span class='chip'>#9493</span><span class='chip'>#9930</span><span class='chip'>#10094</span><span class='chip'>#13227</span></span></div><div><span class='chip-row'><span class='chip'>PR #13289</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-013</strong><div class='muted'>Existing PR contributor wait</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #13288 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#13169</span></span></div><div><span class='chip-row'><span class='chip'>PR #13288</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-017</strong><div class='muted'>Existing PR decision</div></td><td>owner_test_approval_gate</td><td><div class='wide'>PR #12731 is waiting on repository-owner test approval: gerrit_review.</div></td><td><div class='wide'>Maintainer should inspect or approve the gated run, then decide the PR with linked issues in view.</div></td><td><div><span class='chip-row'><span class='chip'>#6120</span><span class='chip'>#6810</span><span class='chip'>#9301</span><span class='chip'>#9587</span><span class='chip'>#10351</span><span class='chip'>#10527</span><span class='chip'>#10888</span><span class='chip'>#11686</span><span class='chip'>#13357</span></span></div><div><span class='chip-row'><span class='chip'>PR #12731</span></span></div></td><td>high</td><td><div class='wide'>pending checks: gerrit_review</div></td></tr><tr><td><strong>SIM-005</strong><div class='muted'>Existing PR contributor wait</div></td><td>contributor_update_needed</td><td><div class='wide'>PR #12433 is contributor-owned until requested changes or review questions are answered.</div></td><td><div class='wide'>Keep parked or close after maintainer review if the contributor path is no longer active; do not ask for maintainer work first.</div></td><td><div><span class='chip-row'><span class='chip'>#6274</span></span></div><div><span class='chip-row'><span class='chip'>PR #12433</span></span></div></td><td>medium</td><td><div class='wide'>reviewDecision=CHANGES_REQUESTED; stale_days=479</div></td></tr><tr><td><strong>SIM-002</strong><div class='muted'>Existing PR blocked review</div></td><td>maintainer_decision_needed</td><td><div class='wide'>PR #13402 has no local failed-check diagnosis; it needs a maintainer merge/close/rebase decision.</div></td><td><div class='wide'>Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.</div></td><td><div><span class='chip-row'><span class='chip'>#10748</span></span></div><div><span class='chip-row'><span class='chip'>PR #13402</span></span></div></td><td>medium</td><td><div class='wide'>reviewDecision=; mergeStateStatus=UNSTABLE; pending=code_review; stale_days=8</div></td></tr><tr><td><strong>SIM-007</strong><div class='muted'>Existing PR blocked review</div></td><td>maintainer_decision_needed</td><td><div class='wide'>PR #13421 has no local failed-check diagnosis; it needs a maintainer merge/close/rebase decision.</div></td><td><div class='wide'>Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.</div></td><td><div><span class='chip-row'><span class='chip'>#13420</span></span></div><div><span class='chip-row'><span class='chip'>PR #13421</span></span></div></td><td>medium</td><td><div class='wide'>reviewDecision=; mergeStateStatus=UNSTABLE; pending=code_review; stale_days=0</div></td></tr><tr><td><strong>SIM-015</strong><div class='muted'>Existing PR decision</div></td><td>maintainer_decision_needed</td><td><div class='wide'>PR #12297 has no local failed-check diagnosis; it needs a maintainer merge/close/rebase decision.</div></td><td><div class='wide'>Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.</div></td><td><div><span class='chip-row'><span class='chip'>#11620</span></span></div><div><span class='chip-row'><span class='chip'>PR #12297</span></span></div></td><td>medium</td><td><div class='wide'>reviewDecision=; mergeStateStatus=CLEAN; pending=; stale_days=473</div></td></tr><tr><td><strong>SIM-023</strong><div class='muted'>Existing stale PR sweep</div></td><td>maintainer_decision_needed</td><td><div class='wide'>PR #11180 has no local failed-check diagnosis; it needs a maintainer merge/close/rebase decision.</div></td><td><div class='wide'>Review changed files, linked issues, and latest maintainer comments, then choose merge, close, rebase request, or maintainer takeover.</div></td><td><div><span class='chip-row'><span class='muted'>none</span></span></div><div><span class='chip-row'><span class='chip'>PR #11180</span></span></div></td><td>medium</td><td><div class='wide'>reviewDecision=; mergeStateStatus=CLEAN; pending=; stale_days=595</div></td></tr><tr><td><strong>SIM-035</strong><div class='muted'>New maintainer code PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This loader options bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#9548</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #9548: high-priority/blocker; labels: bug, high priority, orm, loader options; title: relationship loader options do a "recursive" thing inconsistently</div></td></tr><tr><td><strong>SIM-038</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This dml bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#10675</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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?</div></td></tr><tr><td><strong>SIM-042</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This mysql bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#8341</span><span class='chip'>#8457</span><span class='chip'>#10310</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-025</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This datatypes bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#13212</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>it's #4384</div></td></tr><tr><td><strong>SIM-026</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This dml bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#13113</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #13113: needs maintainer decision; labels: sqlite, use case, dml; title: SQLite insert supports multiple on-conflict clauses in inserts</div></td></tr><tr><td><strong>SIM-027</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This general bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#10676</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #10676: needs maintainer decision; labels: setup; title: Add reasonable min version for the internal dialects packages / databases</div></td></tr><tr><td><strong>SIM-028</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This loader options bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#13204</span><span class='chip'>#13210</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-029</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This orm bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/orm/, test/orm/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#13153</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #13153: needs maintainer decision; labels: orm, use case; title: `composite` with in-place custom values getter</div></td></tr><tr><td><strong>SIM-030</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This performance bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/perf/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#10541</span><span class='chip'>#13311</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-031</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This reflection bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#7366</span><span class='chip'>#9468</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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....</div></td></tr><tr><td><strong>SIM-033</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This tests bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#9154</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-034</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This typing bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/typing/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#13253</span><span class='chip'>#13281</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-036</strong><div class='muted'>New docs PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This documentation bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against doc/, doc/build/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#5583</span><span class='chip'>#12101</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-037</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This asyncio bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#7604</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #7604: good volunteer slice; labels: postgresql, PRs (with tests!) welcome, use case, asyncio; title: add execution option for asyncpg_timeout</div></td></tr><tr><td><strong>SIM-039</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This documentation bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against doc/, doc/build/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#5139</span><span class='chip'>#9078</span><span class='chip'>#9212</span><span class='chip'>#9213</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-040</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This engine bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/engine/, test/engine/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#5123</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-041</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This general bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#7149</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #7149: good volunteer slice; labels: feature, sqlalchemy.ext, fairly easy; title: Automap: prefer snake_case over lower() for relationship attribute names</div></td></tr><tr><td><strong>SIM-043</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This oracle bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#5133</span><span class='chip'>#11312</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-044</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This orm bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/orm/, test/orm/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#6084</span><span class='chip'>#7732</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-045</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This postgresql bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#4434</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #4434: good volunteer slice; labels: postgresql, feature, schema, PRs (with tests!) welcome; title: Support for functions in UniqueConstraint</div></td></tr><tr><td><strong>SIM-046</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This schema bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#10341</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-047</strong><div class='muted'>New volunteer-ready PR</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This sql bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>Draft locally against lib/sqlalchemy/, test/, add focused regression coverage, and only open a GitHub PR if maintainers approve the scope.</div></td><td><div><span class='chip-row'><span class='chip'>#5564</span><span class='chip'>#5846</span><span class='chip'>#8352</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-032</strong><div class='muted'>New code/decision package</div></td><td>local_pr_draft_candidate</td><td><div class='wide'>This sqlite bundle is concrete enough for a local PR draft package.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#8795</span><span class='chip'>#12585</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>Possible related issues #12585 and #8795 shared tokens: autocommit, sqlite, support</div></td></tr><tr><td><strong>SIM-024</strong><div class='muted'>Duplicate/related issue sweep</div></td><td>duplicate_consolidation</td><td><div class='wide'>The local evidence indicates likely related reports that should share one canonical answer or implementation path.</div></td><td><div class='wide'>Pick the canonical issue, preserve the strongest reproduction, and close/link duplicates in one maintainer pass.</div></td><td><div><span class='chip-row'><span class='chip'>#8326</span><span class='chip'>#10335</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issues #8326 and #10335 share title/component terms: orm, support</div></td></tr><tr><td><strong>SIM-062</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a orm stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#1063</span><span class='chip'>#1140</span><span class='chip'>#2501</span><span class='chip'>#2792</span><span class='chip'>#3458</span><span class='chip'>#4641</span><span class='chip'>#5005</span><span class='chip'>#5541</span><span class='chip'>#6080</span><span class='chip'>#6137</span><span class='chip muted'>+21</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-064</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a postgresql stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#4289</span><span class='chip'>#5350</span><span class='chip'>#6612</span><span class='chip'>#7475</span><span class='chip'>#9944</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>**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...</div></td></tr><tr><td><strong>SIM-048</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a asyncio stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#6121</span><span class='chip'>#12710</span><span class='chip'>#12803</span><span class='chip'>#12972</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-049</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a connection pool stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#8693</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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)</div></td></tr><tr><td><strong>SIM-050</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a datatypes stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#4652</span><span class='chip'>#6874</span><span class='chip'>#7223</span><span class='chip'>#8936</span><span class='chip'>#11597</span><span class='chip'>#12628</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-051</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a declarative stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#5806</span><span class='chip'>#6411</span><span class='chip'>#9147</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-052</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a dialects stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#8321</span><span class='chip'>#10680</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-053</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a dml stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#10446</span><span class='chip'>#12096</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-054</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a documentation stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#4567</span><span class='chip'>#4706</span><span class='chip'>#4784</span><span class='chip'>#4790</span><span class='chip'>#5235</span><span class='chip'>#6332</span><span class='chip'>#7360</span><span class='chip'>#7517</span><span class='chip'>#8894</span><span class='chip'>#9839</span><span class='chip muted'>+4</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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-...</div></td></tr><tr><td><strong>SIM-055</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a engine stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#5815</span><span class='chip'>#6489</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-056</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a functions stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#5006</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #5006: stale/low urgency; labels: SQL Server, functions, use case; title: support for unusual function namespace separators</div></td></tr><tr><td><strong>SIM-057</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a general stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#2814</span><span class='chip'>#10064</span><span class='chip'>#10835</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-058</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a loader options stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#3037</span><span class='chip'>#5964</span><span class='chip'>#7426</span><span class='chip'>#8431</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-059</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a mariadb stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#7228</span><span class='chip'>#12561</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-060</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a mysql stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#1909</span><span class='chip'>#4272</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-061</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a oracle stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#7718</span><span class='chip'>#12341</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-063</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a performance stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#4855</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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?</div></td></tr><tr><td><strong>SIM-065</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a public api stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#8680</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #8680: stale/low urgency; labels: public api, typing; title: Better organize pep 484 types in the packages</div></td></tr><tr><td><strong>SIM-066</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a reflection stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#10435</span><span class='chip'>#10742</span><span class='chip'>#11385</span><span class='chip'>#11677</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-067</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a schema stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#9233</span><span class='chip'>#13007</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr><tr><td><strong>SIM-068</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a sql stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#1452</span><span class='chip'>#6040</span><span class='chip'>#6336</span><span class='chip'>#6700</span><span class='chip'>#7113</span><span class='chip'>#9425</span><span class='chip'>#10326</span><span class='chip'>#10780</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-069</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a sql server stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#5352</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-070</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a sqlite stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#10544</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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 ```...</div></td></tr><tr><td><strong>SIM-071</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a tests stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#5174</span><span class='chip'>#6468</span><span class='chip'>#6505</span><span class='chip'>#7035</span><span class='chip'>#7135</span><span class='chip'>#8805</span><span class='chip'>#9370</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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...</div></td></tr><tr><td><strong>SIM-072</strong><div class='muted'>Stale issue resolution sweep</div></td><td>stale_batch_policy</td><td><div class='wide'>This is a typing stale issue batch, not a single code diagnosis.</div></td><td><div class='wide'>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.</div></td><td><div><span class='chip-row'><span class='chip'>#8909</span><span class='chip'>#10417</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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)</div></td></tr><tr><td><strong>SIM-073</strong><div class='muted'>Waiting-info issue sweep</div></td><td>waiting_for_reporter_info</td><td><div class='wide'>This documentation batch is waiting for reporter/contributor information.</div></td><td><div class='wide'>Park or close unless existing evidence is enough for maintainers to reproduce without another ping.</div></td><td><div><span class='chip-row'><span class='chip'>#10531</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #10531: waiting on contributor; labels: bug, documentation, awaiting info, orm - annotated declarative; title: Issue with relationship typing when using Declarative-Imparative Mapping</div></td></tr><tr><td><strong>SIM-074</strong><div class='muted'>Waiting-info issue sweep</div></td><td>waiting_for_reporter_info</td><td><div class='wide'>This general batch is waiting for reporter/contributor information.</div></td><td><div class='wide'>Park or close unless existing evidence is enough for maintainers to reproduce without another ping.</div></td><td><div><span class='chip-row'><span class='chip'>#11136</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>issue #11136: waiting on contributor; labels: awaiting info, use case; title: Delete Propagation to Parent Table for Joined Table Inheritance</div></td></tr><tr><td><strong>SIM-075</strong><div class='muted'>Waiting-info issue sweep</div></td><td>waiting_for_reporter_info</td><td><div class='wide'>This orm batch is waiting for reporter/contributor information.</div></td><td><div class='wide'>Park or close unless existing evidence is enough for maintainers to reproduce without another ping.</div></td><td><div><span class='chip-row'><span class='chip'>#5999</span></span></div><div><span class='chip-row'><span class='muted'>none</span></span></div></td><td>medium</td><td><div class='wide'>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</div></td></tr></tbody></table></div></section></div> |
