3 ms·
Nice changes, I like it! I will say I really like aligning the join clauses, but I'll try writing things this way for a little while and see if it sticks.
by extr 5y ago
Nice changes, I like it! I will say I really like aligning the join clauses, but I'll try writing things this way for a little while and see if it sticks.
- janto 5y agoThe only thing I require from an SQL formatter is to make typos and boolean mistakes super easy to spot, especially as it grows in size. At first glance it might seem strange, but I like indentation on even the first term of an AND. SELECT a, b, count(*) as count FROM table JOIN table2 ON table.key1 = table2.key1 AND table.key2 = table2.key2 AND -- 1 day apart DATEADD('day', 1, table.key3) = table2.key3 WHERE cond1 AND cond2 AND ( cond3 OR cond4 ) GROUP BY (a, b) ORDER BY count desc, a asc LIMIT 1000 ; Yes, that's a lot of whitespace, but it helps for complex queries.
- marcosdumay 5y agoWell, there's an inherent conflict between making individual queries easier to read and making your entire code easier to read. How much whitespace you need is completely dependent on what exactly you are writing.