If you are using Postgres, you don’t need to use UPPER, just use ilike as the comparator and it will do a case-insensitive comparison.
Model::where('column', 'ilike', '%' . $value . '%')
You do need the % signs to signify the substring you’re searching for.