Soul has migrated to Prisma 🎉

[lws803]

We've made a pretty big decision lately, to migrate from TypeORM to Prisma. Prisma is a next-gen ORM that is simple to use and strongly-typed, making it a lot less ambiguous for crafting queries and retrieving types especially for querying relations.

This move involved a number of stages:

1. Introspect database and clean up generated Prisma schema
2. Move individual services / suites to Prisma incrementally
3. Move migrations source of truth to Prisma, Prisma baselining
4. Deprecate all existing use cases of TypeORM (including entities, packages, etc)

Some things worth revisiting in the future:

JSONValues are currently manually type-casted into UserRole or string and can be a dangerous assumption. We'll need to find a better way to coerce this into the required type in a safe manner in future.

Several existing features were also deprecated in the process:

1. "Ability to associate a user connection to a specific platform." This feature is not in use and might not really make sense at the moment since user connections are universal. It is up to the platform owner to decide if the user can see more information (feed, metadata, etc) on their platform depending on their follow status.