How to alias a table's "SELECT *" return type?

[david-sabata]

Despite the nice type inference for queries, I still want to have a type for the "entity". Meaning a full DB row - basically a type for what a SELECT * query would return.

Is there a way to get to the drizzle-generated type without re-defining it?

My schema is pretty basic, e.g.

export const users = pgTable("users", {
   id: text().primaryKey().notNull(),
   name: text().notNull(),
   realName: text("real_name"),
   title: text(),
   email: text(),
   isRestricted: boolean("is_restricted").notNull(),
   isDeleted: boolean("is_deleted").notNull(),
   isBot: boolean("is_bot").notNull(),
})

And I'm looking for something like

export type DbUser = users.allColumnsType // <= would be {id: text, name: text ,..., isBot: boolean}