>>>Thank you, Yuri. What is not clear (and maybe I am missing something) is how do you specify an alias name that will be assigned to the returned query?
>>
>>You're not getting a cursor this way. You're getting a recordset.
>
>I suppose there is a way then to convert this recordset to a cursor, right?
>
>UPDATE. I think to convert a recordset to a cursor I would need to use a CursorAdapter. So I am back where I started :(.

If I remember it correctly, one can also use 'vfpcom:
o = CreateObject('vfpcom.comutil')
ors=CreateObject("adodb.recordset")
.....
? o.RSToCursor(oRs, 'cursorname')

Not to mention you can scan recordset and process it record by record.