Skipping on ORMs is peak boomer behavior. It's usually between Drizzle and Prisma, I personally prefer Drizzle but wanted to give Prisma another shot for this project. Prisma has a lot of stuff going for it (e.g. prisma schema files are way cleaner and easier to parse than drizzle's)
It sucked for PGVector and doesn't do well with Postgres extensions in general tho, would love if the guys over at Prisma could improve that.