Hi,

it appears that clauses like LIMIT or OFFSET are not allowed if the query is used inside a FROM clause. The following query throws an error:

SELECT * FROM ( SELECT id FROM corpus LIMIT 10 ) AS inner_table;

The error message is:

syntax error, unexpected LIMIT, expecting INTERSECT or EXCEPT or UNION or ')' in: "select *

Cheers, Viktor