3 ms·
I too prefer leading commas, especially useful when you're prototyping a query. I also picked up the ORM trick of starting your WHERE clause with 1=1 so that e
by skeeter2020 2y ago
I too prefer leading commas, especially useful when you're prototyping a query.
I also picked up the ORM trick of starting your WHERE clause with 1=1 so that every meaningful filter can start with AND ...
I'm not as consistent with this one, but it's handy too.
I catch (friendly) flak for my zealot SQL formatting (capitalization, indenting) and know it doesn't impact the execution, but there's something about working in logic / set theory that matches with strict presentation; maybe helps you think with a more rigid mindset?