Error when using snake_case column name in Email authentication with Drizzle adapter

[tjhoo]

Summary

Hi,

I'm running ta Next.js 13 application with NextAuth.js email authentication without any problem until I replaced the column names from camelCase to snake_case like the following,

import {
  timestamp,
  pgTable,
  text,
  primaryKey,
  integer,
} from "drizzle-orm/pg-core";
import type { AdapterAccount } from "@auth/core/adapters";

export const users = pgTable("user", {
  id: text("id").notNull().primaryKey(),
  name: text("name"),
  email: text("email").unique().notNull(),
  emailVerified: timestamp("email_verified", { mode: "date" }),
  image: text("image"),
});

export const accounts = pgTable(
  "account",
  {
    userId: text("user_id")
      .notNull()
      .references(() => users.id, { onDelete: "cascade" }),
    type: text("type").$type<AdapterAccount["type"]>().notNull(),
    provider: text("provider").notNull(),
    providerAccountId: text("provider_account_id").notNull(),
    refresh_token: text("refresh_token"),
    access_token: text("access_token"),
    expires_at: integer("expires_at"),
    token_type: text("token_type"),
    scope: text("scope"),
    id_token: text("id_token"),
    session_state: text("session_state"),
  },
  (account) => ({
    compoundKey: primaryKey(account.provider, account.providerAccountId),
  })
);

export const verificationTokens = pgTable(
  "verification_token",
  {
    identifier: text("identifier").notNull(),
    token: text("token").notNull(),
    expires: timestamp("expires", { mode: "date" }).notNull(),
  },
  (vt) => ({
    compoundKey: primaryKey(vt.identifier, vt.token),
  })
);

The following error is thrown in the console and it is complaining that column emailVerified is missing.

adapter_getUserByEmail { args: [ 'my.name@gmail.com' ] }
[next-auth][error][adapter_error_getUserByEmail] 
https://next-auth.js.org/errors#adapter_error_getuserbyemail column "emailVerified" does not exist {
  message: 'column "emailVerified" does not exist',
  stack: 'PostgresError: column "emailVerified" does not exist\n' +
    '    at ErrorResponse (webpack-internal:///(rsc)/./node_modules/.pnpm/postgres@3.3.5/node_modules/postgres/src/connection.js:528:70)\n' +
    '    at handle (webpack-internal:///(rsc)/./node_modules/.pnpm/postgres@3.3.5/node_modules/postgres/src/connection.js:335:728)\n' +    
    '    at Socket.data (webpack-internal:///(rsc)/./node_modules/.pnpm/postgres@3.3.5/node_modules/postgres/src/connection.js:223:17)\n' +    '    at Socket.emit (node:events:513:28)\n' +
    '    at addChunk (node:internal/streams/readable:324:12)\n' +
    '    at readableAddChunk (node:internal/streams/readable:297:9)\n' +
    '    at Readable.push (node:internal/streams/readable:234:10)\n' +
    '    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)\n' +
    '    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)',
  name: 'PostgresError'
}

The column has been renamed to email_verified in the database (or in the schema above). How can I configure the Drizzle adapter to read email_verified instead of emailVerified from the database?

Additional information

No response

Example

No response

[kaykhan]

Running into the same issue, did you find a fix?

[tjhoo]

I don't have a solution for this.