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)