I think it's generally pretty low effort to maintain a repository layer with raw SQL exposing your domain or entity objects (depending on the complexity of the

I think it's generally pretty low effort to maintain a repository layer with raw SQL exposing your domain or entity objects (depending on the complexity of the whole project), so the most aggressive I get with an ORM is something like Dapper. RepoDb also looks promising.