You have DB::table()->upsert() and DB::table()->insertUsing, why do you not have DB::table()->upsertUsing?

[ParleyHammon]

I built my own upsertUsing function using your guy's code from DB::table()->upsert() and DB::table()->insertUsing because it's so useful to me.

Why does passing a subquery require a special function anyways? I should be able to pass a subquery anywhere I can pass in an expression for the most part

class ExtendedQueryBuilder extends Builder
{
    /**
     * upsert new records into the table using a subquery.
     *
     * @param array $columns
     * @param \Closure|Builder|\Illuminate\Database\Eloquent\Builder|string $query
     * @param array|null $update - defaults to $columns
     * @return int
     */
    public function upsertUsing(array $columns, $query, array|null $update=null): int
    {
        if(!$update) $update = $columns;
        $this->applyBeforeQueryCallbacks();

        [$sql, $bindings] = $this->createSub($query);

        return $this->connection->affectingStatement(
            $this->grammar->compileUpsertUsing($this, $columns, $sql, $update),
            $this->cleanBindings($bindings)
        );
    }
}

class ExtendedMySqlGrammar extends MySqlGrammar
{
    /**
     * Compile an insert statement using a subquery into SQL.
     *
     * @param  ExtendedQueryBuilder  $query
     * @param  array  $columns
     * @param  string  $sql
     * @param  array  $update
     * @return string
     */
    public function compileUpsertUsing(ExtendedQueryBuilder $query, array $columns, string $sql, array $update): string
    {
        $useUpsertAlias = $query->connection->getConfig('use_upsert_alias');

        $sql = $this->compileInsertUsing($query, $columns, $sql);

        if ($useUpsertAlias) {
            $sql .= ' as laravel_upsert_alias';
        }

        $sql .= ' on duplicate key update ';

        $columns = collect($update)->map(function ($value, $key) use ($useUpsertAlias) {
            if (! is_numeric($key)) {
                return $this->wrap($key).' = '.$this->parameter($value);
            }

            return $useUpsertAlias
                ? $this->wrap($value).' = '.$this->wrap('laravel_upsert_alias').'.'.$this->wrap($value)
                : $this->wrap($value).' = values('.$this->wrap($value).')';
        })->implode(', ');

        return $sql.$columns;
    }
}

[jeff1326]

There's a wip here : https://github.com/laravel/framework/pull/50305/files