[BUG]: Cannot use schema.coerce on refining drizzle-zod types

[cybercoder-naj]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.38.2

What version of drizzle-kit are you using?

0.30.1

Other packages

[email protected]

Describe the Bug

Consider the following schema below where the fields createdAt and pinUntil are timestamps and they translate to using the Date object from JavaScript:

export const announcements = pgTable('announcements', {
  id: serial('id').primaryKey(),
  title: text('title').notNull(),
  description: text('description').notNull(),
  createdAt: timestamp('created_at').notNull(),
  pinUntil: timestamp('pin_until')
});

/* Option 1 */
const insertAnnouncementSchema = createInsertSchema(announcements, {
  createdAt: z.coerce.date(),
  pinUntil:  z.coerce.date().optional(),
})

I cannot coerce the types in drizzle-zod and extend the existing zod types at the same time. For an API server that serializes the request body in a string format, I should be able to coerce the types.