Jeff Cogswell compares some short code samples in an attempt to answer the much bigger question:
But what about the programmers, who write the client code that access the databases? Where do the disagreements leave them? From a programming perspective, is SQL really that horrible and outdated? Or is the new NoSQL really that awful to work with? Perhaps they both have strengths and good points.
it would have been impossible to compare the APIs of all relevant NoSQL databases with a relational database;
it would have been very difficult to choose a generic, representative enough use case;
the results would have always been heavily influenced by the quality of drivers and libraries used.
Last but not least, many of the merits of the NoSQL databases are related to operational complexity and not programming complexity. As someone that did a fare amount of coding and close to zero operations, I would probably feel OK accepting a bit of programming complexity for simplified operations. But that might be just a biased opinion.