title: Mapping value from alias column into @Entity Class
body: <p>Is there any possible way to map value from alias column in query for my @Entity Class? For example, for this case there are new columns : first name and last name which is not exist in Transaction Table. Is there any way to map the value into Transaction @Entity Class?</p>
  
  <p>Example entity and dao</p>
  
  <p>@Entity</p>
  
  <pre><code>import java.sql.Date;
  import javax.persistence.Column;
  import javax.persistence.Entity;
  import javax.persistence.Id;
  import javax.persistence.Table;
  
  @Entity
  @Table(name="Transaction")
  public class Transaction {
      @Id
      @Column(name="customer_id")
      private String customerId;
  
      @Column(name="first_name")
      private String firstName;
  
      @Column(name="last_name")
      private String lastName;
  </code></pre>
  
  <p>@TransactionDAO</p>
  
  <pre><code>import org.springframework.data.jpa.repository.Query;
  import org.springframework.data.querydsl.QuerydslPredicateExecutor;
  import org.springframework.data.repository.PagingAndSortingRepository;
  import org.springframework.data.repository.query.Param;
  import org.springframework.stereotype.Repository;
  
  @Repository
  public interface TransactionDao extends PagingAndSortingRepository&lt;Transaction, Long&gt;,  QuerydslPredicateExecutor&lt;Transaction&gt;{
      @Query(value = "SELECT customer_id, SUBSTR (customer_name, 1, 10) as first_name, SUBSTR (customer_name, 11, 20) as last_name FROM Transaction WHERE customer_id=:#{#customerId}", nativeQuery = true)
      public List&lt;Transaction&gt; selectByTransaction(@Param("customerId") String customerId);
  
  }
  </code></pre>
  
  <p>If i use @Column annotation for first_name and last_name, there will be an error because two of that column is not existing in Transaction Table</p>