How to convert zod object to select fields?

[shakibhasan09]

Hi,

I have a zod object like below

const obj = z.object({ id:z.number(), name:z.string(), .... }).pick({ name:true })
// or const obj = createSelectSchema(table).pick({ name:strue });

Now I want to use it inside sqlite select query

const query = await db.select(obj).from(); // Result {name:"Demo"}[]

Research I did:

export const zodTodrizzle = <
  S extends z.ZodObject<any>,
  T extends SQLiteTableWithColumns<TableConfig>,
>(
  schema: S,
  table: T
): SelectedFields => {
  const fields = {};

  Object.keys(schema.shape).forEach((key) => {
    if (key in table) {
      fields[key] = key as any;
    }
  });

  return fields;
};

// Getting error: Maximum call stack size exceeded

Dependencies:

typescript:^5.2,
zod:^3.23,
drizzle-orm:^0.31.2
drizzle-zod:^0.5.1