Integrate Complex SQL with Eloquent using `DB::raw`

use App\Models\Order;
use Illuminate\Support\Facades\DB;

// Example 1: Selecting a calculated column
$ordersWithTotal = Order::select('id', 'customer_id', DB::raw('price * quantity AS total_amount'))
                            ->get();

foreach ($ordersWithTotal as $order) {
    echo "Order ID: " . $order->id . ", Total Amount: " . $order->total_amount . "
";
}

// Example 2: Using raw expressions in a WHERE clause
$recentOrders = Order::where(DB::raw('DATE(created_at)'), '=', DB::raw('CURDATE()'))
                        ->get();

foreach ($recentOrders as $order) {
    echo "Recent Order ID: " . $order->id . "
";
}

// Example 3: Grouping by a raw expression
$ordersPerDay = Order::select(DB::raw('DATE(created_at) as order_date'), DB::raw('COUNT(*) as total_orders'))
                        ->groupBy(DB::raw('DATE(created_at)'))
                        ->orderBy('order_date', 'desc')
                        ->get();

foreach ($ordersPerDay as $day) {
    echo "Date: " . $day->order_date . ", Orders: " . $day->total_orders . "
";
}