expects date fields to be of type Date

[shivarm]

When drizzle $inferSelects on a table, it expects date fields to be of type Date, however, when they are fetched from database, they are casted as strings, causing difference in types runtime vs type inference, leading to runtime type errors, which are approved by typescript.

@amandesai01 then it would also same for createdAt and updatedAt?

Solution? Always use types be inferring from Zod, export from shared/schemas.

You mean we have to do it for all tables:

example

export type JobPosting = typeof jobPostingsTable.$inferSelect;

to

import { z } from 'zod'
import { jobPostingSchema } from './shared/schemas'
export type JobPosting = z.infer<typeof jobPostingSchema>;