We use the hibernate dialect to do 'limit' queries.
BugzId: 3178