What types of queries is FeatureBase good at?

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