My biggest gripes with the Airtable API for a small project that has a couple of tables with > 100 rows were around pagination and joining the data between the tables which was super slow.
My company has an Airtable competitor that has API support for SQL. It has pretty good SQL capabilities solving the issues with pagination you have in Airtable.
No joins yet between tables yet, but they are planned. (You can use lookup fields to achieve them to some extent, but that requires planning ahead and is limited).
An overview of the supported SQL syntax is here:
https://blaze.today/datablaze/docs/bsql/
No joins yet between tables yet, but they are planned. (You can use lookup fields to achieve them to some extent, but that requires planning ahead and is limited).