title: How to apply regular expression in JPQL?
body: <p>I'm using JPA (Hibernate) as the persistence layer.</p>
  
  <p>I need to add a WHERE clause based on a regular expression, 
  such some pattern are SELECT * FROM TableName where REGEXP_LIKE(ColumnName, 'Pattern'). What I get from the result is the list of string but I need to get mapped entities from the DB as an object not a string.</p>
  
  <p>From my knowledge JPQL can return the result as an object but JPQL doesn't seem to support regular expressions, as it's a propietary extension from Oracle.</p>
  
  <p>How can I apply regular expression to the JPQL?, what else should I need to know?</p>