It is correct, there is a limitation for queries executed via ExecuteDataQuery method

To retrieve more than 10 000 rows Scan Queries could be used -- more details in documentation https://ydb.tech/en/docs/concepts/scan_query