I don’t realy understant your question… if you have seen the 3rd screencast… there you can see how to build that with Yii… and you already seen that it can be done…
Maybe you’re looking for a CSqlDataProvider? Data providers are interchangeable. So in the search() method of your model you can create any type of data provider you want and are not bound to CActiveDataProvider.