Joins are in SQL because SQL was developed to query relational databases, and the join is the fundamental assumption of the relational database.
I always find it sad that the new data storage engines define themselves under a banner that says "We don't care that everybody who learned how to query a database since 1988 needs to learn a new way because our way is better."
Which wouldn't be so bad if it was uniform across engines, but it isn't. It's a new API for each engine.
That's a lot of yaks to shave when you already know SQL.
I always find it sad that the new data storage engines define themselves under a banner that says "We don't care that everybody who learned how to query a database since 1988 needs to learn a new way because our way is better." Which wouldn't be so bad if it was uniform across engines, but it isn't. It's a new API for each engine.
That's a lot of yaks to shave when you already know SQL.