Yep, I'm a big fan of building views in postgres and just hitting those with the ORM. I don't even use the join syntax in my ORM (Ecto) - if I need a join, I use a view.
Interesting. Does Ecto have any syntax that supports this behavior? Or do you just use raw SQL for this?
You just treat a view the same way as a table with Ecto.