Laravel Eloquent Case Laravel Package

aglipanci/laravel-eloquent-case adds native SQL CASE WHEN expressions to Laravel's Eloquent and query builder. Instead of hand-writing DB::raw() strings, you get a fluent, readable API for conditional logic inside select, orderBy, and aggregate clauses.

User::query()
    ->case()->when('age', '>=', 18)->then('adult')->else('minor')->end();

• Fluent case() / when() / then() / else() / end() chain
• Safe parameter binding — no hand-written SQL fragments
• Composable with models, scopes, and the base query builder
• Supports multiple when branches and raw conditions