Filament: Raw SQL Usage in Tables and Widgets

Below are five raw SQL with MySQL syntax examples, along with the location where you can find them so you can explore more.

1. AVG() with ROUND()

app/Filament/Resources/MetricResource.php:

return $table
    ->modifyQueryUsing(function (Builder $query) {
        $query->select(
            [
                'id',
                'server_id',
                DB::raw('created_at as date'),
                // ...

Example queries in this project:

• avg() and round() usage
• if() usage
• case ... when ... usage
• date_format() usage
• concat() usage

All examples will include real use-case in the code. From tables to dashboard widgets.