prisma.io seems to fail very quickly on even the most basic SQL types. I think if you are doing a project from scratch and you have a very vanilla data model, Prisma might make sense. However trying to pair it with an existing database, you quickly find out where all the assumptions in the abstraction break down.
Decided to go with knex + apollo-server as flexible SQL abstraction and feel it’s just at the right level.
Sidenote: Being forced to deal with a data model I built 17 years ago (and really didn’t know what I was doing) is really trying my patience not to just say “burn it down” – How many people have something still in production they wrote 17 years ago?