Fetch all rows, just like DB-API cursor.fetchall().

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

Subsequent calls to _engine.ResultProxy.fetchall() will return an empty list. After the _engine.ResultProxy.close() method is called, the method will raise ResourceClosedError.

Returns:a list of RowProxy objects