In the .NET world we have Dapper (https://github.com/StackExchange/dapper-dot-net), which lets us write queries in plain old SQL. It's a very useful little library. I believe StackOverflow use it for their data access.

Example:

  var posts = connection.Query<Post>("select * from posts where user_id = @UserId", param: new { UserId = 1 });