duckdb-sql

Porting PostgreSQL queries to DuckDB requires adjusting integer division, date parsing, and interval syntax to avoid common dialect errors. This Skill guides query translation with clear examples to ensure accurate type casting and minimize manual debugging.

Date parsing fails in DuckDB due to specific interval syntax and truncation differences compared to MySQL. This Skill identifies these dialect gotchas and provides practical examples to correct date column casting during data modeling.

DuckDB SQL gotchas involve distinct window function behaviors and strict type casting requirements. This Skill highlights these specific quirks to resolve query development errors and ensure accurate ETL pipeline execution.

DuckDB handles integer division differently than PostgreSQL, which commonly causes unexpected query results. This Skill identifies these specific dialect differences and provides guidance to correct syntax for accurate ETL pipelines.

Resolving DuckDB interval syntax errors requires adjusting PostgreSQL or MySQL queries to match DuckDB-specific expectations. This Skill provides guided porting steps to fix date parsing and truncation issues across your ETL pipelines.