Support multiply and divide on intervals

[alamb]

Is your feature request related to a problem or challenge?

Copied directly from apache/arrow-rs#6335 from @samuelcolvin

In Postgres I can do:

select 3 * interval '1 day';
select interval '1 day' * 3;  -- same
select 1.23 * interval '1 day';
-- and divide
select interval '1 day' / 3;

I started trying to add support for this to datafusion but discovered that the operations aren't supported in arrow-rs and adding them (with support for all numeric types) is far from trivial.

Describe the solution you'd like

The idea is to support the syntax above in DataFusion

High level steps are:

• Arrow-rs support: Support interval multiplication and division by arbitrary numerics arrow-rs#6906
• PR in DataFusion to allow the operations and add appropriate tests

Describe alternatives you've considered

No response

Additional context

I believe @milevin is already working on this (so perhaps you would like to assign this ticket to yourself via take)

[milevin]

take