From: ldo@nz.invalid   
      
   On Fri, 11 Jul 2025 19:43:59 -0400, Arne Vajhøj wrote:   
      
   > The main point of ORM is to avoid boilerplate code like iterating and   
   > result sets and stuff them into the object data structure.   
      
   Those are just up to the DB API, taking advantage of features of the   
   language. Like the query iterator I posted elsewhere.   
      
   The point of the ORM is supposed to be to get away from SQL altogether,   
   and let you operate in terms of language-native objects.   
      
   > Some ORM's operate with a dirty concept and automatically save changed   
   > objects.   
      
   How do you map between OO objects and SQL tables? That’s called the   
   “impedance mismatch”, which tends to cause more problems than it solves.   
      
   > Some ORM's provide identical syntax for doing things even though the   
   > underlying databases have different SQL syntax for it, which help making   
   > the application more portable.   
      
   More commonly you want to support different programming languages   
   accessing the same back-end DBMS containing the common enterprise-wide   
   data, rather than move a program between different back-end DBMSes. ORMs   
   are language-specific, so they don’t help with that.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)