[BUG]: querying on postgres interval type returns PostgresInterval, not string as inferred.

[zolboo-gtn]

What version of drizzle-orm are you using?

0.29.0

What version of drizzle-kit are you using?

0.20.4

Describe the Bug

const attendance = pgTable(
  "attendance",
  {
    ...
    breaktime: interval("breaktime"),
    ...
  }
);

Querying above table returns

type Attendance = {
    ...
    breaktime: PostgresInterval;
    ...
}

not inferred type

type Attendance = {
    ...
    breaktime: string | null;
    ...
}

I tried setting intervalstyle as iso_8601 on the table, but had no effect.

Expected behavior

Above setup returns string, something like P1Y2M3DT4H5M6S.

Environment & setup

No response

[zolboo-gtn]

above problem occurs on

db.query.attendance.findMany({
    ...
})

but not on

db.query.user.findMany({
    ...
    with: {
        attendances: true
    },
})

Second query returns somethings like PT15M as expected.

[realmikesolo]

Hello, @zolboo-gtn! Do you use neon driver?

[AndriiSherman]

should be fixed in 0.30.7

[n3oney]

I still get this issue, on 0.30.8 with neon driver

[realmikesolo]

Hey, @n3oney! You might use neon-http, right?

[n3oney]

Yep, neon-http.
Currently did this to fight the type errors:

  withdrawalFrequency: interval("withdrawal_frequency", {
    fields: "day",
  })
    .$type<{ days: number }>()
    .notNull()
    .default(sql`(INTERVAL '7 days')`),

[realmikesolo]

Got it @n3oney. It was fixed only for neon-serverless. Will be fixed for neon-http soon.

[san4d]

I'm still experiencing this issue on on drizzle-orm 0.30.9 and neon serverless 0.9.1.