Ecto: how to join three tables?

Hey,

I found your answer that seems relevant to my question here: From many to one to many to many with data on the join table

I am looking at a similar setup.
When you would want to show the user their teams, how do you go about that? Do you not miss having user.user_team_role.role and subsequently user.user_team_role.team?

Thanks