I am posting this in case somebody finds it useful. I created a new SQL migration with the following SQL code and I was able to fetch up to 10 000 entries with a single select.

ALTER ROLE authenticator SET pgrst.db_max_rows = 10000;
NOTIFY pgrst, 'reload config';