From my past experience, I've used TypeORM and Prisma before and found that Prisma is doing great with CRUD operation, you won't need to code much to save and read the data. And the benefit of Prisma is a single entity definition will do it all. You don't need to define a type, you don't need to define a DTO. Prisma also do t the migration as well. The (little) downsides I found for Prisma were that we need to define every entity in a "single" file, we also cannot do many operations with the queried entity since it's just an object with type, you cannot manipulate it much.

In contrast with Prisma, TypeORM allows you more flexible entity definition and more advanced SQL query (TypeORM has a built-in query builder to build a custom SQL and execute with the database, Prisma has only a "raw" function to execute raw SQL.).

In conclusion, if your application is basically a CRUD operation, with no (or few) complex SQL queries, simple and few entities, I'd recommend Prisma. Its syntax is beautiful, easy-to-use, and will make you develop faster.