In .NET, I think Dapper comes closest to what you are describing. It does the object mapping, but you still write the queries as SQL.

https://github.com/DapperLib/Dapper