Summaries error in MSSQL Environment

[CruxAllez]

Package

filament/filament

Package Version

v3.2.62

Laravel Version

v11.2.0

Livewire Version

No response

PHP Version

8.3.6

Problem description

When I am using the summaries feature from table builder in mssql with a complex table name it generate a select query that has a invalid as for the subquery it uses the table name but points are not allowed in the as

The Problem is for examble in Summirzer.php

$query = DB::connection($query->getModel()->getConnectionName())
    ->table($query->toBase(), $query->getModel()->getTable());

Expected behavior

The subquery should generate valid aliases for tables, even in MSSQL environments with complex schema names.

Steps to reproduce

Create a model with a complex schema name
Use table builder with summarization in MSSQL environment.

TextColumn::make('EFK_VERKAUFSWERT_NETTO')
                    ->summarize(Sum::make())

Observe the error due to invalid table aliases in the generated subquery's AS clause.

Reproduction repository

https://github.com/CruxAllez/filament-issue-mssql

Relevant log output

No response

[danharrin]

I am not a user of this driver, so I would appreciate you investigating the issue and opening a PR if you can, I don't know if any of the Filament team are going to take active action on this bug report so I don't want you to be left waiting.