Join across multiple junction tables with Sequelize-open source projects sequelize/sequelize

I have a database with three primary tables: “users“, “teams“, and “folders” joined by two junction tables, “users_teams” and “teams_folders“. There is a many-to-many relationship between users and teams and between teams and folders (a user can be on more than one team and teams can own more than one folder).

Sequelize does a wonderful job of managing the user-teams and teams-folder relationship, but I can find no way to establish a relationship between users and folders.

Is there any way to join across two junction tables without resorting to raw SQL?

There seems to be no way to accomplish this elegantly or in a reasonable number of steps. I have tried methods like user.getFolders(), Folder.findAll({ include: [User] }), but Sequelize doesn’t seem to be able to understand a three level hierarchy.