在rails中使用等效的数据库视图的最佳方法？

I have a working solution to this duct-taped together, but it relies on some pretty nasty queries that I'm afraid will make the application fairly brittle. Looking for advice on how to better implement the following.I have a working solution to this duct-taped to