I am definitely not the person to ask there.
I have been on a couple teams that used Node. Everyone was/is still using express and various ORMs / query builders. Knex and Prisma are what I saw.
Lots of neat stuff with Zod and relatedly EdgeDB.
Have you done any backend TS? I'm curious what the best practice there is, these days.