3 ms·
Writing more legible SQL
- creager 11y agoI'll admit to giving little thought to the legibility of my SQL - this is a quick read, with some solid tips. Do you do anything in particular to make your queries more digestible?
- ThatMightBePaul 11y agoCraig mentions this in the piece, but I'll second it: I fucking love CTE's for breaking apart ugly looking queries. They make everything significantly easy to read.
- craigkerstiens 11y agoYep, this is essentially the biggest piece. Using CTEs and having building blocks that are easy to logically follow is the single biggest thing you could do.