Migrate SQL Query to ORM (Prisma/TypeORM)

Convert these raw SQL queries to [Prisma/TypeORM] operations with full type safety.

ORM: [Specify: Prisma, TypeORM, Sequelize, etc.]
Database: [Specify: PostgreSQL, MySQL, etc.]

Requirements:
- Convert all queries to ORM syntax
- Add proper TypeScript types
- Include relationships and joins
- Handle transactions if present
- Add error handling
- Preserve query performance characteristics
- Add comments explaining complex operations

Raw SQL queries:

[Paste your SQL queries here]

Also provide the ORM schema definition if needed, and explain any performance considerations.