It seems like it only generates types for entities.

My dream library would be basically a generated client that looks like knex or objection but with full type-safety and mapping.

I don't like prisma that much as it takes control/power from the developer. But it can be great if you don't know SQL.

Check out zapatos[0]. Codegen tool that generates interfaces and type-safe queries from a running schema (db).

I've tried them all and this one allows me the most flexibility without abstracting much.

[0] https://github.com/jawj/zapatos