RAW query as include

[btxtiger]

How can I set a raw query as include?

I tried this test code, but could not get it working.

class TestInclude implements IncludeInterface {
   public function __invoke(Builder|\Illuminate\Database\Eloquent\Builder $query, string $include) {
      return \DB::table('variations')->whereId(3788);
   }
}

$this->addAllowedInclude(AllowedInclude::custom('test123', new TestInclude()));

[joaovdiasb]

You need to chain $builder, like $builder->join('variations', 'variations.id', 'related_table.foreign_id') to include that table