Prisma PostgreSQL native types mapping support

[pasha-vuiko]

Hi!
I would like to request support for Postgres Native types mapping from the Prisma Schema, for example Prisma Schema:

model EveryDayScheduleItem {
    scheduledTime DateTime @db.Time()
}

Now generated to this drizzle schema:

export const EveryDayScheduleItem = pgTable('EveryDayScheduleItem',
{
    scheduledTime: timestamp('scheduledTime', { precision: 3}).notNull()
}

But it should be:

export const EveryDayScheduleItem = pgTable('EveryDayScheduleItem',
{
    scheduledTime: time('scheduledTime', { precision: 3}).notNull()
}

[Sukairo-02]

I'd like to, but Prisma does not expose this data, as well as onUpdate in it's generator API.

[pasha-vuiko]

Sounds not good =((
Maybe it would be a nice idea to create an issue in the Prisma repository that would mention the problem?

[Sukairo-02]

We actually reached out to them already on Discord and I believe I've seen the issue requesting this from long ago, not sure what else I can do to make it happen.

[pasha-vuiko]

I got it, so I guess the issue can be closed

[Sukairo-02]

Let it be, this IS an issue after all, just not all that dependent on my actions for now

[pasha-vuiko]

I understand

[pasha-vuiko]

Hey! What do you think about this? 🙂
prisma/prisma#10252 (comment)

This might help to implement the lacking functionality

[pasha-vuiko]

I've created the PR using the approach above to add support for Time type for PostgreSQL
#7

By this example possible to add support for other types. It can be temporary solution till the moment when Prisma team implements the native type exposing natively

[pasha-vuiko]

I've also added support of native time type for MySQL