[FEATURE]: include pre-defined database objects related to Neon Identity in drizzle-orm

[pffigueiredo]

Feature hasn't been suggested before.

• I have verified this feature I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

Description

Neon is about to launch a feature (Neon Identity) that will include a couple of pre-defined database objects:

• neon_identity schema
• users_sync table

However, for consumers of Drizzle to easily relate this users data with their other DB objects, it would be very beneficial that they could simply import them, and not have to write them in their schema everytime.

EXAMPLE

import { neonUsersTable } from "drizzle-orm/neon";
import { relations } from "drizzle-orm";
import { bigint, boolean, pgTable, text, timestamp } from "drizzle-orm/pg-core";

export const todos = pgTable("todos", {
  id: bigint("id", { mode: "bigint" })
    .primaryKey()
    .generatedByDefaultAsIdentity(),
  ownerId: text("owner_id"),
  task: text("task").notNull(),
  isComplete: boolean("is_complete").notNull().default(false),
  insertedAt: timestamp("inserted_at", { withTimezone: true })
    .defaultNow()
    .notNull(),
});

export const todosRelations = relations(todos, ({ one }) => ({
  owner: one(users, {
    fields: [todos.ownerId],
    references: [users.id],
  }),
}));

export const users = neonUsersTable();

[AndriiSherman]

Available in [email protected]

Release Notes