JPA/Hibernate Fundamentals 2023 - Lesson 9 - JPQL queries

thanks so much for the series very informative
i usually don't write the entity classes manually like i see you do here i just set the value in the persistence unit
the exclude-unlisted-classes to false
which just maps all my entities directly is that a bad approach ?

How does JPQL compare to LINQ in dotnet environment

Unfortunately the JPQL is limited to only a few functions like count, avg, min, max. At some point I had to create query (left join) and to use functions like string_agg / array_agg and the resulted query could only be a native one.

thank you, appreciate the series

Select Count(1) or Select Count(*) which one is better to use while coding