[BUG]: TypeError: Do not know how to serialize a BigInt about drizzle-orm

[bondz]

The issue here is not with drizzle. Drizzle returns the correct datatype for the column as specified in the schema. The issue is when you want to send it via fastify to the client, and it doesn't only affect fastify, express too would be affected. You can serialize the data yourself before sending it to the client. See options here

[alpapan]

Perhaps. But if you notice my post you will see that foreign key references are set the mode to number even if the referenced column is a bigserial/bigint.

It would work out of the box if drizzle was consistent and set the mode to number for bigserial during column definition and provided the same comment as it does for columns with foreign key references.

If it was me, I would make sure the mode was identical in both definitions, both bigint or number. I would also add a note in the documentation somewhere.

Up to you if you and how you want to interact with the user community. After an hour I learnt how to fix it on my system.