From: arne@vajhoej.dk   
      
   On 7/10/2025 7:54 PM, Lawrence D'Oliveiro wrote:   
   > On Thu, 10 Jul 2025 19:14:13 -0400, Arne Vajhøj wrote:   
   >> Even ORM's tend to embed a language. Either SQL or something ORM   
   >> specific: EJBQL, HQL, JPQL, JDOQL, JDQL, DQL etc..   
   >   
   > ORMs are a waste of time. I’ve seen how they deal with complex queries --   
   > it’s just re-expressing the complexity of SQL in another equally complex   
   > form.   
      
   You can save a lot of code by using ORM.   
      
   Example (Groovy and JPA):   
      
   jpadata = em.createQuery("SELECT DISTINCT o FROM OrdersJPA AS o JOIN   
   FETCH o.orderLines ol", OrdersJPA.class).getResultList()   
      
   Gives you a list of order objects that each has a list of order lines   
   objects.   
      
   No magic. But the ORM framework handle sending query, reading data   
   and stuffing data into object structure. All the trivial stuff that   
   just makes the code take longer to read without providing any value.   
      
   Arne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)