SQL Formatting Best Practices for Readable Code

Well-formatted SQL is easier to read, debug, and maintain. Here are the best practices for formatting your SQL queries.

Key Formatting Rules

• Use UPPERCASE for SQL keywords
• Put each major clause on a new line
• Indent subqueries and conditions
• Align column names in SELECT statements
• Use meaningful table aliases

SELECT 
    u.id,
    u.name,
    COUNT(o.id) AS order_count
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.active = true
GROUP BY u.id, u.name
ORDER BY order_count DESC;