[BUG]:timestamp being transformed wrongly with bun:sql

[eslym]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.39.3

What version of drizzle-kit are you using?

0.30.4

Other packages

[email protected]

Describe the Bug

bun:sql return timestamp as Date natively, so the following line create problem

drizzle-orm/drizzle-orm/src/pg-core/columns/timestamp.ts

Line 62 in e5c63db

return new Date(this.withTimezone ? value : value + '+0000');

it resulting new Date("${Date}+000") which would become something like new Date("Fri Feb 21 2025 01:52:26 GMT+0000 (Coordinated Universal Time)+000"), it would still able to be parsed into Date but the precision will lost.

I have to make the following helper function to ensure date is retrieved correctly

export function precise_date(src: SQL | SQLWrapper) {
    return sql`(${src})::text`.mapWith((d) => new Date(d));
}

db.select({ createdAt: precise_date(table.createdAt) })