Rails, a model based on a custom SQL query

Say I have a table that is a group of many base tables in my database.

I can implement a database view, so I can base the model on it, as I would with a normal "physical" table.
Is it possible to also specify the sql query of the view directly in the model, so without creating the view at all?