Can I build complex queries for NOSQL DB?

select * from DB where
vara> x AND
varb = 2 AND
varc vard in (x,y,z) AND
vare like'%texthere%' AND
varf = 2 AND
varg = 3 and
etc...

I have been studying noSQL DB, and I have not been able to answer myself satisfactorily: Can complex queries be constructed on noSQL DB?

The type of query I want to know will be like this:

select * from DB where
vara> x AND
varb = 2 AND
varc vard in (x,y,z) AND
vare like'%texthere%' AND
varf = 2 AND
varg = 3 and
etc...

Note: I know I can’t use SQL. As mentioned above, I’m asking how to use the above psuedo logic to query, in other words It’s just a lot of different conditions. So far, the best answer I found is that you have an RDBMS query and then get the data from the cloud. For me, this is not necessarily more efficient.

So as a follow-up. If just trying to solve a problem of “searching 4 million rows” instead of the problem of “we have billions of data rows”, should I even look at a noSQL database?

In mongodb, you only need something like db.mytbl.find({“vara”:{$gt:10},”varb”:2, “Varc”:{$lt:100}})

See examples here and here