JPQL: What objects contain a list of results when querying multiple columns?

Question

I am trying to do something that is easy, like a pie in PHP and Co: SELECT COUNT (x) as numItems, AVG (y) on average, ... FROM Z

In PHP, I would get a simple array, for example [{numItems: 0, average: 0}], which I could use as follows:

echo "Number of Items: " . $result[0]['numItems'];

Typically, in JPQL, you query only individual objects or individual columns and get list types, such as List<SomeEntity>or List<Long>. But what do you get when you request multiple columns?

Answer 1

Object[] ( a List<Object[]>). 4.8.1 SELECT JPA 1.0:

SELECT select_expressions, . select_expressions SELECT, Object[], SELECT select_expressions.

, SELECT. 4.8.2 SELECT:

SELECT Java . . .

SELECT NEW .

SELECT NEW com.acme.example.CustomerDetails(c.id, c.status, o.count)
FROM Customer c JOIN c.orders o
WHERE o.count > 100

Answer 2

Tuple Tuple (List<Tuple>), .