What's wrong with Views or CAs?

A simple REQUERY() or Cursorrefresh would do it.

Nothing. That works too but it is more difficult to implement if the where clause must change dynamically. Views are fine if the filter condition is always on the same field - that is "where somefield = somevalue". But is the where clause must change on the fly - "someother field = someother value" - it is a little easier to implement by using a cursor.