There was a weirdly named thing called "mybatis" around awhile ago, that had a nice balance where the SQL was contained in one place and communication into and

There was a weirdly named thing called "mybatis" around awhile ago, that had a nice balance where the SQL was contained in one place and communication into and out of it was objects, but it was actual SQL (amenable to DBA optimization) and not some library doing things for you cleverly. Not sure if it's still a thing but I'm surprised that model isn't more common.