Support for LIMIT and OFFSET clause for top level SELECT and subqueries, although subqueries may only use these clauses when also defining an ORDER BY.