SNOW-1639756: Add support for range_between interval

[rwhitten577]

What is the current behavior?

RANGE BETWEEN INTERVAL was recently added to Snowflake SQL: https://community.snowflake.com/s/article/How-to-rewrite-a-RANGE-BETWEEN-INTERVAL-query-in-Snowflake

However, Window.range_between currently supports integer arguments for start and end. The new RANGE BETWEEN INTERVAL syntax does not work, unless you do something like convert the order_by timestamp to unix and set start/end to an integer value in seconds.

E.g.:

twenty_four_months_in_seconds = 63115200

window_spec = (
    Window.partition_by("id")
    .order_by(F.unix_timestamp("event_time"))
    .range_between(-twenty_four_months_in_seconds, Window.CURRENT_ROW)
)

What is the desired behavior?

Support non-int arguments for Window.range_between, at least allowing a literal like INTERVAL '24 MONTHS' PRECEDING

window_spec = (
    Window.partition_by("id")
    .order_by(F.unix_timestamp("event_time"))
    .range_between(F.lit("INTERVAL '24 MONTHS' PRECEDING", Window.CURRENT_ROW)
)

How would this improve snowflake-snowpark-python?

Support more flexible window functions and update to latest Snowflake SQL capabilities.

References, Other Background