So, along the years I felt sometimes like I have to relearn how to do SQL in arbitrary library X, for the sake of it.
However ORMs have an advantage: no need to change queries when adding/removing fields to the database. No need to deserialize data from resultsets. The usually migrate the database either by applying migrations to the database and infer models (Rails) or syncing the db with the model (Django). Weirdly Ecto forces the developer to both write the migration and the model.
My ideal ORM would be something that lets me write
sql("select * from employee join department
on employee.department_id = department.id
order by employee.id desc limit 10").each do |record|
puts("#{record.employee.id}, #{record.department.name}")
I don't know how that would play with static typed languages but if all ORMs would be like that we could know only SQL and be able to perform arbitrarily complex queries.