for most 'application' like workloads not analytics - standardizing or improving on mongo-query language (MQL) would be welcome.
the drawback is your query patterns have to be known before hand when designing your application. which isn't really a drawback since you're doing it before building the application. & hence not as flexible as SQL.