review-sql

Review SQL and query-related code for language and query conventions only. Cover injection and parameterization, indexing and execution-plan concerns, transactions and isolation, NULL and unique constraints, dialect portability, large-table and paging patterns, and sensitive columns and permissions. Emit a findings list in the standard format for aggregation. Do not define scope or perform full security/architectu...

When to use: When the code under review includes SQL (raw .sql, embedded in code, or ORM-generated). Scope (diff vs paths) is determined by the caller or user.

| Location | path/to/file.ext (optional line or range) or query identifier. | | Category | language-sql. | | Severity | critical \| major \| minor \| suggestion. | | Title | Short one-line summary. | | Description | 1–3 sentences. | | Suggestion | Concrete fix or improvement (optional). |