Use COALESCE in index
How can I generate this sql:
When I use the following schema definition:
The comma in COALESCE get escaped:
When I use the following schema definition:
The comma in COALESCE get escaped:
CREATE UNIQUE INDEX "IndexName" ON "Table" ("foo", COALESCE ("bar", ''));uniqueIndex("IndexName").on(table.foo, sql`COALESCE(${table.bar}, '')`)CREATE UNIQUE INDEX `IndexName` ON `Table` (`foo`,`COALESCE("bar"`,` '')`);