[_Marak_]

I've had decent success so far with CouchDB 2.0 and Mango for performing ad hoc queries.

I believe Mango will automatically create the view index on the fly for any query you make and save the index for later. Before CouchDB 2.0 this would usually have to be done manually before the query was run.