Has something changed in the data explorer? Can't get query via API

That is exactly what the PR aimed to do!

Options are backups, or doing pagination with

select * from table where id > (:page * 5000)

so you get it in chunks for 5k.