[FEATURE]: Default column names based on column keys

[Vorelli]

Describe what you want

To define a column, one has to define a key in the "columns object" and then define a column name (which in my case, inevitably ends up the same as the key). This change would make the name optional and if it's not present, fall back to the column key for the column name, if possible. If it's not valid, error out. In my opinion, it doesn't add value and wastes dev time.

Before:

import type { InferSelectModel, InferInsertModel } from "drizzle-orm";
import { boolean, pgTable, serial, varchar } from "drizzle-orm/pg-core";
import { createInsertSchema, createSelectSchema } from "drizzle-zod";

export const Sites = pgTable('site', {
  id: serial('id').primaryKey(),
  description: varchar('description', { length: 300 }).notNull(),
  search: varchar('search', { length: 300 }).notNull(),
  signin: varchar('signin', { length: 300 }).notNull(), // sign-in url
  signup: varchar('signup', { length: 300 }).notNull(), // sign-up url
  enabled: boolean('enabled').notNull().default(false)
})

export type SiteSelect = InferSelectModel<typeof Sites>;
export type SiteInsert = InferInsertModel<typeof Sites>;

export const siteSelectSchema = createSelectSchema(Sites);
export const siteInsertSchema = createInsertSchema(Sites);

After:

import type { InferSelectModel, InferInsertModel } from "drizzle-orm";
import { boolean, pgTable, serial, varchar } from "drizzle-orm/pg-core";
import { createInsertSchema, createSelectSchema } from "drizzle-zod";

export const Sites = pgTable('site', {
  id: serial().primaryKey(),
  description: varchar({ length: 300 }).notNull(),
  search: varchar({ length: 300 }).notNull(),
  signin: varchar({ length: 300 }).notNull(), // sign-in url
  signup: varchar({ length: 300 }).notNull(), // sign-up url
  enabled: boolean().notNull().default(false)
})

export type SiteSelect = InferSelectModel<typeof Sites>;
export type SiteInsert = InferInsertModel<typeof Sites>;

export const siteSelectSchema = createSelectSchema(Sites);
export const siteInsertSchema = createInsertSchema(Sites);