SQL style guide

Overview

This document defines rules for writing readable, maintainable SQL queries following ANSI SQL conventions with project-specific formatting standards.

Key Principle: Use ANSI SQL, lowercase keywords, leading commas, and right-aligned clauses. Optimize for clarity over brevity.

General principles

• Use ANSI SQL as default -- avoid vendor-specific syntax unless necessary
• Use lowercase for all SQL keywords and identifiers
• Follow the conventions of the target database (MySQL, Oracle, etc.)
• Write readable, maintainable queries
• Optimize for clarity over brevity

Formatting rules

Keyword alignment