News for hackers. Stuff that matters.

A comment on Relational is more than SQL. Parent comment

Re:Relational is more than SQL by ako on Sunday September 17, 2023 @12:10PM (#37546578)
How are views not first class query objects?
[ Parent | on HN ]
Re:Relational is more than SQL by ttfkam on Monday September 18, 2023 @08:18PM (#37564103)
Yup.

"SQL doesn't have first-class query objects and isn't composable."

Uh… views, set-returning functions, temporary tables, CTEs…

"No, not like that! Something not declarative and set-oriented!"

SQL is declarative and set-oriented. 3rd generation language models for data were tried and discarded for good reason decades ago.

"But… but… I don't like set-oriented models! They make me feel dumb. I'm not dumb, so SQL must be dumb. Not meeeeeeeee!!!"

[ Parent | on HN ]