How to load relationship of pivotModel

[dschreij]

I am trying to figure out a way to load a relationship that is defined on a pivotModel. Let's say I have the following models:

class Job extends Model {
  participants () {
    return this
      .belongsToMany('App/Models/Participant')
      .pivotModel('App/Models/JobState')
      .withPivot(['data', 'status_id'])
  }
}

class Participant extends Model {
  jobs () {
    return this
      .belongsToMany('App/Models/Job')
      .pivotModel('App/Models/JobState')
      .withPivot(['data', 'status_id'])
  }
}

class JobState extends Model {
  job () {
    return this.belongsTo('App/Models/Job')
  }

  participant () {
    return this.belongsTo('App/Models/Participant')
  }

  status () {
    return this.belongsTo('App/Models/JobStatus', 'status_id')
  }
}

class JobStatus extends Model {
  jobStates () {
    return this.hasMany('App/Models/JobState')
  }
}

How can I indicate that the status relationship of JobState also needs to be loaded? I have found a way by doing something like

const job = Participant.jobs().first()
const job.$relations.pivot.state = job.$relations.pivot.status().first()

but for many jobs, this type of lazy loading doesn't seem to be very scalable. Is it also possible to eager load relationships on the pivot model with the with() function for instance?

EDIT
I also tried to get the status using an inner join, but since my custom join occurs after the join of the pivot table to the Job table, the variable job_states.status_id cannot yet be resolved:

const participant = await Participant.query()
      .where('identifier', identifier)
      .with('jobs', (query) => {
        query
          .where('study_id', studyID)
          .orderBy('position', 'asc')
          .with('variables.dtype')
          .innerJoin('job_statuses', 'job_states.status_id', 'job_statuses.id')
      })
      .firstOrFail()

so sadly, this approach is not possible