sql-generation

This Skill generates BigQuery SQL statements adhering to BTDP standards, enforcing uppercase keywords, explicit JOINs, no SELECT *, and dynamic date handling. It guides you through scenario selection—ad-hoc analysis, materialized views, or data preparation—then applies optimization via CTEs and discovery workflows to produce standards-compliant queries.

BTDP BigQuery SQL requires uppercase keywords, explicit JOIN syntax, no SELECT *, and dynamic date patterns for rolling windows. This Skill enforces these rules across all query types, ensuring consistency and maintainability in production workloads.

CTEs structure complex queries into readable, reusable blocks; discovery workflows help identify tables and schemas before writing. This Skill combines both techniques to optimize query performance and clarity, particularly for MERGE-based data preparation and materialized-view scenarios.

Yes. This Skill covers all three: ad-hoc analysis with dynamic queries, MERGE-based data preparation with staged transformations, and materialized-view workloads. Each scenario includes specific patterns and coding rules tailored to BTDP BigQuery environments.

Explicit column selection improves performance, readability, and maintainability by avoiding unexpected schema changes and reducing data transfer. This Skill enforces explicit selection as a mandatory rule, replacing SELECT * across all query patterns.

Dynamic date handling uses parameterized date expressions rather than hardcoded values, enabling rolling windows and time-based aggregations. This Skill provides time-based patterns and implementation guidance for common scenarios like daily, weekly, and monthly rollups.