This section shows the available API objects and provides more information on executing SQL to Airtable APIs.
- The add-in models Airtable entities like documents, folders, and groups as relational views, allowing you to write SQL to query Airtable data.
- Stored procedures allow you to execute operations to Airtable
- Live connectivity to these objects means any changes to your Airtable account are immediately reflected when using the add-in.
Driver will use TableNames and ViewNames connection properties to specify views of the current base. For each record in TableNames, will be generated two other views, named as "ViewName_Attachments" for exposing attachments information and "ViewName_Collaborations" for exposing collaborator information of the view. An example for this would be Sample table in Views
Collaborative Query Processing
The add-in offloads as much of the SELECT statement processing as possible to Airtable and then processes the rest of the query in memory. API limitations and requirements are also documented in this section.
See SupportEnhancedSQL for more information on how the add-in circumvents API limitations with in-memory client-side processing.