Let's document these cases we're not currently handling. Is the limit one where the outer limit is less than the inner limit? Can we handle that?

The second case is an aggregate over a aggregate? We can't handle that, but it wouldn't be too difficult (if we do it client side in-memory).