Honestly more readable than a lot of SQL I've read. It even has hierarchical grouping.
this post was submitted on 27 Dec 2023
6 points (100.0% liked)
Programmer Humor
19154 readers
2012 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
I was disgusted by the XML at first, but it's a readable query returning a sane JSON object.
Meanwhile, I'm mantaining Java code where the SQL is a perfectly square wall of text, and some insane mofo decided the way to read the resulting list of Object[] ๐คฎ is getting each column by index... so I'd switch to SQXMLL in a heartbeat.
Check out JOOQ.
JOOQ made me realize that most ORMs suck
I kind of like it. I can understand where it start and end.
Honestly not the worst thing Iโve seen.
I'd like you to think for a moment about CTEs, the HAVING clause, window functions and every other funky and useful thing you can do in SQL ... Now just think, do you think that this syntax supports all those correctly?
sql syntax doesn't support even itself correctly i fail to see your point