DB::dd()->... like with Http::dd()->...

[shaedrich]

It's be nice to have a dd() method for queries as well like in Http::dd()-> since it's often needed to have the query (especially with bindings):

[backstageel]

But there is already this method on DB Facade:

\DB::table('product_bags')->whereNotNull('bag_id')->limit(10)->dd();

[shaedrich]

Oh, thanks. How could I have missed that? ^^ 🤦

[mbroersen]

If you would like to get more out of query dumps I created a package called
socialblue/laravel-query-adviser

which returns more information about your query

[
  "toSql" => "select * from `users` where `name` = ? and `users`.`deleted_at` is null"
  "bindings" => [
    0 => "mb"
  ]
  "query" => "select * from `users` where `name` = 'mb' and `users`.`deleted_at` is null"
  "optimizeQuery" => []
]

Instead of the default dd

"select * from `users` where `users` = ? and `users`.`deleted_at` is null"
[
  0 => "mb"
]

The package has more options, but this is one of them