sql-queries

To write cross-dialect SQL queries, you must account for dialect-specific syntax differences. This Skill generates correct and performant SQL for Snowflake, BigQuery, PostgreSQL, Redshift, and Databricks by adapting syntax for CTEs, window functions, and aggregations.

Optimizing slow SQL queries involves restructuring logic for better performance. This Skill improves query performance by rewriting complex analytical logic using efficient CTEs, window functions, and dialect-specific optimizations across major data warehouse platforms.

Yes, dialect translation converts SQL queries between different database systems. This Skill translates queries between PostgreSQL, Databricks, Snowflake, BigQuery, and Redshift by adjusting syntax for functions, CTEs, and dialect-specific operations.

Calculating a rolling average requires SQL window functions like AVG OVER. This Skill constructs complex analytical queries using window functions to compute metrics such as a 7-day rolling average of daily active users in dialects like BigQuery.

Yes, cohort analysis is supported natively. This Skill solves problems related to building advanced analytical queries, including cohort analysis and complex aggregations, specifically tailoring the syntax for Redshift and other supported data warehouses.

CTEs improve query readability and maintainability over nested subqueries. This Skill constructs advanced analytical queries using CTEs and window functions to handle complex aggregations efficiently across Snowflake, BigQuery, PostgreSQL, Redshift, and Databricks.