Transition plan away from @vercel/postgres in db-vercel-postgres package?

[fturmel]

Vercel's PostgreSQL storage service (white-labeled Neon) has been phased out in favor of a marketplace integration with Neon directly. They have also stopped maintaining the @vercel/postgres serverless driver which is currently used by Payload's db-vercel-postgres package.

payload/packages/db-vercel-postgres/package.json

Line 79 in 9c8f320

"@vercel/postgres": "^0.9.0",

https://github.com/vercel/storage/tree/main/packages/postgres

There's a whole transition guide here which recommends @neondatabase/serverless for new project and migrating to @neondatabase/vercel-postgres-compat for existing ones.
https://neon.com/docs/guides/vercel-postgres-transition-guide#compatibility-notes
https://neon.com/guides/vercel-sdk-migration

Drizzle + Neon docs: https://orm.drizzle.team/docs/connect-neon

I wanted to point this out and see if there was a transition plan in place. Will the project need a new adapter and/or update the current one? Possibly good timing to see if PlanetScale's upcoming Postgres product can be made compatible as well. Maybe a more generic "serverless client with postgres" adapter would be nice? Passing a Drizzle instance into a new adapter might allow more flexibility?

Original Discord post for reference