@Query(“SELECT u FROM User u LEFT JOIN FETCH u.roles WHERE u.email = :email”) Optional<User> findByEmailWithRoles(@Param(“email”) String email); I like to use mysql but this query blows my mind. After spending 3 HOURS community say me this is not sql — this is something called JPQL. But i want to use sql. Is anyone solve my […]