Map SQL query data back into Java Object in Repository

You have 2 options:

1. Switch to JPQL query and use a constructor in a query like:

@Query(value = "SELECT new example.LocationDistance(location_id, distance_calculation) " +
               "FROM location ...")
List<LocationDistance> searchLocationByRadius(@Param("lat") double lat, @Param("lon") double lon, @Param("mile") double distance, @Param("limitNum") int limit); 

In this approach, you can't use cos/sin/radians functions directly as they are not supported by JPQL. Instead, you need to use JPQL function to call them, like:

function('cos', tab.column)

Or if you use hibernate, you can register a function with a hibernate dialect.

2. Switch to @SqlResultSetMapping and @NamedNativeQuery

First, you need to add @SqlResultSetMapping and @NamedNativeQuery annotations to your entity class.

@SqlResultSetMapping(
           name="myMapping",
           classes={
              @ConstructorResult(
                   targetClass=LocationDistance.class,
                     columns={
                        @ColumnResult(name="location_id"),
                        @ColumnResult(name="distance")
                        }
              )
           }
)
@NamedNativeQuery(name="Location.searchLocationByRadius", 
        resultSetMapping="myMapping", 
        query="...")
@Entity
public class Location {
  ...
}

Second, you need to add a method to your spring repository interface named exactly as the name of your @NamedNativeQuery.

@Repository
public interface LocationRepository extends JpaRepository<Location, Long> {
    List<LocationDistance> searchLocationByRadius(...);
}