That guy has no clue how to use a non-relational DB (he even admits it) and he uses a DB that is wrong for his task and wonders why it's so hard.
The only point he makes is that the APIs for non-relational DBs are much too simple and limited, so you end up building lots of code on top to do the most trivial things.
What we really need is a way to generate indexes or materialized views on these DBs in a standardized way (see CouchDB, for an example).