SQL Queries
Workflow
- Clarify schema, keys, and required output columns.
- Start with correct baseline query.
- Add performance improvements (indexes, predicate pushdown, join strategy, window usage).
- Validate edge cases: nulls, duplicates, timezone/date handling.
- Provide explainability: why this shape, tradeoffs, and alternatives.
Output Standard
- Correct query.
- Dialect notes if non-portable.
- Optional optimized variant for large datasets.