1 Pull request merged by 1 person

• Optimize Drizzle validator types

  #4424 merged May 9, 2025

4 Pull requests opened by 4 people

• [d1] Add construct function for D1 driver, and implement .mock()

  #4511 opened May 11, 2025

• add banned_until to supabase rls.ts

  #4513 opened May 12, 2025

• PoC using undefined for optional fields instead of null

  #4521 opened May 14, 2025

• Bump the npm_and_yarn group across 1 directory with 4 updates

  #4524 opened May 15, 2025

12 Issues closed by 3 people

• [BUG]: Invalid JSON Schema: Generated Date Type is Not Valid

  #4139 closed May 14, 2025

• [BUG]: Left-Join with SQLAlias can be Null-Type

  #4134 closed May 14, 2025

• [BUG]: drizzle-kit generates schema with invalid JavaScript syntax in default values

  #4121 closed May 14, 2025

• [FEATURE]: Constant Condition Expression Optimization

  #4082 closed May 13, 2025

• [BUG]: Bun sql returns malformed values for postgres numeric columns

  #4071 closed May 13, 2025

• [BUG]: drizzle-kit studio not working in docker

  #4055 closed May 13, 2025

• [FEATURE]:

  #4052 closed May 13, 2025

• [BUG]: The inferred type of X cannot be named without a reference to '../node_modules/drizzle-typebox/column.types.mjs'. This is likely not portable. A type annotation is necessary.

  #4030 closed May 13, 2025

• [BUG]:The inferred type of X cannot be named without a reference to ../../../node_modules/drizzle-orm/sqlite-core/index.cjs

  #4026 closed May 13, 2025

• [BUG]: using .omit on schemas created with createInsertSchema throws an error

  #4016 closed May 13, 2025

• [BUG]: Json content not escaped properly during insertion

  #4515 closed May 13, 2025

• [BUG]: Buffer is not defined using drizzle-arktype client side with vite

  #4383 closed May 9, 2025

10 Issues opened by 10 people

• [FEATURE]: Use Cloudflare New D1 Sessions API

  #4522 opened May 15, 2025

• [BUG]: Creating a Materialized View that depends on another fails because of creation order

  #4520 opened May 14, 2025

• [BUG]: `expo-sqlite` statements are never finalized

  #4519 opened May 14, 2025

• [BUG]: retrieved JSONB value has wrong type

  #4518 opened May 13, 2025

• [FEATURE]: Allow partial migrations

  #4512 opened May 12, 2025

• [FEATURE]: Relax batch type to accept BatchItem<'sqlite'>[] in DrizzleD1Database

  #4510 opened May 10, 2025

• [BUG]: query with self-referencing one-to-many relation is not executed

  #4509 opened May 10, 2025

• [BUG]: `drizzle-kit introspect` missing `--schema` option

  #4508 opened May 10, 2025

• [BUG]: Importing next-auth/adapters

  #4507 opened May 9, 2025

• [BUG]:findFirst not working on views

  #4505 opened May 9, 2025

115 Unresolved conversations

Sometimes conversations happen on old items that aren’t yet closed. Here is a list of all the Issues and Pull Requests with unresolved conversations.

• Support Zod v4 in drizzle-zod

  #4478 commented on May 14, 2025 • 2 new comments

• fix: #4494 Postgres join table with more than 100 columns

  #4495 commented on May 15, 2025 • 0 new comments

• [BUG]: `drizzle-kit pull` made a broken schema as TypeScript. (looks forget to import `tinyint` from drizzle-orm/mysql-core)

  #4110 commented on May 14, 2025 • 0 new comments

• [FEATURE]: add `updated_at` column to `neon_auth.users_sync` schema

  #4105 commented on May 14, 2025 • 0 new comments

• [BUG]: sqlite (D1) foreign key constraint failed - doesn't mention which constraint

  #4103 commented on May 14, 2025 • 0 new comments

• [BUG]:Cloudlfare D1 sqlite not applying changes to remote db

  #4111 commented on May 14, 2025 • 0 new comments

• [BUG]: Can not find table column definition when trying to update

  #4101 commented on May 14, 2025 • 0 new comments

• [BUG]:Module not found: Can't resolve 'pg-native'

  #4100 commented on May 14, 2025 • 0 new comments

• [BUG]: error: relation "users" does not exist

  #4098 commented on May 14, 2025 • 0 new comments

• [BUG]: Postgres join table with more than 100 columns

  #4494 commented on May 14, 2025 • 0 new comments

• [BUG]: db.$count inside relational query "extras" generates SQL with incorrect table names

  #3493 commented on May 14, 2025 • 0 new comments

• [BUG]: extras in findMany count relations is not working

  #3546 commented on May 14, 2025 • 0 new comments

• [FEATURE]: Auto-Alias Columns in Subqueries

  #2772 commented on May 14, 2025 • 0 new comments

• [FEATURE]: API for to 'flatten' response shapes when querying data from complex schemas and their relations.

  #2933 commented on May 14, 2025 • 0 new comments

• [BUG]: uniqueIndex.on doesn't transform sql statement correctly for IFNULL

  #3101 commented on May 14, 2025 • 0 new comments

• [BUG]: `INSERT INTO … SELECT` does not work with generated columns

  #3971 commented on May 14, 2025 • 0 new comments

• [FEATURE]: Add a possibility to add a comment on a Table, Column.......

  #886 commented on May 13, 2025 • 0 new comments

• [BUG]: No way to use `bun:sqlite` together with dirzzle-kit

  #1520 commented on May 13, 2025 • 0 new comments

• [DOCS]:Nest.js Integration guideline

  #4116 commented on May 13, 2025 • 0 new comments

• [BUG]: selectDistinct from $with CTE drops with queries

  #4095 commented on May 13, 2025 • 0 new comments

• [DOCS]: Improve CLI --help output

  #4094 commented on May 13, 2025 • 0 new comments

• [FEATURE]: Publish to JSR

  #4092 commented on May 13, 2025 • 0 new comments

• [BUG]: Query with relations containing numeric fields are cast to numbers in PostgreSQL

  #4091 commented on May 13, 2025 • 0 new comments

• [BUG]: Cloudflare D1 FOREIGN KEY constraint failed

  #4089 commented on May 13, 2025 • 0 new comments

• [FEATURE]: Allow specifying types for sql raw statements

  #4087 commented on May 13, 2025 • 0 new comments

• [BUG]: Pascal Case Table Names transformed into camelCase Variable Names when introspect

  #4086 commented on May 13, 2025 • 0 new comments

• [BUG]: Postgres column generates invalid default value of single quote '

  #4085 commented on May 13, 2025 • 0 new comments

• [BUG]: drizzle-kit does not allow loading of .env.{development,test}{,.local}

  #4083 commented on May 13, 2025 • 0 new comments

• [BUG]:Drizzle is not considering null values while inserting

  #4081 commented on May 13, 2025 • 0 new comments

• [FEATURE]: Reverse/Down Migrations

  #4005 commented on May 13, 2025 • 0 new comments

• fix(mysql): remove redundant AUTO_INCREMENT on serial columns

  #4470 commented on May 14, 2025 • 0 new comments

• Cache

  #4447 commented on May 14, 2025 • 0 new comments

• [drizzle-kit] Add support for table and column comments

  #4446 commented on May 15, 2025 • 0 new comments

• Alternation engine

  #4439 commented on May 15, 2025 • 0 new comments

• [pg] fix int8 precision loss in relations (bigint, bigserial and custom int8)

  #4166 commented on May 13, 2025 • 0 new comments

• [Pg] Fix: Postgis `geometry` query select fails when using `with`

  #2778 commented on May 14, 2025 • 0 new comments

• [MySql] Add support for `fulltext` search with MATCH AGAINST function

  #1030 commented on May 13, 2025 • 0 new comments

• [DOCS]: Better docs for foreign key declaration

  #3148 commented on May 16, 2025 • 0 new comments

• [FEATURE]: How much support for cockroachdb?

  #845 commented on May 16, 2025 • 0 new comments

• [FEATURE]: Add `--dry-run` flag to `push`

  #3263 commented on May 15, 2025 • 0 new comments

• [BUG]: pgEnum -> type "xxx" already exists during migration

  #3206 commented on May 15, 2025 • 0 new comments

• [FEATURE]: Codegen for zod schemas

  #941 commented on May 15, 2025 • 0 new comments

• [FEATURE]: Export AbstractGenerator for custom generators in seed scripts

  #4056 commented on May 15, 2025 • 0 new comments

• [BUG]: `drizzle-kit push` timeouts all the time

  #4123 commented on May 15, 2025 • 0 new comments

• [FEATURE]: postgres: deferrable constraints

  #1429 commented on May 15, 2025 • 0 new comments

• [BUG]: TypeError: Cannot read properties of undefined (reading 'columns')

  #3539 commented on May 14, 2025 • 0 new comments

• [BUG]: Two fails with `There is not enough information to infer relation`

  #4140 commented on May 14, 2025 • 0 new comments

• [FEATURE]: enum for integer columns

  #4138 commented on May 14, 2025 • 0 new comments

• [DOCS]:Disambiguating relations confused

  #4135 commented on May 14, 2025 • 0 new comments

• [BUG]: Xata drizzle-kit push zod validation error

  #4132 commented on May 14, 2025 • 0 new comments

• [BUG]: Parameters passed but seemingly not recognized as used

  #4129 commented on May 14, 2025 • 0 new comments

• [BUG]: drizzle-seed reset returns successful but no effect on the table

  #4124 commented on May 14, 2025 • 0 new comments

• [BUG]: Drizzle kit doesn't use bun sql driver for 'push' command

  #4122 commented on May 14, 2025 • 0 new comments

• [FEATURE]: Option to return null fields as undefined instead of null

  #2745 commented on May 14, 2025 • 0 new comments

• [FEATURE]: Dynamic Schema

  #1807 commented on May 14, 2025 • 0 new comments

• [DOCS]: recommend use of supportBigNumbers and bigNumberStrings with bigint and decimal when using mysql2

  #4119 commented on May 14, 2025 • 0 new comments

• [BUG]:Introspect does not pull foreign key names when `on delete` and `on update` are set to other than `no action`

  #4115 commented on May 14, 2025 • 0 new comments

• [BUG]: When using `relations`, and drizzle proxy, an error is given when the result is an empty array.

  #4113 commented on May 14, 2025 • 0 new comments

• [BUG]: Drizzle creating identifiers with name greater than 63 bytes without warning (critical)

  #4003 commented on May 13, 2025 • 0 new comments

• [BUG]: Postgres Error "malformed array literal"

  #4000 commented on May 13, 2025 • 0 new comments

• [BUG]: cannot insert jsonb in PGlite

  #3997 commented on May 13, 2025 • 0 new comments

• [BUG]: Multi column foreign key columns are sorted individually on introspection (critical bug)

  #3993 commented on May 13, 2025 • 0 new comments

• [BUG]: `drizzle-kit` does not have all its dependencies (e.g. `drizzle-orm` or `pg`) listed

  #3990 commented on May 13, 2025 • 0 new comments

• [BUG]: drizzle seed breaks serial sequence sync with Postgres serial type

  #3915 commented on May 13, 2025 • 0 new comments

• [BUG]: Array being passed as multiple params

  #1589 commented on May 13, 2025 • 0 new comments

• [FEATURE]: MSSQL dialect

  #585 commented on May 13, 2025 • 0 new comments

• [BUG]: value.getTime is not a function

  #2323 commented on May 12, 2025 • 0 new comments

• [BUG]: Incompatible Property After the Latest Version

  #4457 commented on May 12, 2025 • 0 new comments

• [BUG]: CLI options --dialect and --url not working for drizzle-kit migrate

  #3669 commented on May 12, 2025 • 0 new comments

• [BUG]: Typing issue when using tables with the same name across different schemas

  #2387 commented on May 12, 2025 • 0 new comments

• [BUG]: Cloudflare D1 transaction not supported

  #2463 commented on May 12, 2025 • 0 new comments

• Allow referencing deeply nested properties in relational queries

  #696 commented on May 11, 2025 • 0 new comments

• [BUG]: updating JSONB column turns it into corrupt JSONB

  #2279 commented on May 11, 2025 • 0 new comments

• [BUG]: drizzle-kit generate fails with "Cannot find module 'bun'" when schema imports randomUUIDv7 from 'bun'

  #4469 commented on May 11, 2025 • 0 new comments

• [BUG]: PgTable types don't work well when come from generics

  #4367 commented on May 11, 2025 • 0 new comments

• [BUG]: RLS Policies not applied with `push` but applied with `migrate`

  #3504 commented on May 10, 2025 • 0 new comments

• [BUG]: "Insert into ... select" expects all columns

  #3608 commented on May 10, 2025 • 0 new comments

• [FEATURE]: Add support for Postgresql `hstore` data type

  #1132 commented on May 10, 2025 • 0 new comments

• [BUG]: Cannot find module error when import includes '.js' file extension in TypeScript project

  #2705 commented on May 10, 2025 • 0 new comments

• [TUTORIAL]: Using in-memory Postgres when testing with vitest

  #4205 commented on May 9, 2025 • 0 new comments

• [BUG]: TypeError: Cannot read properties of undefined (reading 'replace')

  #3766 commented on May 9, 2025 • 0 new comments

• [DOCS]:following drizzle-kit and bun walkthrough fails at migrate command

  #3423 commented on May 9, 2025 • 0 new comments

• [BUG]: running bunx --bun drizzle-kit <pull/studio> fails to detect bun:sqlite driver

  #4350 commented on May 9, 2025 • 0 new comments

• [FEATURE]:Support for Encrypted Sqlite DB file with Studio and drizzle-kit

  #3198 commented on May 9, 2025 • 0 new comments

• [BUG]:push creates duplicate statements for unique column index

  #3574 commented on May 9, 2025 • 0 new comments

• [BUG]:Best Practices for Using drizzle-orm with MySQL on Vercel Next.js Edge Runtime (Minimal Example Requested)

  #4142 commented on May 9, 2025 • 0 new comments

• [BUG]: Drizzle Relational Query not filtering well

  #4080 commented on May 13, 2025 • 0 new comments

• [BUG]: RLS "using" rule not applied to supabase

  #4078 commented on May 13, 2025 • 0 new comments

• [BUG]: SQL Generation - Views with Dependencies Created in Alphabetical Order Instead of Schema Definition Order

  #4076 commented on May 13, 2025 • 0 new comments

• [FEATURE]: Simulate Virtual Generated Columns for Postgres

  #4074 commented on May 13, 2025 • 0 new comments

• [BUG]: Drizzle Studio Error with PostGIS and Relations in Bun Environment: Symbol(drizzle:Schema)

  #4072 commented on May 13, 2025 • 0 new comments

• [BUG]: Cannot use a dynamic select query as a subquery anymore (regression bug)

  #4069 commented on May 13, 2025 • 0 new comments

• [BUG]: Memory leaks with sqlite in react native

  #4068 commented on May 13, 2025 • 0 new comments

• [BUG]: rows count in the sidebar and in the main view is not in sync in drizzle studio

  #4067 commented on May 13, 2025 • 0 new comments

• [BUG]:

  #4066 commented on May 13, 2025 • 0 new comments

• [DOCS]: Clarify behavior of onConflictDoX when inserting multiple values at once

  #4065 commented on May 13, 2025 • 0 new comments

• [DOCS]: sqlite docs show "execute" but that doesn't exist, I think you meant "run"

  #4054 commented on May 13, 2025 • 0 new comments

• [BUG]: Drizzle Studio stuck at loading for Supabase DB

  #4047 commented on May 13, 2025 • 0 new comments

• [BUG]: Sqlite tables with columns named "length" break Drizzle Studio

  #4048 commented on May 13, 2025 • 0 new comments

• [BUG]: drizzle-seed not respecting the count value for all tables

  #4050 commented on May 13, 2025 • 0 new comments

• [BUG]: drizzle-kit introspect fails on supabase `auth` schema

  #4042 commented on May 13, 2025 • 0 new comments

• [FEATURE]:Add support for value lists

  #4044 commented on May 13, 2025 • 0 new comments

• [BUG]:Drizzle Studio shows converted UTC time for timestamp array columns

  #4041 commented on May 13, 2025 • 0 new comments

• [BUG]: calling `$count` on a replica using `withReplicas` throws a TypeError

  #4039 commented on May 13, 2025 • 0 new comments

• [BUG]: RDS Driver fails to insert arrays into PG

  #4038 commented on May 13, 2025 • 0 new comments

• [BUG]: TypeError: __vite_ssr_import_1__.db.$with is not a function

  #4035 commented on May 13, 2025 • 0 new comments

• [BUG]:arrayJoin doesn't seem to work with string arrays

  #4034 commented on May 13, 2025 • 0 new comments

• [DOCS]: Tests fail on main

  #4033 commented on May 13, 2025 • 0 new comments

• [BUG]: Kyselify not supporting snake_case casing

  #4029 commented on May 13, 2025 • 0 new comments

• [BUG]: vercel-postgres/migrator not using environment variables in NextJS

  #4019 commented on May 13, 2025 • 0 new comments

• [FEATURE]: Loading state for useLiveQuery

  #4012 commented on May 13, 2025 • 0 new comments

• [BUG]: When using database url to connect to postgresql (supabase), the url breaks if there unencoded entities in the password.

  #4010 commented on May 13, 2025 • 0 new comments

• [FEATURE]: Facility to ignore tables/views on `drizzle-kit push`

  #4008 commented on May 13, 2025 • 0 new comments

• [BUG]: PG `drizzle-kit introspect` doesn't work for `NOT DISTINCT('nulls')`

  #4007 commented on May 13, 2025 • 0 new comments

• [BUG]: `drizzle-kit push` erroring does not return a error exit code

  #4006 commented on May 13, 2025 • 0 new comments