Re:We Can Do Better Than SQL
by achr2 on Tuesday August 11, 2020 @01:18PM
(#24122860)
I agree that the mismatch is not a direct failing of SQL or the relational model - but we continue to use it without adopting a better approach or developing a common abstraction layer. With all of the syntax growth, SQL could certainly have a join syntax that understands object composition and returns structured data.
[ Parent
| on HN ]
> With all of the syntax growth, SQL could certainly have a join syntax that understands object composition and returns structured data.
I mean, many RDBMS's have support for JSON and/or XML, so you can sort of get it.
However, I wonder if we'd be better of as an industry if we dealt with our data in code in a more relation-y way than an object-y way.