Why unformatted one-line SQL hides bugs and how a formatter helps

A reviewer once spent twenty minutes checking a 412-character single-line SQL migration, which hid a missing WHERE condition that was easy to overlook. The author explains that a SQL formatter improves readability by placing each clause on its own line and indenting related parts, without changing what the query does. Because SQL varies across databases such as MySQL, PostgreSQL, and SQL Server, a good formatter must know the dialect to avoid breaking valid syntax. The piece also notes that minifying queries suits machine transport, while formatting suits human reading, and that minifiers should preserve comments and string literals. Finally, it warns that formatters should run locally in the browser so production SQL is not uploaded to a server.