I don't agree. Extra layers of abstraction like Prisma / ORMs only add complexity.

Sure it means you don't have to learn SQL at all, and that's really the only advantage. But time spent learning an API/ORM is better spent learning SQL.