Hi Michael, I would suggest to look into Criteria Query API's function() method [1]. It may be the answer to the problem.
[1] The section titled "Extensible datastore expressions" in https://www.ibm.com/developerworks/java/library/j-typesafejpa/ ----- Pinaki Poddar Chair, Apache OpenJPA Project -- View this message in context: http://openjpa.208410.n2.nabble.com/Queries-using-specific-SQL-e-g-functions-or-specific-operators-passthrough-SQL-pieces-without-full-ny-tp668856p7581941.html Sent from the OpenJPA Users mailing list archive at Nabble.com.