I noticed under the limits section of the documentation that a query result can have no more then 1000 rows. Anything more is truncated. I am surprised to see such a low limit. Maybe I misread something?
To retrieve more than 10 000 rows Scan Queries could be used -- more details in documentation https://ydb.tech/en/docs/concepts/scan_query