How to handle decimals properly?

[tzezar]

We are using postgres database, it returns decimals as number, but kysely-codegen make those strings. This makes super hard to work with zod schema validation because typing schema properly (value as string) raise schema does not match results and typing it correctly raise ts error at response level.

Upvote & Fund

• We're using Polar.sh so you can upvote and help fund this issue.
• We receive the funding once the issue is completed & confirmed by you.
• Thank you in advance for helping prioritize & fund our backlog.

[tzezar]

Parsing types was not working untill we reinstalled every dependency - no idea why this happend. Because there is no way in kysely-codegen to specify to which types values are generated I believe this is only way simplifying things.

const numericTypeId = 1700;
pg.types.setTypeParser(numericTypeId, (val: string) => {
  return String(val);
});