Addition of a whereOrNull method

[sdsmith1981]

I've found a lot of times in our code we were duplicating the same basic premise - a nested where that returns when a value matches or is null, so have added this to our service provider instead.

Would this be of use, worth creating a PR for?

    Builder::macro('whereOrNull', function ($column, $value) {
        return $this->where(function ($query) use ($column, $value) {
            $query->where($column, $value);
            $query->orWhereNull($column);
        });
    });

[henzeb]

i'd suggest also adding an whereEmpty and a whereNotEmpty shortcut, as those are used often as well.

[ZebTheWizard]

whereOrNull and orWhereNull are awfully similar method names
would love to see this helper but with a slightly different name
best I can come up with is whereNullSafe or whereOptional

[sdsmith1981]

I'm happy with whereOptional. I couldn't think of a better alternative tbh.