Currently it's not possible to re-use a RecordSet after resetting the attached Statement.
While RecordSet has an assignment operator for Statement, assigning a new statement does not reset the RecordSet internal state. Furthermore, RecordSet lacks an assignment operator to assign another RecordSet.
Maybe RecordSet should have a reset() method like Statement.