How to modify max rows limit for CSV download?

I am using Metabase latest version on PostgreSQL database. In both the UI, and CSV download, there is a hard-limit of 10,000 rows. How can I increase this limit?

I have searched for this both here and on GitHub, but did not find any solution.

Any clues for this?

This is a known issue that will be fixed in the next release:

I use v0.25 with a mySQL database and indeed I get all rows downloaded (13k) but, metabase only “shows” 10.000 rows:

Is that a bug or can I change the settings somewhere how many rows are shown?

I haven´t put any limit on my sql query.