Description
Kylin's "Inspect" page will append a LIMIT clause for queries if the query doesn't have "LIMIT";
While this will make some query be invalid because "LIMIT" not always appear in the last position. For example:
select * from KYLIN_SALES OFFSET 100 ROWS FETCH FIRST 10 ROWS ONLY
According to Calcite's SQL reference, LIMIT should be before OFFSET clause.
So, Kylin should give user the option of not append the "LIMIT".