Agree with you that the problem is more on language side, I also believe that the problem isn't as bad as it seems with the right tooling.
For example I recently discovered that I can configure PyCharm to a database. Interestingly, after I did just that, the IDE downloaded the database schema and suddenly I got highlighting, autocomplete and refactoring available (well as migrations).
Suddenly I felt like I didn't actually need an ORM.
C# seems to also have thing called LINQ I'm not as familiar with it but my understanding is that it is a language within language that can represent SQL statements. I'm guessing this might be what you're talking. Ultimately I think the solution is that:
- there's a way to efficiently express what data we need (ORM has the issue you mentioned)
- an IDE can understand this syntax so it can help with it the same as with rest of the code.
For example I recently discovered that I can configure PyCharm to a database. Interestingly, after I did just that, the IDE downloaded the database schema and suddenly I got highlighting, autocomplete and refactoring available (well as migrations).
Suddenly I felt like I didn't actually need an ORM.
C# seems to also have thing called LINQ I'm not as familiar with it but my understanding is that it is a language within language that can represent SQL statements. I'm guessing this might be what you're talking. Ultimately I think the solution is that:
- there's a way to efficiently express what data we need (ORM has the issue you mentioned)
- an IDE can understand this syntax so it can help with it the same as with rest of the code.