sqlfmt▍
sqlfmt blog
Practical posts on writing cleaner SQL and fixing the errors your database gives back.
By Sharon Ben-Moshe · Oct 10, 2026
Understand SQLite's 64-bit rowid vs the AUTOINCREMENT keyword. Discover why AUTOINCREMENT adds performance overhead and when to use it.
Read postBy Sharon Ben-Moshe · Oct 9, 2026
Understand the difference between row-level GREATEST/LEAST and column aggregate MAX/MIN. Learn NULL behavior across PostgreSQL, MySQL, and SQL Server.
Read postBy Sharon Ben-Moshe · Oct 8, 2026
Learn how to use PostgreSQL generate_series() to build date spines, generate timestamp ranges, and create gap-free analytics reports.
Read postBy Sharon Ben-Moshe · Oct 7, 2026
Extract year, month, day, and hour across SQL dialects: ANSI EXTRACT, SQL Server DATEPART, MySQL date helpers, and SQLite strftime.
Read postBy Sharon Ben-Moshe · Oct 6, 2026
Understand CROSS APPLY and OUTER APPLY in SQL Server. Join table-valued functions, select top N rows per group, and unpivot JSON arrays.
Read postBy Sharon Ben-Moshe · Oct 5, 2026
Deep dive into SQL NULLIF(a, b). Learn how to convert empty strings to NULL, safeguard mathematical formulas, and pair NULLIF with COALESCE.
Read postBy Sharon Ben-Moshe · Oct 4, 2026
Compare string aggregation across databases: MySQL GROUP_CONCAT, PostgreSQL string_agg, SQL Server STRING_AGG, and SQLite group_concat.
Read postBy Sharon Ben-Moshe · Oct 3, 2026
Learn how to query, index, and update JSONB documents in PostgreSQL. Master ->, ->>, @> containment operators, and GIN indexes.
Read postBy Sharon Ben-Moshe · Oct 2, 2026
Master SQL LEAD() and LAG() window functions. Calculate month-over-month growth, compare sequential events, and supply default values without self-joins.
Read postBy Sharon Ben-Moshe · Oct 1, 2026
Compare RANK, DENSE_RANK, and ROW_NUMBER in SQL. See visual examples of how ties and numbering gaps behave across PostgreSQL, MySQL, and SQL Server.
Read post