csharp/src/Client/AdbcDataReader: ability to get multiple result sets while executing multi-statement

For example, while executing multi-statement: “DROP TABLE IF EXISTS TESTTABLE;CREATE TABLE TESTTABLE(intcol INT);INSERT INTO TESTTABLE VALUES (123);INSERT INTO TESTTABLE VALUES (456);SELECT * FROM TESTTABLE WHERE INTCOL=123;SELECT * FROM TESTTABLE WHERE INTCOL=456;SELECT * FROM TESTTABLE WHERE INTCOL=456;DROP TABLE TESTTABLE;”
We can get a result in AdbcDataReader like this:
“Multiple statements executed successfully.”

Meanwhile, ADO.NET driver or ODBC driver able to get 2 result sets from 2 SELECT queries, like this:
INTCOL
123

INTCOL
456

This capability should be achieved via reader.NextResult() and reader.Read(), sample code as below:
do
{
while (reader.Read())
{
//read data into result set
}

yield return resultSet;
} while (reader.NextResult());