I am also working on this! I used Node a lot 5 years ago and not much since, so I'm coming up to speed on TypeScript and various other things. I'll check your stuff out. I may throw mine away.
I love a lot of things about the Node ecosystem, but the fact that being out of it for 6 to 12 months means you fall behind is not great.
The main components I used, are: NestJS with Express as an app server, KnexJS as a query builder (because people seem to not like TypeORM that much, it lacks migrations and you have to go pretty fast to custom SQL queries), NextJS for the UI.
Yeah, I totally feel you with falling behind regarding the full-stack web dev with node/react, the pace is incredible.
I started down the road with TypeORM for my starter, and I ran into several pain points. I was reading the Knex docs last night actually, heavily considering switching. I also wrote a quick `pg.ts` file to just use node-postgres directly, but the lack of migrations is just too painful. I looked at db-migrate briefly but didn't come to any conclusion.
So that's a long way of saying, I think Knex was a good choice. Provides migrations, handles connection pooling and transactions, but doesn't deviate too far from SQL.
I love a lot of things about the Node ecosystem, but the fact that being out of it for 6 to 12 months means you fall behind is not great.