Add a Detach method for RecordSet to detach a record set from the session context

[YangKeao]

Enhancement

To achieve the lazy cursor fetch functionality, we'll need to detach the executor -> recordSet -> resultSet from the session context. The PR to add Detach method for executor is WIP #53336. At the same time, we can add a method for recordSet to detach the content of it from the session context.

We need to carefully handle the following things:

1. *ExecStmt, which will be used to upload the statistical information after executing the statement.
2. *execStmtResult, which will auto-commit the transaction after executing the statement.

For this issue, we'll create a simple RecordSet, to run read-only statement without statistical information and not allow running in an explicit transaction.