Support drizzle-zod in Astro DB

[austinm911]

Astro Info

Astro                    v5.1.2
Node                     v20.12.2
System                   macOS (arm64)
Package Manager          bun
Output                   static
Adapter                  none
Integrations             @astrojs/tailwind
                         astro:db
                         @astrojs/db/file-url

If this issue only occurs in one browser, which browser is a problem?

No response

Describe the Bug

createInsertSchema accepts a Table type from Drizzle. It appears the Table type created by defineTable is not compatible with drizzle zod.

It would be nice to be able to create or infer zod (i guess Valibot and others too) schemas either natively in Astro DB or be able to use the utilities like the drizzle-zod package.

// db/config.ts
const Character = defineTable({
	columns: {
		id: column.number({ primaryKey: true }),
		name: column.text(),
		age: column.number(),
		occupation: column.text(),
		createdAt: column.date({ default: new Date() }),
	},
})


// db/schema.ts
import { Character } from 'astro:db'
import { z } from 'zod'
import { createInsertSchema } from 'drizzle-zod'

export const CharacterSchema = createInsertSchema(Character) // CharacterSchema.shape has no properties
export type Character = z.infer<typeof CharacterSchema>
// type Character = {}

What's the expected result?

Character should contain the expected columns and their types.

Link to Minimal Reproducible Example

see description

Participation

• I am willing to submit a pull request for this issue.

[ascorbic]

As this is a feature request I'm going to transfer it to discussions.