Use LIMIT to restrict rows from shards

Currently, `LIMIT` clauses are processed entirely on the head node. These should get pushed down where possible.

For example, with `SELECT * FROM members ORDER BY join_date LIMIT 25`, we ought to be able to push that `ORDER BY` and `LIMIT` down to each shard, return only 25 rows from each shard, then resort and limit them on the head.