> not very amenable to query construction

I had a period of perferring MongoDB for this reason. Because the query is the bare AST in Mongo, dynamic query construction is simply manipulating some JSON.

Then I used jooq and never looked back.