4 ms·
I once read an article about SQL and how reordering the sections of a query would make it more ergonomic for users (iirc things like specifying what you want fi
by thomas536 4y ago
I once read an article about SQL and how reordering the sections of a query would make it more ergonomic for users (iirc things like specifying what you want first and then how to present it last, more like a pipeline). I searched many times over the years but have not been able to find it again.
- colinmcd 4y agoPerhaps this one? https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/ https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with...
- thomas536 4y agoPerhaps? I remember the article arguing more comprehensively why a different order would be beneficial, but maybe I am just misremembering