I am trying to find an elegant way in Eloquent and Laravel to say
select * from UserTable where Age between X and Y
Is there a between operator in Eloquent (I can't find it).
The closest i have gotten so far is chainging my query like this
$query->where(age, '>=', $ageFrom)
->where(age, '<=', $ageTo);
I also came across whereRaw that seems to work
$query->whereRaw('age BETWEEN ' . $ageFrom . ' AND ' . $ageTo . '');
Is there an actual Eloquent way (not raw) that deals with ranges?
$query->whereBetween('age', [$ageFrom, $ageTo]);
Still holds true for Laravel 10+ https://laravel.com/docs/10.x/queries#additional-where-clauses