Eloquent Query Builder Macro to output raw sql

raw_query.php

use Illuminate\Database\Eloquent\Builder;

Builder::macro('toRawSql', function(){
    return array_reduce($this->getBindings(), function($sql, $binding){
        return preg_replace('/\?/', is_numeric($binding) ? $binding : "'".$binding."'" , $sql, 1);
    }, $this->toSql());
});

// use
Model::where('field', 'value)->toRawSql();

// output
select * from model where field = 'value';