What types of queries is Molecula good at?

Complex WHERE clauses, counts, sorts, top-n, multi-field GROUP BY, JOIN, and any combination of these. It’s limitations include processing transactions and slower query times when accessing single records