Iteration syntax for UncommonSQL

Hi!

(I'm currently using UncommonSQL because I only have a license for LW
professional but I'm sending a copy to the LW mailing list because I
guess the answer is indepent of whether it's "Uncommon" or "Common".)

I'm using the OO interface to UncommonSQL and have created a view
class USER which maps to a database table USERS. Everything works fine
except for the fact that, in order to loop through all elements of the
database, I resort to things like

  (dolist (user (sql:select 'user))
    ..)

which conses up a list that I don't actually need (and which might be
large).

I'm aware of the iteration constructs described in
<http://www.lispworks.com/reference/sql-tutorial/index.html#section-4.3>
but I couldn't figure out how to use them with view classes.

Is there something that I'm missing?

Thanks,
Edi.