4 ms·
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
by achr2 6y ago
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.
- wtetzner 6y ago> 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.