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)