Is there such thing CASE expression in JPQL?

Question

Let say there is a table:

TableA:Field1, Field2, Field3 

and associated JPA entity class

@Entity @Table(name="TableA") public class TableA{   @Id   @Column(name="Field1")   private Long id;    @Column(name="Field2")   private Long field2;    @Column(name="Field3")   private Long field3;    //... more associated getter and setter... } 

Is there any way to construct a JPQL statement that loosely translated to this SQL, ie how to translated the case expression to JPQL?

select field1, case   when field2 = 1 then 'One'   when field2 = 2 then 'Two'   else 'Other number' end, field3 from tableA; 

Answer 1

It has been added in JPA 2.0

Usage:

SELECT e.name, CASE WHEN (e.salary >= 100000) THEN 1 WHEN (e.salary < 100000) THEN 2 ELSE 0 END FROM Employee e 

Ref: http://en.wikibooks.org/wiki/Java_Persistence/JPQL_BNF#New_in_JPA_2.0