Sometime, I can make can use Eloquent for complex login in laravel. So, i need run a big raw query. How to do that? Example: i need run
Insert Into ..............
Select..............
Join....
Join....
Where...............
...............................................................
May be you're finding for this solution. you can using it for resolve your problem.
$yourComplexQuery = "
Insert Into ..............
Select..............
Join....
Join....
Where...............
...............................................................
";
DB::select($yourComplexQuery);
You can use the DB Facade, in addition you could use its raw methods.
DB::table('tableName')->selectRaw()...
https://laravel.com/docs/master/queries#raw-expressions
If this is not raw enough for you, you can simply define your sql query:
$query = "Insert Into ..............
Select..............
Join....
Join....
Where...............
................... ";
and insert it into the DB::select($query);
DB::insert("
insert into table1 (column1, column2, column3)
select columnA, columnB, columnC
from table2
join table3 on table2.id = table3.table2_id
join table4 on table3.id = table4.table3_id
where table4.columnX = ?", [$value]);
