drizzle-orm

See references/connections.md for all provider setups (Neon, Turso, Supabase, D1, etc.).

| serial() | Auto-increment PK | Use integer().generatedAlwaysAsIdentity() for new projects | | integer() | 4-byte int | | | bigint({ mode: "number" }) | 8-byte int | "bigint" mode for >2^53 | | text() | Unlimited text | { enum: [...] } for TS union | | varchar({ length: n }) | Variable-length | | | boolean() | true/false | |

| timestamp() | Date/time | { withTimezone: true }, mode: "date" | | date() | Calendar date | mode: "date" for JS Date | | json() / jsonb() | JSON data | .$type () for typing | | uuid() | UUID | .defaultRandom() for genrandomuuid() | | numeric({ precision, scale }) | Exact decimal | Returns string by default |