The current Informix limit handler doesn't have an offset support. But Informix does.
There is a skip keyword for that. Without offset support a scrollable result will be used. I've identified the scrollable result as a performance problem in my application.
*select SKIP 10 FIRST 10 FROM table. *
I've create a custom limit handler below.
If required I'll provide a pull request on github and integrate it directly in the InformixDialect.