Although JPQL is an object-based query language, it is strongly tied to SQL. In fact, all JPQL queries are translatable to SQL in one way or another.
So, the question is, is there a way for your query:
"select object(value) from Value value where value.asString like :param"
To logically translate to SQL in your database?
If not, we will have to find a non-JPQL solution to your issue.
[Message sent by forum member 'tware' (tware)]
http://forums.java.net/jive/thread.jspa?messageID=217352