From: ldo@nz.invalid   
      
   On Mon, 28 Jul 2025 22:36:59 -0400, Arne Vajhøj wrote:   
      
   > Even with ORM you need to express the query.   
      
   So a lot of the stuff in SQLAlchemy is useless, then?   
      
   > JPQL example (ORM specific query language):   
   >   
   > List res = em.createQuery("SELECT o FROM T1 AS o WHERE o.f > 0",   
   > T1.class).getResultList();   
      
   That seems like a really dumb idea. You see my point about having   
   their own query language does nothing to simplify the code.   
      
   > The big difference in the above two examples compared to traditional   
   > SQL API (JDBC and ADO.NET for Java and .NET) is that it return a   
   > List instead of a generic result like List.   
      
   Is there a version that returns an iterator? Can be more   
   memory-efficient for dealing with lots of returned records.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)