title: LIMIT in Postgres not supported in HQL?
body: <p>I am having error using the following code in Grails executing HQL to get the first 30 Item objects:</p>
  
  <pre><code> def items = Item.executeQuery('SELECT i FROM Item as i LIMIT 30 OFFSET 0')
  </code></pre>
  
  <p>my backend database is Postgres. However, I got:</p>
  
  <pre><code>org.hibernate.hql.ast.QuerySyntaxException: unexpected token: LIMIT near line 1, column ...
  </code></pre>
  
  <p>Obviously, the error tells that LIMIT is not supported by HQL. How do I make it work? In other words, how do I make HQL execute native SQL that is well supported by Postgres?</p>