Fetch many rows, just like DB-API cursor.fetchmany(size=cursor.arraysize).

After all rows have been exhausted, the underlying DBAPI cursor resource is released, and the object may be safely discarded.

Calls to _engine.ResultProxy.fetchmany() after all rows have been exhausted will return an empty list. After the _engine.ResultProxy.close() method is called, the method will raise ResourceClosedError.

Returns:a list of RowProxy objects