Using array has DataProvider

I need to use a custom sql query result has a provider for a CGridView, but since the CActiveDataProvider requires a valid model I’m currently not beeing able to do this, anyway I can make this work?I’ve created a CActiveDataProvider with a valid and tried to do a setData on the provider, but I need more fields then the valid model gives me.

I hope I explained this correctly :D, any ideas on how to work around this?

i think create a Model with desired attributes (columns) is an option

I’ve thought of that but won’t Yii process the model and check for it table?And then crash out since I don’t have that table, I could create it but I was wondering if there wasn’t a “cleaner” way of doing this

you could use an extension:

I’ll check it out then, thanks.