Major advantages provided are:
- you can choose which tables you want to expose from the admin interface: just pick the ones you need
- you can add a password to protect your data, so only you can access it
- you can select all fields (*), or just some fields to limit the columns in the output
- you can set LIMIT and OFFSET parameters to the query URL to limit the size of the data: useful for big tables
The results are sent using JSON to the requester.
Examples of what can it be used for:
- Integration with other sites
- Integrations with ecommerce tools: extract your orders!
- Create email lists
- Backup and export data
- Sync with other software or websites
- Basically any custom integration you might think of.