I’ve got an existing database with an interesting permissions model. The permissions schema are based on a php library called Spatie Permissions. Long story short, I need to join my User’s roles through a model_has_roles table. model_has_roles is generic and allows any model in the system to have roles via a model_type field. For sake of brevity, what I’m trying to do is create an association for this query:

from r in Role,
  inner_join: mhr in "model_has_roles",
  on: mhr.role_id == r.id,
  where: mhr.model_id == ^user.id,
  where: mhr.model_type == "App\\User"

Unfortunately the docs say :where - A filter for the association. See "Filtering associations" below. It does not apply to :through associations.

Am I out of luck? Ultimately I just want track the roles / preload them right on the User model.