Laravel to SQL with Bindings Macro

MacroServiceProvider

<?php

namespace App\Providers;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\ServiceProvider;

class MacroServiceProvider extends ServiceProvider
{
    public function register()
    {
        /**
        * Borrowed from Telescop
        * @see https://github.com/laravel/telescope/blob/4.x/src/Watchers/QueryWatcher.php#L85
        **/
        Builder::macro('toRawSql', function() {
            $sql = $this->toSql();

            foreach ($this->getBindings() as $key => $binding) {
                $regex = is_numeric($key)
                    ? "/\?(?=(?:[^'\\\']*'[^'\\\']*')*[^'\\\']*$)/"
                    : "/:{$key}(?=(?:[^'\\\']*'[^'\\\']*')*[^'\\\']*$)/";

                if ($binding === null) {
                    $binding = 'null';
                } elseif (! is_int($binding) && ! is_float($binding)) {
                    $binding = DB::connection()->getPdo()->quote($binding);
                }

                $sql = preg_replace($regex, $binding, $sql, 1);
            }

            return $sql;
        });
    }

}