I see this problem too. But the problem is, that HQL is really too limited for some of the stuff. And at least TIME related queries are somehow database dependent, even with HQL. What we could do is to provide a "base compatability implementation", which does the same job with "normal" HQL queries and Java-Code. This will perform much much slower I guess, but it could work portable. And the user can just configure to use the "base" version or the optimized version, if the database is supported (my plans are mySQL 5 and Oracle 10). View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4106279#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...