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

Question

I have a complex query created by a few conditions, and I would like to get the final SQL query from the builder object is about to execute. Can I do that?

Answer 1

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

Answer 2

For debugging this might come quite handy as it returns the SQL with the bindings, so you can instantly put it into the database console.

/**  * Combines SQL and its bindings  *  * @param \Eloquent $query  * @return string  */ public static function getEloquentSqlWithBindings($query) {     return vsprintf(str_replace('?', '%s', $query->toSql()), collect($query->getBindings())->map(function ($binding) {         return is_numeric($binding) ? $binding : "'{$binding}'";     })->toArray()); }