>Does anyone know if the new SQL engine has finally put an end to the possibility of ever providing a filtered "view" (for lack of a better term) as a result set?

Only if you use NOFILTER or READWRITE clauses. Which means that nothing changed in that respect in VFP8.