Indeed, this is why the trend has been away from pure "nosql" solutions in the 2000s back to SQL-oriented systems.

And not just in transactional systems but also batch processing, e.g. why would I write mapreduce code if I can just use a system like Hive that gives me a nice SQL-based interface to my data?