Java Query Result To Map. If a given JPA GROUP BY query returns only two columns where one is unique its very suitable to return the result as a Java Map. If your query returns all columns that are mapped by an entity you can tell Hibernate to map the result to a managed entity.
Spring Data JPA offers you the keyword Query which allows you to write your own queries with JPQL - Java Persistence Query Language. If a given JPA GROUP BY query returns only two columns where one is unique its very suitable to return the result as a Java Map. You can use an implicit mapping if your query result uses the same column names as your entity mapping.
There are 2 options to define the mapping.
There is also another way of how you can achieve the same result using Spring Data JPA. While SqlResultSetMapping and Query annotations work on Repository classes as well we use the annotations on an Entity class in this example. NamedNativeQuery name PostTitleWithCommentCount query SELECT pid AS pid ptitle AS ptitle COUNTpc. Sql Resultset Mapping With Alias.