How Do I Get the Query Builder to Output Its Raw SQL Query as a String?

php sql laravel laravel-4 laravel-query-builder
meiryo picture meiryo · Aug 14, 2013 · Viewed 704.5k times · Source

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

Steven Mercatante picture Steven Mercatante · Dec 4, 2013

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.

Related questions

Laravel Eloquent how to use between operator

I am trying to find an elegant way in Eloquent and Laravel to say select * from UserTable where Age between X and Y Is there a between operator in Eloquent (I can't find it). The closest i have gotten so …

Read More
eloquent laravel: How to get a row count from a ->get()

I'm having a lot of trouble figuring out how to use this collection to count rows. $wordlist = \DB::table('wordlist')->where('id', '<=', $correctedComparisons) ->get(); I have tried adding->count() but didn't work. …

Read More
How to insert multiple rows from a single query using eloquent/fluent

I have the following query: $query = UserSubject::where('user_id', Auth::id())->select('subject_id')->get(); and as expected I get the following result: [{"user_id":8,"subject_id":9},{"user_id":8,"subject_id":2}] Is there a way …

Read More