This looks great and should surely cover most of the CRUD needs of simpler apps and hopefully even more.
On the other hand, in my experience such complicated abstractions eventually leak, especially due to the complicated nature of the relational model and modern SQL.
For developers not keen on adding a thick indirection layer between the app and the DB, I have been trying to make raw SQL easier and more reliable to use directly in TS with PgTyped[1].
In general, I think most people are more than glad to use raw SQL solution instead of a mapper as long as it has:
1) Realtime parameter/result type inference in their language of choice.
2) Has autocomplete and validation in their IDE
3) Is composable, allowing to join queries/sub-queries..
So far I have been able to implement SQL-in-TS type inference in PgTyped[1] with autocomplete and validation on the way.