Let’s assume the Player table in the database was structured as follows: The JPA Query object is smart enough to map fields ... JPA’s NamedNativeQuery annotation allows you to define raw SQL queries ...