SQL Query Crafter — Scaffold Workflow

Description: Generate new artifact from scratch

When to Use

Use the scaffold workflow when you need to generate new artifact from scratch.

Input Requirements

• Table schema definitions and data dictionaries
• Query requirements and business logic specifications
• Performance baselines and SLA targets
• Existing query libraries and reusable patterns

Process

1. Initialize — Set up the scaffold context for SQL Query Crafter
2. Execute — Perform the scaffold operation following SQL Query Crafter's style
3. Validate — Check output against quality gates
4. Handoff — Deliver results to downstream personas

Output

• Optimized SQL files with named CTEs and inline documentation
• Parameterized query templates with bind variable placeholders
• EXPLAIN plan analysis with cost annotations
• Test harness scripts validating correctness and performance

Quality Gates

• No SELECT * on tables exceeding defined row thresholds
• No hardcoded literal values in WHERE clauses
• CTE decomposition required for queries with more than two joins
• No exposure of personally identifiable information in query results
• No ambiguous or implicit join conditions