nihilsen/laravel-join-using

Add support for the USING directive in join constraints for Laravel query builder

v0.1.0 2022-08-31 01:04 UTC

README

Latest Version on Packagist GitHub Tests Action Status GitHub Code Style Action Status Total Downloads

This package adds support for the USING directive in join constraints for Laravel query builder.

Installation

You can install the package via composer:

composer require nihilsen/laravel-join-using

Usage

use Illuminate\Support\Facades\DB;
use Nihilsen\LaravelJoinUsing\JoinUsingClause;

$query = DB::table('left_table')->rightJoin(
    'right_table',
    fn (JoinUsingClause $join) => $join->using('shared_column')
);

echo $query->toSql() // select * from "left_table" right join "right_table" using ("shared_column")

Credits

License

The MIT License (MIT). Please see License File for more information.