Is there a Global type or namespace available for the entire DB Schema?

[maxpaleo]

Hi all,

I was wondering if there is some kind of type direclty available for the entire DB schema by default? I couldn't directly find anything in the docs.

We currently access types like this:

DB.Tables.Organization.Select.Type

Or keys directly

DB.Tables.Organization.Select.Type["id"]

We currently have a namespace called DB which contains all the Schema tables and each table contains a type as well as a zodschema for easy access, however we do have to update this each time a table is added or potentially removed from the schema, and I thought that this might be generated in some way during the generation process?

export namespace DB {
/** DB Tables */
  export namespace Tables {
    /** User */
    export namespace User { // Each table contains an insert and select namespace that each have a type and a zod schema
      export namespace Select {
        export type Type = typeof users.$inferSelect;
        export const ZodSchema = createSelectSchema(users);
      }
      export namespace Insert {
        export type Type = typeof users.$inferInsert;
        export const ZodSchema = createInsertSchema(users);
      }
    }
    export namespace Organization {
      // ....
  }
}