[BUG]:

[mitchellwarr]

What version of drizzle-orm are you using?

0.31.0

What version of drizzle-kit are you using?

0.22.1

Describe the Bug

Creating an index with a where condition

index('locations_open_orders_index')
      .on(table.locationId, table.startedAt.desc())
      .where(eq(table.open, true))

Creates in the migration file:

CREATE INDEX IF NOT EXISTS "locations_open_orders_index" ON "orders" USING btree (location_id,started_at DESC NULLS LAST) WHERE "orders"."open" = $1;--> statement-breakpoint

Which causes the migration to fail with:

applying migrations...error: there is no parameter $1

The docs say to use

// First example, with `.on()`
index('name')
  .on(table.column1.asc(), table.column2.nullsFirst(), ...) or .onOnly(table.column1.desc().nullsLast(), table.column2, ...)
  .concurrently()
  .where(sql``)
  .with({ fillfactor: '70' })

With the sql builder instead of the helper functions, and I'm about to use that instead, but there is no reason to suspect the helper functions wouldnt work here.

Expected behavior

In the migration file it would generate

CREATE INDEX IF NOT EXISTS "locations_open_orders_index" ON "orders" USING btree (location_id,started_at DESC NULLS LAST) WHERE "orders"."open" = true;

Environment & setup

No response