The best of both worlds is something like sqlc. You write plain SQL queries and it will generate the "ORM" code for you using the queries you wrote.