If you need to write a lot of joins to get information from your database you may consider creating a materialized view. You can think of database views as a kind of API or public methods. You get a consistent way of accessing your records. The view remains the same while the source tables may change.

Materialized Views In Ruby On Rails With Scenic