SQL GitHub Copilot Instructions

- Generate parameterized queries; never interpolate user input into SQL
- Apply window functions (ROW_NUMBER, RANK, LAG, LEAD) for analytical queries
- Generate indexes for all JOIN and WHERE conditions in generated queries
- Use CTEs with descriptive names for multi-step analytical queries
- Generate idempotent migrations with IF NOT EXISTS guards
- Apply proper transaction boundaries for multi-statement mutations
- Use EXPLAIN or EXPLAIN ANALYZE to comment on query performance expectations
- Generate soft delete columns (deleted_at TIMESTAMPTZ) instead of hard deletes