Case insensitive orderBy macro

BuilderMacroServiceProvider.php

<?php

namespace App\Providers;

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

class BuilderMacroServiceProvider extends ServiceProvider
{
    /**
     * Register services.
     */
    public function register(): void {}

    /**
     * Bootstrap services.
     */
    public function boot(): void
    {
        $macro = function (string $column, string $direction = 'asc') {
            $dir = strtolower($direction) === 'desc' ? 'DESC' : 'ASC';

            /** @var \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder $this */
            $grammar = $this->getConnection()->getQueryGrammar();
            $wrapped = $grammar->wrap($column);

            return $this->orderByRaw("UPPER($wrapped) $dir NULLS LAST");
        };

        QueryBuilder::macro('orderByUpper', $macro);
        EloquentBuilder::macro('orderByUpper', $macro);
    }
}