Re:Ask HN: Does anyone else think SQL needs help?
by grvdrm on Monday September 12, 2022 @08:49AM
(#32809347)
The recursive stuff is pretty cool. In general, I like CTEs a way to break queries into pieces to improve readability and understanding (among other improvements).
Also, integrating aggregate functions along with row_number() and similar functions to perform more complex work with less code.
> Fundamentally, SQL lacks meaningful abstraction
My RDBMS course at college was really hardcore and SQL code answers for exam questions were enormous.
One neat trick they didn't teach us, but still perfectly legal SQL:1999, is to use WITH recursive constructs.
This way you can decompose very complex queries into simple ones, that can tested independently.