Support native database filed types

[RobertCZ]

Not sure if this is already possible and I just missed it in the docs but how about supporting database specific field types?

Eg Prisma already generates for MS SQL field TinyInt

UseFee Int @db.TinyInt

It would be nice to say somewhere that Int @db.TinyInt should be mapped to tinyint() and generate automatically

UseFee: tinyint()

for Zod with some db specific validators eg const tinyint = () => z.number().int().min(0).max(255)

[chrishoermann]

@RobertCZ thanks for the request but sadly this is not possbile yet, because these field types are currently not present in the prisma.dmmf which is the source of truth for all generated prisma types and also our generated schemas. 😢

[RobertCZ]

Thank you. Created question prisma/prisma#22157

[AlexanderArvidsson]

@chrishoermann I proposed a workaround in the Prisma issue that I've been using in my own custom generator that might interest you:
prisma/prisma#10252 (comment)

Perhaps you can make use of the same method to generate better Zod schemas!