将NativeQuery映射到POJO

@Entity
@Table(name = "users")
public class User {
    @Id
    private Long id;
    private String name;
    private String email;
    // getters and setters
}

@Repository
public interface UserRepository extends JpaRepository<User, Long> {
    @Query(value = "SELECT * FROM users WHERE email = ?1", nativeQuery = true)
    List<User> findByEmailNative(String email);
}

@Service
public class UserService {
    @Autowired
    private UserRepository userRepository;

    public User getUserByEmail(String email) {
        List<User> users = userRepository.findByEmailNative(email);
        return users.isEmpty() ? null : users.get(0);
    }
}

@Query(value = "SELECT id as id, name as name, email as email FROM users WHERE email = ?1", nativeQuery = true)
List<User> findByEmailNative(String email);

@Query(value = "SELECT * FROM users WHERE email = ?1 LIMIT 10 OFFSET ?2", nativeQuery = true)
List<User> findByEmailNativePaged(String email, int offset);

@Transactional
public User getUserByEmail(String email) {
    // ...
}