Hello!
We've created a way to export Airtable data with a SQL query, under one API call. It is built into our app CSV Getter for Airtable.
I've written a brief guide to show how it works.
Feedback encouraged! Happy to add new features if it is useful to any fellow Airtable users.
Best,
Gavin