feat(adapter-pg): define foreign keys, use single queries

[kevinji]

☕️ Reasoning

• Foreign keys are added linking userId to the id in users with cascading delete. The delete user query can now be a single one due to cascading deletes.
• The id in sessions is deleted and the primary key replaced with sessionToken, which needs to be unique anyways. Turning it into the primary key should also speed up WHERE sessionToken queries.
• Queries that were previously a SELECT then UPDATE are now a single UPDATE to ensure atomicity. This required creating a rather ugly createParameterizedUpdate function to only join together key = $2 if it exists in the passed-in object. I was unable to figure out the right incantation of TypeScript types to make createParameterizedUpdate type-safe but happy to accept any suggestions to fix this.

🧢 Checklist

• [ ] Documentation
• [ ] Tests
• [ ] Ready to be merged

🎫 Affected issues

📌 Resources

• Security guidelines
• Contributing guidelines
• Code of conduct
• Contributing to Open Source

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
auth-docs	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Apr 26, 2024 8:23am

1 Ignored Deployment

| Name | Status | Preview | Comments | Updated (UTC) | | :--- | :----- | :------ | :------- | :------ | | **next-auth-docs** | ⬜️ Ignored ([Inspect](https://vercel.com/authjs/next-auth-docs/73wGYqhLnHRjgFqoA64Ex2dqNBz6)) | [Visit Preview](https://next-auth-docs-git-fork-kevinji-patch-2-authjs.vercel.app) | | Apr 26, 2024 8:23am |

[kevinji]

Closing due to lack of attention from reviewers and also that I've switched to using https://github.com/lucia-auth/lucia instead.