[dekhn]

SQL was designed and created to elegantly express queries that exploit relational algebra. It's hard to express that in other ways because general programming languages have properties that get in the way of the query engine.

You are also confusing SQL the language and relational databases versus non-relational databases (some of which are called nosql). This issue is mainly due to some odd naming choices when "nosql" was created.

SQL doesn't have ACID- you are conflating properties of relational databases with the standard language used to interact with relational databases.

If you want to use nosql document store, go ahead, but you don't need to complain about SQL when you do.