How to run normal query in Laravel 7, not using Eloquent

Question

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...............
       ...............................................................

Does this answer your question? [How to execute raw queries with Laravel 5.1?](https://stackoverflow.com/questions/33049511/how-to-execute-raw-queries-with-laravel-5-1) — Egretos, Jul 31 '20 at 11:42

Thanh Nguyen · Accepted Answer · 2020-07-31T08:47:04.263

3

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);

edited Jul 31 '20 at 08:47

answered Jul 31 '20 at 08:40

Thanh Nguyen

350
3
6

Aless55 · Answer 2 · 2020-07-31T08:50:17.573

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);

How to run normal query in Laravel 7, not using Eloquent

2 Answers2