Support interval equality and comparison between an array and a scalar

[joroKr21]

Is your feature request related to a problem or challenge?

Interval equality and comparison works fine between two arrays or between two scalars but it fails between a scalar and an array with an error like this: Data type IntervalMonthDayNano(...) not supported for scalar operation 'gt' on dyn array.

Here is an example query that fails:

select
    (interval '1 day') = i,
    (interval '1 day') != i,
    i < (interval '1 day'),
    i <= (interval '1 day'),
    i > (interval '1 day'),
    i >= (interval '1 day')
from t;

Describe the solution you'd like

Looks like an oversight in the binary_array_op_dyn_scalar macro. Simply adding the cases for interval types should be enough to make it work.

Describe alternatives you've considered

I'm not aware of any alternatives.

Additional context

This is related to #5753