drizzle-team / drizzle-orm

Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
https://orm.drizzle.team
Apache License 2.0
24.56k stars 645 forks source link

[FEATURE]: Adding more columns to Supabase `auth.users` table schema #3327

Closed nicholasdly closed 1 week ago

nicholasdly commented 2 weeks ago

What version of drizzle-orm are you using?

0.36.0

What version of drizzle-kit are you using?

0.27.0

Describe the Bug

The current native implementation of the Supabase auth.users table schema is missing many of the columns that the table actually includes in Supabase.

Expected behavior

I expect at least some of the missing columns, such as email, phone, and created_at, to be added to the auth.users table schema, so we can avoid creating duplicate or redundant columns in a custom, public table we make ourselves.

This would also allow us to create more relations on the auth.users table.

Environment & setup

No specific environment.

AndriiSherman commented 1 week ago

Was added in drizzle-kit@0.28.0