How to Get the Raw Query String from Laravel's Query Builder Before Executing the Query

How can I get the raw query string from Laravel's query builder BEFORE executing the query?

You can get it doing:

$query = DB::table('brands')
                ->join('products','a','=','c')
                ->whereNull('whatever');

echo $query->toSql();

But Laravel will not show you parameters in your query, because they are bound after preparation of the query.

So you can also do:

print_r( $query->getBindings() );

How do I get the query builder to output its raw SQL query as a string?

To output to the screen the last queries ran you can use this:

\DB::enableQueryLog(); // Enable query log

// Your Eloquent query executed by using get()

dd(\DB::getQueryLog()); // Show results of log

I believe the most recent queries will be at the bottom of the array.

You will have something like that:

array(1) {
  [0]=>
  array(3) {
    ["query"]=>
    string(21) "select * from "users""
    ["bindings"]=>
    array(0) {
    }
    ["time"]=>
    string(4) "0.92"
  }
}

(Thanks to Joshua's comment below.)

How to get the raw SQL query from the Laravel Query Builder in laravel8.0

If you want to show all the queries, then you will have to enable the query log. DB::enableQueryLog

\DB::enableQueryLog(); // enable the query log before your modal

App\User::query()
    ->where('created_at', '<', now()->subYear())
    ->with('assignedApps', 'courses')
    ->orderBy('email', 'asc')
    ->limit(5)
    ->get();

dd(DB::getQueryLog()); // after your query, dump and die get query log.

It will return all queries result with values

Generate The Raw MySQL Query From Laravel Query Builder

use toSql() method of laravel to get the query to be executed like

App\User::where('balance','>',0)->where(...)->toSql();

But Laravel will not show you parameters in your query, because they are bound after preparation of the query. To get the bind parameters, use this

$query=App\User::where('balance','>',0)->where(...);
print_r($query->getBindings() );

enable the query log as DB::enableQueryLog() and then output to the screen the last queries ran you can use this,

dd(DB::getQueryLog());

raw query join left with select to laravel 8 query

there some sql chaining issue. @Ramiz Kongulov forget to split group by clause try this.

$buku = \DB::table('buku')
    ->select(['buku.*','kategory.*', 'tag.*'])
    ->leftJoin('kategori_buku', 'kategori_buku.id', '=', 'buku.id_kategori')
    ->leftJoin('detail_buku_tag', 'detail_buku_tag.id_buku', '=', 'buku.id')
    ->leftJoin(\DB::raw('(SELECT tag_buku.id, GROUP_CONCAT(tag) AS tag FROM tag_buku) AS tag_buku'),
        'tag_buku.id', '=', 'detail_buku_tag.id_tag')
    ->groupBy('buku.id')
    ->get();

Get Raw SQL of Insert Statement

I ended up discovering DB::pretend which will generate the query without running it. Then it's a case of substitution. It seems that there is no way to get the raw SQL without substitution due to the use of parameters.

Post::all()->each(function($post)
{
    $builder = DB::table('posts');

    $query = DB::pretend(function() use ($builder, $post)
    {
        return $builder->insert([
            'created_at' => $post->created_at,
            'title' => $post->title,
            'content' => $post->content,
            'featured_image_link' => $post->featured_image_link,
            'slug' => $post->slug
        ]);
    });
    
    $bindings = [];
    collect($query[0]['bindings'])->each(function($binding) use (&$bindings)
    {
        $binding = str_replace("'", "\\'", $binding);
        $bindings[] = "'$binding'";
    });

    $insertStatement = Str::replaceArray('?', $bindings, $query[0]['query']);

    Storage::disk('sql')->append('posts-latest.sql', $insertStatement.';');
});