in SqlOrderBy$Operator class, the unparse method code "offset and fetch" hardly and close the door to transform my sql to "limit x offset y style".
my unparse sql code:
the "limit 5" clause shouldn't be transformed to "FETCH NEXT 5000 ROWS ONLY".
i dive into "parser.jj" file and find the following lines in "SqlSelect()" production.
the "SqlSelect" sql node always receive null orderby, offset and fetch. so the "limit" clause will always be processed in "SqlOrderBy" sql node, and the "unparse offset and fetch" can't be processed within specific sql dialect.