sqlfmt▍
sqlfmt blog
Practical posts on writing cleaner SQL and fixing the errors your database gives back.
By Sharon Ben-Moshe · Oct 12, 2026
Format complex parentheses and boolean logic in SQL WHERE clauses. Prevent AND/OR operator precedence bugs with clear visual indentation.
Read postBy Sharon Ben-Moshe · Oct 12, 2026
Format ALTER TABLE DDL statements for clean database migrations. Learn conventions for adding columns, foreign keys, defaults, and multi-action blocks.
Read postBy Sharon Ben-Moshe · Oct 12, 2026
Master formatting standards for the SQL HAVING clause. Learn how to format aggregate filters, multiple AND/OR conditions, and alignment with GROUP BY.
Read postBy Sharon Ben-Moshe · Oct 12, 2026
Format SQL MERGE statements for readability in SQL Server, Oracle, and BigQuery. Align MATCHED and NOT MATCHED clauses with clean indentation.
Read postBy Sharon Ben-Moshe · Oct 12, 2026
Format SQL triggers across PostgreSQL, MySQL, and SQL Server. Master BEFORE vs AFTER events, FOR EACH ROW logic, and clean trigger function layout.
Read postBy Sharon Ben-Moshe · Oct 12, 2026
Resolve the indentation debate in SQL. Compare 2 spaces, 4 spaces, and tabs. Learn clause alignment styles and subquery indentation depth.
Read postBy Sharon Ben-Moshe · Oct 12, 2026
Format CREATE INDEX statements cleanly. Learn conventions for composite indexes, partial/filtered indexes, INCLUDE covering columns, and concurrent builds.
Read postBy Sharon Ben-Moshe · Oct 12, 2026
Discover best practices for writing clean SQL comments. Master single-line (--) dashes, block (/* */) comments, header blocks, and inline explanations.
Read postBy Sharon Ben-Moshe · Oct 12, 2026
Learn how to format CREATE VIEW statements for long-term maintainability. Master explicit column lists, CTE encapsulation, and schema qualification.
Read postBy Sharon Ben-Moshe · Oct 11, 2026
Understand Google BigQuery's nested STRUCT and repeated ARRAY data types. Learn how to query, construct, and flatten complex nested schemas.
Read post