Looks like I’ve found a bug in duckdb-r which does not allow to fetch more than 122880 rows from remote quack server

https://github.com/duckdb/duckdb-r/issues/2972#issue-6040955088