feat: ORM for db migrations

[Drew-Macgibbon]

Drizzle:

Pros:

• cost reduction by bundling joins into a single query
• great ts support

Cons:

• may not be production ready (relatively new, not as battle tested)
• small development team
• documentation is not as good
• unlikely hires will know

prisma:

Pros:

• Prisma 5.0 was just released, it addresses the cold start issues
• great documentation and by far the more popular choice
• larger development team
• hires are more likely to know
• has db client GUI

Cons:

• Performing joins is not optimized, and requires multiple queries to the DB (PG Bouncer should mitigate this) it is also being worked on
• PostGIS support is a work in progress (spacial queries for location-specific functionality)

Decision

We will use Prisma, it will allow us to move faster, and by the time the cons become problematic (10k+ users) I suspect the Prisma team will have fixed the issues.