Does Ash support a Relationship through another Resource that isn't many_to_many?

Questions & Help Questions
,
1

Exams have Sections sections have Passages and Passages have Questions

I want to be able to say, “Give me all the questions in a Section” but I don’t want Sections to have Questions and Question to belong to Section because it introduces the opportunity for bad state.

Is there a way to define a Relationship that goes through an intermediate Resource that isn’t many to many?

2

At some point, has_many_through and has_one_through will be added to the core, but until the you will need to use manual relationships. Check out the docs here for making joinable manual relationships: AshPostgres.ManualRelationship — ash_postgres v2.10.0

3

This helps as well: https://ash-hq.org/docs/guides/ash/latest/how_to/defining-manual-relationships