[Proposal] Add a method in query builders that will substitue question mark with the bindings value

[ajcastro]

I think it is helpful if there is a method that will substitue question mark with the bindings value for debugging queries.. so you can copy-paste it in your sql editor. This is very useful for debugging long complex queries.

How about sql()?

User::where('is_active, 1)->sql(); 
// this will print 
// select * from `users` where `is_active` = 1
// instead of
// select * from `users` where `is_active` = ?

if (!function_exists('sql')) {
    function sql($query)
    {
        $sql = $query->toSql();

        foreach ($query->getBindings() as $binding) {
            $sql = str_replace_first('?', "'{$binding}'", $sql);
        }

        return $sql;
    }
}

if (!function_exists('str_replace_first')) {
    function str_replace_first($from, $to, $subject)
    {
        $from = '/'.preg_quote($from, '/').'/';

        return preg_replace($from, $to, $subject, 1);
    }
}

[ntzm]

I believe this has been PRed and rejected in the past:

laravel/framework#21796