>>All the data from the query of the view has to be loaded onto the client ...
(unless i am missing something here ?)

you can do parameterized views. But, remote views do not provide the level of abstraction that is really needed. Views are not objects. That's why ADO is so nice.