Laravel how to get query with bindings?

Question

I have some query that I need to pass to another query using query builder

$query = DB::table('table')->whereIn('some_field', [1,2,30])->toSql();  Model::join(DB::raw("({$query}) as table"), function($join) {     $join->on('model.id', '=', 'table.id'); }) 

which should results with

Select * from model join (select * from table where some_field in (1,2,30)) as table on model.id = table.id 

but the bindings are not passed, which force me to do

$query = DB::table('table')->whereRaw('some_field in ('. join(',', [1,2,30]) .')')->toSql(); 

what can be unsafe at times. How can I get the query with bindings?

Answer 1

Check out the getBindings() method on the Builder class

getBindings()

$query = DB::table('table')->whereIn('some_field', [1,2,30]);  $sql = $query->toSql();  $bindings = $query->getBindings(); 

Answer 2

Laravel now offers debugging directly on your Builder!!!

https://laravel.com/docs/queries#debugging

\App\User::where('age', '18')->dump(); \App\User::where('age', '18')->dd(); 

Outputs

"select * from `users` where `age` = ?" [     0 => "18" ]