Starting new Next.js project and stuck on database layer

Prisma has great DX but heavy? Drizzle lighter but steeper learning?

Maybe just raw SQL for performance??

Team is mid-size, need something maintainable

What working best for you in production?