this post was submitted on 27 Dec 2023
544 points (96.7% liked)
Programmer Humor
19623 readers
2 users here now
Welcome to Programmer Humor!
This is a place where you can post jokes, memes, humor, etc. related to programming!
For sharing awful code theres also Programming Horror.
Rules
- Keep content in english
- No advertisements
- Posts must be related to programming or programmer topics
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
if you don't believe that adding more structure to the absolute maniacal catastrophe that is sql is a good thing then i'm going to start to have doubts about your authenticity as a human being
Me trying to remember on whose output data
having
,count
,sum
, etc. workOnce you know functions you would have no reason to go back.
I propose we make SQL into this:
(Sorry for any glaring mistakes, I'm too lazy right now to know what I'm doing)
..and I bet I just reinvented the wheel, maybe some JavaScript ORM?
Well, if you lose the OOPism of those dots, we can talk.
Anyway, I'm really against the "having" tag. You need another keyword so that you can apply your filter after the group by?
Boy then are you going to hate
QUALIFY
Yes, I do. It's a lot of effort and hidden functionality to try to paper over the fact that the statements do not compose.