title: Is it possible to construct complex queries against noSQL DB
body: <p>I have been researching noSQL DB and have not been able to satisfactorily answer this for myself:  Is it possible to construct complex queries against noSQL DB?</p>
  
  <p>The type of query I'm wondering about would be something like this:</p>
  
  <pre><code>select * from DB where
  vara &gt; x AND
  varb = 2 AND
  varc &lt; x AND
  vard in (x,y,z) AND
  vare like '%texthere%' AND
  varf = 2 AND
  varg = 3 and
  etc...
  </code></pre>
  
  <p>NOTE:  I'm aware that I can't use SQL, as above, what I'm asking is how would I query using the psuedo logic above, in other words a whole bunch of different conditions.  So far the best answer I have found is that you have an RDBMS to query and then grab data based on key from cloud.  That doesn't necessarily seem more efficient to me.</p>
  
  <p>So as a follow up.  If just trying to solve a 'search 4 million rows' problem as opposed to a 'we have billions of rows of data' problem, should I even bother looking at a noSQL DB?</p>