[PG] Improve default value generation for array columns

drizzle-team / drizzle-orm

Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

https://orm.drizzle.team

Apache License 2.0

23.56k stars 579 forks source link

[PG] Improve default value generation for array columns #2756

Closed L-Mario564 closed 1 month ago

L-Mario564 commented 1 month ago

Addresses #2621, #2709, #2432, #2334, #2224, #1003 & #1564.

This PR aims to improve the way Drizzle Kit generates the default value for array columns, successfully converting a TS array into a string that represents it in SQL.

AndriiSherman commented 1 month ago

Thanks a lot, @L-Mario564! To ensure that all the tickets from the list are closed, please add test cases for all the issues

for example #2709 has a problem with the default in enums, but I can't see a test case for the enum type
for #1003 it's uuid type
#1564 also has a enum in example