Yeah, I have. It's pretty nice - and very easy.
Run a regular database query, e.g.:
<cfquery name="myQuery" datasource="#ds#">
SELECT fname, email FROM people
WHERE gorgons = 3
</cfquery>
Then you can treat the resulting recordset just
like a data table in a later query...