I have a disconnected ADO Recordset object in memory. I'd like to run a query against it ~ as in, I want to use an SQL statement to select specific data from it. I was thinking maybe using clone, but I'm not sure how to include the SQL statement.

I'd like to do "Select DISTINCT", and "GROUP BY" operations (not merely filter).

Do I have to do something silly like pass it to XML first?