If connected to a server that doesn't support agg cursors, fallback to non-cursor form and return a simulated cursor.

Most of the work here will involve updating the tests to work with the new API.