The main advantage for ORM is security. The main disadvantage is that they often abstract away things that can impact performance heavely even if you are carefu

The main advantage for ORM is security. The main disadvantage is that they often abstract away things that can impact performance heavely even if you are careful. I love Ecto (for Elixir) as a middle ground: closer to SQL, safe, still able to leverage your client models and well integrated into the language. Examples: https://elixirschool.com/en/lessons/specifics/ecto/#querying https://elixirschool.com/en/lessons/specifics/ecto/#querying