I had this code to select the memberships that are assigned to a parent item. This works great
from( ebam in query, join: bam in assoc(ebam, :business_account_membership), select: bam )
now i want to do this because the memberships got some options
from( ebam in query, join: bam in assoc(ebam, :business_account_membership), join: bamo in assoc(bam, :options), select: bam )
how could i select the bam here with the options field loaded in from the join? or somehow preload in the join?
I can’t use normal preload because i can’t select a virtual field.
Of course i could just preload the whole in one and then map it out, but this would be lovely.