Option to configure Drizzle

[wladpaiva]

Goals

1. allow more flexible user ids

Non-Goals

Background

Currently the drizzle adapter is invoking the crypto.randomUUID() to create ID for users for each type of database.
If you want to be able to configure the user id lets say "us_XXXXXXXXX" you can't.

Proposal

We could simple remove the reference to ID when users are created and provide the $defaultFn in the initial setup.

export const users = pgTable("user", {
 id: text("id").notNull().primaryKey().$defaultFn(() => crypto.randomUUID()),
 name: text("name"),
 email: text("email").notNull(),
 emailVerified: timestamp("emailVerified", { mode: "date" }),
 image: text("image"),
})

I realize the mysql would need to somehow query the data it just inserted but I guess we should make email unique and close #8629 as well