| # sqlalchemy/sqlalchemy Backlog Intelligence Packet | |
| ## Coverage | |
| - Generated: `2026-07-07T19:49:19+00:00` | |
| - Open issues represented: `186` of `186` listed | |
| - Open PRs represented: `32` of `32` listed | |
| - Full collection: `True` | |
| - Work thread active coverage: `True` | |
| - Issue collapse coverage: `186` open issues in `99` groups | |
| - Issue collapse full coverage: `True` | |
| - Issue review-unit reduction: `46.8`% | |
| - Maintainer action bundles: `75` | |
| - Local PR draft packages: `23` | |
| - Existing PR decision bundles: `23` | |
| - Full issue/PR bundle coverage: `True` | |
| - No-write audit rows: `207` | |
| - No-write audit GitHub actions allowed: `False` | |
| - Relationship edges: `312` | |
| - Public actions authorized: `False` | |
| ## Local Board Simulation | |
| - Covered open issues: `186` | |
| - Covered open PRs: `32` | |
| - GitHub actions allowed: `False` | |
| - Resolution hash: `a4206ca984177a84dc3136c71b1201b6a95266c48ed4a2f991902a5abd571b04` | |
| - This local board simulation shows what the tool would open, review, close, merge, or park, without doing any of it on GitHub. | |
| ## No-Write Audit Packet | |
| - All open issue proof rows: `186` | |
| - Stale open PR proof rows: `21` | |
| - Proof hash: `9d91dbc2f3a3adbe6f66ac8c263ff87cecb0ecacdde4b322bccad0778ef34f90` | |
| - These rows are attachable evidence of what the tool can triage, but they do not comment, label, close, merge, or upload anything. | |
| ## Maintainer Review Threads | |
| - Multi-issue groups: `37` | |
| - PR-backed groups: `19` | |
| - Singleton issue groups retained for audit: `62` | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13323: Apply tuple bind expressions to expanding IN values - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#8992; active PRs: PR #13323) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13402: Allow inspection registrations from module reloads - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#10748; active PRs: PR #13402) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13303: Fix PostgreSQL CHECK constraint reflection stripping unrelated parens - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#13157; active PRs: PR #13303) | |
| - `5 issues` - Review thread: 5 issues + 1 PR - pr #13289: fix: raise clear error when default_factory/default passed to WriteOnlyMapped/DynamicMapped relationship - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#9410, #9493, #9930, #10094, #13227; active PRs: PR #13289) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #12433: Coerce aliased Select and CompoundSelect to subquery - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#6274; active PRs: PR #12433) | |
| - `2 issues` - Review thread: 2 issues + 3 PRs - pr #12697: Support schema-qualified collation in types for PostgreSQL - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#6511, #9693; active PRs: PR #12697, PR #12698, PR #13418) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13421: Fix oracledb async dialect entering cursors synchronously - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#13420; active PRs: PR #13421) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13405: # Cython batch instance processor — ~10–30% on most loads (collection joinedload −5%) - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#13407; active PRs: PR #13405) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13404: Subqueryload without per-row Row construction — ~26% on subqueryload - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#13406; active PRs: PR #13404) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13399: UniqueConstraint and Index withheld from table via attach_to_table flag, and appended to table via append_constraint - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#13048; active PRs: PR #13399) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13398: fix catastrophic backtracking in sqlite inline unique reflection regex - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#13419; active PRs: PR #13398) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13368: Document deprecated MySQL (M,D) float syntax and improve error message - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#11132; active PRs: PR #13368) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13288: fix(pool): use time.monotonic() instead of time.time() for connection timestamps - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#13169; active PRs: PR #13288) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #13051: Added implementations for avg & abs - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#13049; active PRs: PR #13051) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #12297: refactor(MSExecutionContext): improve identity insert handling and va… - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#11620; active PRs: PR #12297) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #11296: Ability to specify `WITH` when creating a table + fixes `WITH` when creating an index - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#11122; active PRs: PR #11296) | |
| - `9 issues` - Review thread: 9 issues + 1 PR - pr #12731: fix(typing): allow DeclarativeBase subclasses in with_for_update(of=...) - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#6120, #6810, #9301, #9587, #10351, #10527, #10888, #11686, #13357; active PRs: PR #12731) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #12401: Make loader strategy error message more verbose - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#12398; active PRs: PR #12401) | |
| - `1 issue` - Review thread: 1 issue + 1 PR - pr #10574: fixes: #2943, allow overriding validates for inheritance - linked work thread - Review issues, active PRs, referenced context, checks, and review guidance together instead of reopening each issue separately. (#2943; active PRs: PR #10574) | |
| - `1 issue` - Review thread: 1 issue - issue #7035: Use innodb in the test suite when using mysql/mariadb - linked work thread - Handle this tests stale queue with one sweep policy instead of rediscovering old context issue by issue. (#7035) | |
| ## Maintainer Work Threads | |
| - `94` pr #13323: Apply tuple bind expressions to expanding IN values - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13323, then review the thread evidence together. (issue #8992, PR #13323; context: issue #8989) | |
| - `73` pr #13402: Allow inspection registrations from module reloads - PR blocked - Review active PRs and linked issues as one maintainer work thread. (issue #10748, PR #13402) | |
| - `73` pr #13421: Fix oracledb async dialect entering cursors synchronously - PR blocked - Review active PRs and linked issues as one maintainer work thread. (issue #13420, PR #13421) | |
| - `70` pr #12697: Support schema-qualified collation in types for PostgreSQL - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13418, then review the thread evidence together. (issue #6511, issue #9693, PR #12697, PR #12698, PR #13418; context: PR #12510) | |
| - `70` pr #13368: Document deprecated MySQL (M,D) float syntax and improve error message - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13368, then review the thread evidence together. (issue #11132, PR #13368) | |
| - `70` 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 - Approve or inspect gated test run(s) for PR #13399, then review the thread evidence together. (issue #13048, PR #13399) | |
| - `70` pr #13404: Subqueryload without per-row Row construction — ~26% on subqueryload - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13404, then review the thread evidence together. (issue #13406, PR #13404) | |
| - `70` pr #13405: # Cython batch instance processor — ~10–30% on most loads (collection joinedload −5%) - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13405, then review the thread evidence together. (issue #13407, PR #13405) | |
| - `70` pr #13398: fix catastrophic backtracking in sqlite inline unique reflection regex - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13398, then review the thread evidence together. (issue #13419, PR #13398) | |
| - `65` pr #12401: Make loader strategy error message more verbose - PR blocked - Review active PRs and linked issues as one maintainer work thread. (issue #12398, PR #12401; context: issue #10668) | |
| - `62` pr #13303: Fix PostgreSQL CHECK constraint reflection stripping unrelated parens - waiting on contributor - Wait for contributor update on PR #13303; keep related issue/PR context attached. (issue #13157, PR #13303; context: PR #13188, PR #13200) | |
| - `60` pr #13415: scalars/mappings performance improvement. - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13415, then review the thread evidence together. (PR #13415) | |
| - `60` pr #13416: Perf/eager collection bulk extend - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13416, then review the thread evidence together. (PR #13416) | |
| - `60` pr #13417: Add type annotations to sqlalchemy.ext.serializer - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13417, then review the thread evidence together. (PR #13417) | |
| - `55` pr #10574: fixes: #2943, allow overriding validates for inheritance - PR blocked - Review active PRs and linked issues as one maintainer work thread. (issue #2943, PR #10574) | |
| - `55` pr #12645: enable mypy "ignore-without-code" rule - PR blocked - PR blocked (PR #12645) | |
| - `52` pr #13289: fix: raise clear error when default_factory/default passed to WriteOnlyMapped/DynamicMapped relationship - waiting on contributor - Wait for contributor update on PR #13289; keep related issue/PR context attached. (issue #9410, issue #9493, issue #9930, issue #10094, issue #13227, PR #13289; context: issue #5811, issue #9350, issue #9563, issue #9785, issue #9927, issue #12168) | |
| - `52` pr #12433: Coerce aliased Select and CompoundSelect to subquery - waiting on contributor - Wait for contributor update on PR #12433; keep related issue/PR context attached. (issue #6274, PR #12433; context: issue #10236) | |
| - `52` issue #9548: relationship loader options do a "recursive" thing inconsistently - high-priority/blocker - high-priority/blocker (issue #9548) | |
| - `52` pr #13137: Use _effective_decimal_return_scale in Numeric.result_processor - waiting on repo owner test approval - Approve or inspect gated test run(s) for PR #13137, then review the thread evidence together. (PR #13137) | |
| ## Maintainer Attention Queue | |
| - `94` issue #8992: [tuple expanding params do not render bind_expression() for elements](https://github.com/sqlalchemy/sqlalchemy/issues/8992) - has linked PR - review early; this can change release or regression risk | |
| - `73` pr #13421: [Fix oracledb async dialect entering cursors synchronously](https://github.com/sqlalchemy/sqlalchemy/pull/13421) - PR blocked - identify whether block is CI, merge conflict, or review gate | |
| - `73` pr #13402: [Allow inspection registrations from module reloads](https://github.com/sqlalchemy/sqlalchemy/pull/13402) - PR blocked - identify whether block is CI, merge conflict, or review gate | |
| - `70` pr #13405: [# Cython batch instance processor — ~10–30% on most loads (collection joinedload −5%)](https://github.com/sqlalchemy/sqlalchemy/pull/13405) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `70` pr #13398: [fix catastrophic backtracking in sqlite inline unique reflection regex](https://github.com/sqlalchemy/sqlalchemy/pull/13398) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `70` pr #13418: [Use identifier preparer for string type collations](https://github.com/sqlalchemy/sqlalchemy/pull/13418) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `70` pr #13399: [UniqueConstraint and Index withheld from table via attach_to_table flag, and appended to table via append_constraint](https://github.com/sqlalchemy/sqlalchemy/pull/13399) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `70` pr #13404: [Subqueryload without per-row Row construction — ~26% on subqueryload](https://github.com/sqlalchemy/sqlalchemy/pull/13404) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `70` pr #13368: [Document deprecated MySQL (M,D) float syntax and improve error message](https://github.com/sqlalchemy/sqlalchemy/pull/13368) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `65` pr #12401: [Make loader strategy error message more verbose](https://github.com/sqlalchemy/sqlalchemy/pull/12401) - PR blocked - identify whether block is CI, merge conflict, or review gate | |
| - `62` issue #10748: [schemes that attempt to reload modules are blocked by the inspection registry](https://github.com/sqlalchemy/sqlalchemy/issues/10748) - has linked PR - review linked PR state before touching issue | |
| - `62` pr #13323: [Apply tuple bind expressions to expanding IN values](https://github.com/sqlalchemy/sqlalchemy/pull/13323) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `62` issue #13157: [PostgreSQL check constraint reflection strips brackets naively](https://github.com/sqlalchemy/sqlalchemy/issues/13157) - has linked PR - review linked PR state before touching issue | |
| - `60` pr #13415: [scalars/mappings performance improvement.](https://github.com/sqlalchemy/sqlalchemy/pull/13415) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `60` pr #13417: [Add type annotations to sqlalchemy.ext.serializer](https://github.com/sqlalchemy/sqlalchemy/pull/13417) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `60` pr #13416: [Perf/eager collection bulk extend](https://github.com/sqlalchemy/sqlalchemy/pull/13416) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `55` pr #12645: [enable mypy "ignore-without-code" rule](https://github.com/sqlalchemy/sqlalchemy/pull/12645) - PR blocked - identify whether block is CI, merge conflict, or review gate | |
| - `55` pr #10574: [fixes: #2943, allow overriding validates for inheritance](https://github.com/sqlalchemy/sqlalchemy/pull/10574) - PR blocked - identify whether block is CI, merge conflict, or review gate | |
| - `52` pr #13312: [test: add coverage for delete with nested alias exists](https://github.com/sqlalchemy/sqlalchemy/pull/13312) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| - `52` pr #13137: [Use _effective_decimal_return_scale in Numeric.result_processor](https://github.com/sqlalchemy/sqlalchemy/pull/13137) - waiting on repo owner test approval - approve or inspect the gated test run before asking the contributor for changes | |
| ## Issue Buckets | |
| - stale/low urgency: `157` | |
| - good volunteer slice: `36` | |
| - has linked PR: `16` | |
| - needs maintainer decision: `15` | |
| - high-priority/blocker: `4` | |
| - waiting on contributor: `3` | |
| ## PR Buckets | |
| - stale/low urgency: `21` | |
| - has linked issue: `18` | |
| - waiting on repo owner test approval: `12` | |
| - waiting on contributor: `11` | |
| - PR blocked: `7` | |
| - draft/noise: `3` | |
| ## Top Clusters | |
| - PR #13421 with linked issues: pr #13421, issue #13420. Review the issue and PR together instead of triaging both separately. | |
| - PR #13418 with linked issues: pr #13418, issue #9693. Review the issue and PR together instead of triaging both separately. | |
| - PR #13405 with linked issues: pr #13405, issue #13407. Review the issue and PR together instead of triaging both separately. | |
| - PR #13404 with linked issues: pr #13404, issue #13406. Review the issue and PR together instead of triaging both separately. | |
| - PR #13402 with linked issues: pr #13402, issue #10748. Review the issue and PR together instead of triaging both separately. | |
| - PR #13399 with linked issues: pr #13399, issue #13048. Review the issue and PR together instead of triaging both separately. | |
| - PR #13398 with linked issues: pr #13398, issue #13419. Review the issue and PR together instead of triaging both separately. | |
| - PR #13368 with linked issues: pr #13368, issue #11132. Review the issue and PR together instead of triaging both separately. | |
| - PR #13323 with linked issues: pr #13323, issue #8992. Review the issue and PR together instead of triaging both separately. | |
| - PR #13303 with linked issues: pr #13303, issue #13157. Review the issue and PR together instead of triaging both separately. | |
| - PR #13289 with linked issues: pr #13289, issue #13227. Review the issue and PR together instead of triaging both separately. | |
| - PR #13288 with linked issues: pr #13288, issue #13169. Review the issue and PR together instead of triaging both separately. | |
| - PR #13051 with linked issues: pr #13051, issue #13049. Review the issue and PR together instead of triaging both separately. | |
| - PR #12697 with linked issues: pr #12697, issue #9693. Review the issue and PR together instead of triaging both separately. | |
| - PR #12401 with linked issues: pr #12401, issue #12398. Review the issue and PR together instead of triaging both separately. | |
| - PR #12297 with linked issues: pr #12297, issue #11620. Review the issue and PR together instead of triaging both separately. | |
| - PR #11296 with linked issues: pr #11296, issue #11122. Review the issue and PR together instead of triaging both separately. | |
| - Possible related issues #10094 and #9410: issue #10094, issue #9410. Consider whether these can share one answer, close path, or implementation thread. | |
| - Possible related issues #12585 and #8795: issue #12585, issue #8795. Consider whether these can share one answer, close path, or implementation thread. | |
| ## Limits | |
| - This is an offline, read-only maintainer attention report. | |
| - It does not comment, label, close, merge, or submit anything on GitHub. | |
| - Public bundle exports are reduced rows and short excerpts; full raw API responses remain local unless explicitly approved. | |
| - Duplicate clusters are suggestions for maintainer review, not automatic close decisions. | |