2 years ago

Following up on my previous article on https://chasingcode.dev/blog/mysql-cte-group-by-year-month-with-gaps/, I am offering an implementation of the same technique in Laravel. Note This requires MySQL v8.0+.

There's a Laravel package for everything, and CTEs are no exception.

Here's how this looks in Laravel: $user_id = 1; $bike_id = 100; $bindings = [$user_id, $bike_id, $user_id, $bike_id, $user_id, $bike_id]; $query = " date ) AS ( DATE(LAST_DAY(MIN(start_date))) rides user_id = ?

I hope Laravel will have first class support for Common Table Expressions at some point in the future, but for now these two techniques should suffice.