toRawSql.php

toRawSql.php

<?php

declare(strict_types=1);

use Illuminate\Database\Eloquent\Builder as EloquentBuilder;
use Illuminate\Database\Query\Builder as QueryBuilder;

QueryBuilder::macro(
    'toRawSql',
    function () {
        return array_reduce(
            $this->getBindings(),
            static function ($sql, $binding) {
                if ($binding instanceof DateTime) {
                    $binding = $binding->format('Y-m-d H:i:s');
                }
                return preg_replace(
                    '/\?/',
                    is_string($binding) ? "'" . $binding . "'" : $binding,
                    $sql,
                    1
                );
            },
            $this->toSql()
        );
    }
);

EloquentBuilder::macro(
    'toRawSql',
    function () {
        return $this->getQuery()->toRawSql();
    }
);