Tradition syntax for limiting result set in teiid sql dialect is not supported.
select * from X limit A offset B;
It is a problem for SQL builders like JOOQ to work properly with TEIID syntax. I need to build SQL queries by some builder, but i didn't find anything suitable for TEIID SQL syntax.
JOOQ works quite good with DEFAULT dialect except for limit/offset syntax.
Are there any other ways how to build syntax correct TEIID SQL queries?
Please add this syntax support. More info here: https://groups.google.com/forum/#!topic/jooq-user/M1X6_I2JLpg