(2) There are many databases with other query languages that support joins, just a few are
https://www.arangodb.com/ https://www.w3.org/TR/sparql11-query/ https://docs.couchbase.com/dotnet-sdk/current/howtos/n1ql-qu... https://neo4j.com/developer/cypher/
all of the above support some combination of document and graph models. All of them can be used in a way very similar to a SQL database. For instance you can stuff arangodb with 'flat' JSON documents that work like tables and also create RDF graphs structured like a relational database and write SPARQL queries.
In fact there is a close mathematical relation between SQL and SPARQL and those other query languages. For instance it is possible to write a schema that maps a set of relational databases to an RDF graph, then compile a SPARQL query into a process that runs SQL queries on multiple databases. Better than that the system can rewrite the SQL queries to implement powerful and efficient inference
https://www.obitko.com/tutorials/ontologies-semantic-web/owl...
The Department of Defense tried this technology to answer the question of "Where does all the money go?" It didn't fail because the math didn't work or the tools sucked but more because of the intrinsic complexity of the problem and politics.