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

Question

Given the following code:

DB::table('users')->get(); 

I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be SELECT * FROM users.

How do I do this?

Answer 1

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

Answer 2

Use the toSql() method on a QueryBuilder instance.

DB::table('users')->toSql() would return:

select * from `users`

This is easier than wiring up an event listener, and also lets you check what the query will actually look like at any point while you're building it.

Note: This method works for query builder or Eloquent, however toSql() is used instead of first() or get(). You cannot run the query and also get the SQL at the same time using this method.