Re:I don't need your query language
by mabbo on Saturday June 17, 2023 @08:10AM
(#36369537)
I agree with you and think this backwards model leads to developers having a poor mental model of what they are doing.
Step 1: build the dataset you want (FROM and JOIN) with all columns.
Step 2: filter out the rows you don't want (WHERE).
Step 3: choose which columns/values you want (SELECT).
Maybe it's just me but this model makes so much more sense to me! I'm sure but every developer has the same way of thinking, but it sure does seem more logical to me.
Step 1: build the dataset you want (FROM and JOIN) with all columns.
Step 2: filter out the rows you don't want (WHERE).
Step 3: choose which columns/values you want (SELECT).
Maybe it's just me but this model makes so much more sense to me! I'm sure but every developer has the same way of thinking, but it sure does seem more logical to me.