What is the unique thing they offer that no other company can offer?

Prisma, being the most popular ORM at the moment, gives you a lot of leverage and opportunities for vertical integration

More popular than Hibernate and Entity Framework (both free)?

I doubt it.

Popular in the Typescript/Javascript world.

So basically, it's just a deployment-ready synergy provider?

Typescript code generation from db :)