Dynamic queries enable users to access several different resources from a single query. These queries decrease the maintenance burden for apps that need to query various similar resources.
Some example use cases for dynamic queries include:
- An app for your support team to interact with customer data when every customer’s data is hosted on a standalone database with unique credentials.
- An admin panel to measure the health of customers’ deploys when every customer has their own tenant.
- A generic budget dashboard for client projects when every client has their own database.
Dynamic queries is live for Retool Cloud, and will be included in the next quarterly Stable release for Self-hosted.