ydb/yql/essentials/tests/sql/suites/blocks/take_skip.sql

pragma warning("disable","4537");
$data = [<|x:1|>,<|x:2|>,<|x:3|>];

select * from as_table($data) limit 2;
select * from as_table($data) limit 1 offset 1;