[BUG]: Condition with Date as input in sql template fails

[mpost]

What version of drizzle-orm are you using?

0.30.1

Describe the Bug

With a column

timestamp('createdAt', { mode: 'date', withTimezone: true }).notNull(),

using a where condition like

gte(sql`(${product.createdAt} AT TIME ZONE ${timeZone})`, date)

we see the following error:

TypeError [ERR_INVALID_ARG_TYPE]: The "string" argument must be of type string or an instance of Buffer or ArrayBuffer. Received an instance of Date

Changing the the timestamp mode to string or date has not effect.

The only workaround is to convert the date to string when inserting in the where condition:

gte(sql`(${product.createdAt} AT TIME ZONE ${timeZone})`, date.toISOString())

This issue did not occur in 0.29.3 and below.

Expected behavior

The Date object should be accepted as input in the where clause.

Environment & setup

Postgres

[abustany]

Duplicate of #1993 ?

[mpost]

Yes, possibly the same issue. This one is in a template string but sounds similar.

[L-Mario564]

Closing in favor of #2009.

[gp27]

Closing in favor of #2009.

This was the issue #2009 itself. It was likely meant to be closed in favor of issue #1993.

[L-Mario564]

This was the issue #2009 itself. It was likely meant to be closed in favor of issue #1993.

Correct. My bad.