News for hackers. Stuff that matters.
Re:What ORMs have taught me: just learn SQL (2014) by taffer on Friday September 20, 2019 @07:45PM (#21032434)
Have you checked out MyBatis or JOOQ? They sound pretty much like what you're describing.
Re:What ORMs have taught me: just learn SQL (2014) by james_s_tayler on Friday September 20, 2019 @08:57PM (#21032768)
MyBatis has _some_ similarities, notably the defining entities in xml part. But it diverges after that.

Think about it more like MyBatis meets Spring Data JPA. Define that entity in XML the run a code gen which gives you the CrudRepository class but also generates a controller that exposes an API with pretty good good ability to specify adhoc queries. Plus view models.

I think it worked because it both reasonably well designed and hyper opinionated.