how to work on database view

Just treat it as if it was a table. ActiveRecord won't be able to tell the difference.