Yes, complex queries require a programmer who understands map/reduce. The degree of confidence corresponds pretty directly with the programmer's competence.

Is writing a function in javascript more or less difficult than writing a complex SQL query? I'd call it a tie at best.

So you have the upfront technical expense of setting up a relational schema which enables you to (maybe) save time later writing analytic queries.