Parse raw database object into typed object, similar to what drizzle-zod is doing

[sp88011]

How would I go about turning an object that uses the actual raw database columns as keys into a type-safe object?

This is coming up because I'm using Supabase Realtime and the response object I'm getting from the database has the actual raw column names as keys.

Example

I want to turn an object of type Record<{ [key:string]: any}>, like this one:

{
created_at: 2025-02-13 18:08:16.526659
updated_at: NULL
//...
}

into a type-safe object (as if I had used Drizzle to query it)

createdAt: 2025-02-13 18:08:16.526659
updatedAt: NULL

This is the underlying table definition:

export const messageTable = pgTable(
  "message",
  {
    createdAt: timestamp("created_at").notNull().defaultNow(),
    updatedAt: timestamp("updated_at"),
//...
})

The drizzle-zod package is awesome, but using createSelectSchema assumes that the object keys are createdAt and updatedAt versus created_at and updated_at.