Comment by MarkusWinand
7 years ago
> What SQL lacks (in this case), but the relational model not, is the ability to nest relations as easily as JSON.
SQL has nested relations since SQL:2003[1] (called multisets). They are not widley supported and frankly speaking I don't like them.
JSON was finally added with SQL:2016[2].
[1] https://sigmodrecord.org/publications/sigmodRecord/0403/E.Ji...
[2] https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016#js...
No comments yet
Contribute on Hacker News ↗