const timeSchema = z.object({
joinTime: z
.string()
.datetime({ offset: true })
.transform((val) => new Date(val)),
leaveTime: z
.string()
.datetime({ offset: true })
.transform((val) => new Date(val))
})
const arrayTimeSchema = z.array(timeSchema)
// this will not work since it only give type hint into the returned object but doens't actually pase it
db.select({
timeData : sql<z.infer<typeof timeSchema>>`SQL QUERY`
})
const timeSchema = z.object({
joinTime: z
.string()
.datetime({ offset: true })
.transform((val) => new Date(val)),
leaveTime: z
.string()
.datetime({ offset: true })
.transform((val) => new Date(val))
})
const arrayTimeSchema = z.array(timeSchema)
// this will not work since it only give type hint into the returned object but doens't actually pase it
db.select({
timeData : sql<z.infer<typeof timeSchema>>`SQL QUERY`
})