What problem does it solve?
This Skill addresses the complexity of optimizing and executing SQL queries within the Cascades query planner and optimizer, ensuring high-quality code and alignment with the Java reference implementation.
Core Features & Use Cases
- Architectural Review: Ensures changes align with the Cascades framework and Java reference.
- Code Quality: Reviews for dead code, logic holes, and incomplete conversions.
- Determinism Checks: Ensures non-deterministic tests pass for consistent results.
- Review Workflow: Requires approval from both architectural and code quality reviewers.
- Use Case: When developing a new SQL query optimization rule, this Skill guides the process from initial implementation to final review and deployment.
Quick Start
Start by reading the Java source code for the corresponding SQL component. Implement the new rule with tests, then submit for review by both reviewers.