CouchDB doesn't support ad hoc queries. CouchDB is all about MapReduce and heavy caching. It's very rigid.
The ability to adjust consistency isn't really a new concept. The first I saw it was in Amazon's DynamoDB paper in 2007. Cassandra uses the model outlined there as well, and I'm sure there are others out there that I'm less familiar with.
similar to cloudantdb a little bit more because of searching and indexing.