feat: Prisma should be bumped to v 6.x.x

[8907234]

Is your feature request related to a problem? Please describe.

Prisma 6 includes various helpful things.

• cuid2 being available in @default. cuid() is deprecated for security reasons.
• Prisma client now generates typescript definitions for enums even if they aren't used in any columns.
• Full text search for postgres
• Various other things

Describe the solution you'd like to see

I think the full text search is the biggest reason for upgrading. I was forced to use MySQL for a recent project because I wanted FTS, but didn't want to be writing SQL queries in my codebase.

Describe alternate solutions

Don't upgrade and remain in the past.

Additional information

No response