[FEATURE]: NULLS (NOT) DISTINCT for Postgres

[tmcw]

trafficstars

Describe want to want

A very useful new-ish feature (afaict, Postgres 15), is NULLS NOT DISTINCT in Postgres unique indexes:

https://www.postgresql.org/docs/current/sql-createindex.html

Supporting this as an option in the Drizzle index builder would be extremely useful. I can take a shot at adding this if I can grab the time on my schedule and it seems worthy of inclusion!

---

Tinkered with this a little bit and I can add additional configuration & chained methods to the index, but I think the logic for building migrations is in drizzle-kit, so I can't currently help much with implementing this.