Help with drizzle-valibot

[jbeckton]

Hello Devs...

I am trying to get my head around this integration, my use case may or may not be unique but I am struggling to make this work.

Below is my users table schema, I am trying to create a valibot schema from that for validating the input for an update operation. I only want to allow for the one field named externalId to be updated. I am clueless about the correct way to create this custom schema from the drizzle schema, or maybe I am over thinking this and should just create a native valibot schema and use that?

export const users = pgTable('users', {
    id: uuid('id').primaryKey(),
    externalId: varchar('external_id', { length: 100 }).notNull().unique(),
    profileId: uuid('profile_id').notNull().unique(),
    createdAt: timestamp('created_at').defaultNow().notNull(),
    updatedAt: timestamp('updated_at'),
}, (table) => [
    index('external_id_idx').on(table.externalId),
]);

export const userUpdateSchema = createUpdateSchema(users, {
    externalId: (schema) => v.pipe(schema, v.maxLength(100, 'External ID must be less than 100 characters'))
});

Thanks!