[FEATURE]: Preserve/allow for JSDoc comments in inferred types

[tobi-or-not-tobi]

Feature hasn't been suggested before.

• I have verified this feature I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

When using Drizzle's type inference ($inferSelect), JSDoc comments from the schema definition are lost in the inferred types. This makes it harder to maintain self-documenting code as the documentation needs to be duplicated or is lost entirely when working with the inferred types.

Current Behavior

// schema.ts
export const myTable = pgTable('my_table', {
  /** The value of the style property */
  value: text('value'),
});

// model.ts
export type MyTable = typeof myTable.$inferSelect;

// The resulting type loses all JSDoc comments:
// type MyTable = {
//   value: string | null;
// }

I'd hope we can infer the JSDoc or have an alternative way to provide generation of JSDoc.

[L-Mario564]

This would be a feature suggestion for Typescript. TS doesn't provide any way to infer the JSDoc comments, so there's nothing we (Drizzle) can do on our side.

[franky47]

Zod does this, so I don't think it's a TypeScript limitation:

const schema = z.object({
  /** JSDoc goes here */
  field: z.string()
})

type Schema = z.infer<typeof schema>
// {
//  /** JSDoc goes here */
//  field: string
// }