Eloquent where lower() LIKE with PostgrSQL Laravel

Solution:

You can useĀ DB::raw()

$cows->where(\DB::raw('LOWER(name)'), 'like', '%' . $word . '%');