bug(timestamps): ibis.range doesn't accept ibis.timestamp objects (ibis expressions)

[cpcloud]

What happened?

In [1]: from ibis.interactive import *

In [2]: expr = ibis.range(ibis.now() - ibis.interval(days=1), ibis.now(), ibis.interval(seconds=1))

Fails with

TypeError: Unable to normalize <class 'ibis.expr.types.temporal.TimestampScalar'> to timestamp

Looks like we expect timestamp-like inputs to range to be Python literals, but we should allow arbitrary timestamp-typed expressions.

What version of ibis are you using?

main

What backend(s) are you using, if any?

DuckDB

Relevant log output

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[lostmygithubaccount]

I didn't know you could do this and wrote:

import ibis
import ibis.expr.datatypes as dt

ibis.options.interactive = True

ROWS = 1000
TIMESCALE = "m"

t = (
    ibis.range(ROWS)
    .unnest()
    .name("index")
    .as_table()
    .mutate(timestamp=ibis.now(), _tmp=ibis._["index"].cast(dt.Interval(TIMESCALE)))
    .mutate(timestamp=((ibis._["timestamp"] - ibis._["_tmp"]).truncate(TIMESCALE)))
    .drop("index", "_tmp")
)
t

much cleaner:

import ibis

from datetime import datetime, timedelta

ibis.options.interactive = True

now = datetime.now()

t = (
    ibis.range(now - timedelta(days=2), now, step=ibis.interval(minutes=1))
    .unnest()
    .name("timestamp")
    .as_table()
)
t

+1 on allowing ibis.now() and other things

[cpcloud]

PR incoming