SQL Options

SQL schema design patterns for migrations, normalization, and multi-tenant data modeling

SQL error handling patterns using transactions, savepoints, and exception blocks

Specific best practices and architectural patterns when working with DuckDB.

PostgreSQL-specific SQL conventions for advanced features, extensions, and dialect idioms

Specific best practices and architectural patterns when working with dbt.

SQLFluff linting and formatting conventions for consistent SQL style across dialects

SQL query performance optimization using indexes, EXPLAIN ANALYZE, and join strategies

SQL security practices for injection prevention, privilege separation, and data protection

Core SQL coding conventions covering formatting, naming, and query structure

SQL testing conventions using pgTAP, dbt tests, and query result validation