[moring]

QueryDSL (http://www.querydsl.com/) does something like this for Java. It can generate classes from tables, but even with those, all queries / statements that hit the database are manually built using a query builder to avoid syntax and type errors. I.e. no caching or automatic database updates.

[nikolasburk]

knex.js is another example of such a query builder library in the Node.js ecosystem