Upgrade to Prisma 6

[xndyz]

Prisma 6 came with a lot of improvements, any reason we can't upgrade it to 6?

┌─────────────────────────────────────────────────────────┐
│  Update available 5.4.2 -> 6.0.1                        │
│                                                         │
│  This is a major update - please follow the guide at    │
│  https://pris.ly/d/major-version-upgrade                │
│                                                         │
│  Run the following to update                            │
│    yarn add --dev prisma@latest                         │
│    yarn add @prisma/client@latest                       │
└──────────────────────────────────

Also, after making the upgrade can we easily patch it with Blitz CLI?

[siddhsuresh]

hey @xndyz thanks for the issue! I do not see any issues with the upgrade to 6.0.1, since we do not use it directly internally in blitz.

Let me know if you face any issues.

PS. Opened #4400 to upgrade the version used internally in the codebase