Model based in a query

Hi all.

Is there a way to build a model based in a query?

That would be the same as build a model in a view, but the fact is that,
in mysql, views are very limited, so, I would like to base a model in a
query, not in a table or view. Is there a way?