Migrate tRPC endpoints to Drizzle

[NiallJoeMaher]

Expected Behavior

We are trying to move from Prisma to Drizzle and have started to migrate.
There are a tonne of endpoints that need to be migrated to Drizzle.

If you want to take an endpoint, just let me know which one is below, and you can take it.

One PR per endpoint, please, since it'll make it easy to test. 🧪

[github-actions]

Hello @NiallJoeMaher, thanks for opening your first issue! your contribution is valuable to us. The maintainers will review this issue and provide feedback as soon as possible.

[JohnAllenTech]

I looked into some of these previously. Drizzle and Prismas query API dont overlap completely unfortunately. Are you happy with the querys being recreated in standard SQL?

[JohnAllenTech]

Prisma VS Drizzle docs https://www.prisma.io/docs/orm/more/comparisons/prisma-and-drizzle#:~:text=Drizzle%20exposes%20the%20underlying%20filter,by%20looking%20at%20string%20filters.

Its from Prisma so I assume theres pros aswell