Add method to update multiple pivot records at once

[Synchro]

At present, if you want to update multiple (typically all of them) non-id fields in pivot records, you need to do this:

$user = User::find(1);
 
foreach ($user->roles as $role) {
    $user->roles()->updateExistingPivot(
        $role->id,
        [
            'active' => false,
        ]
    );
}

This is inefficient as it issues a query for every record (a classic N+1). It would be nice to have a method that updates all pivot records in one go, something like this:

$user->roles()->updateExistingPivots(['active' => false,]);

Until then we can either live with the overhead, or resort to a manually constructed query.

[RTippin]

@Synchro I believe you could use newPivotQuery in the chain:

$user->roles()->newPivotQuery()->update(['active' => false]);