I want my scheduled query to call an endpoint predefined by me whenever it runs and returns results

When querying the API we'll need to implement pagination by passing specific LIMIT / OFFSET parameters to the query. We want to be able to gauge the full data size in the response, even with these parameters added. Currently suggested workaround are: creating a separate SELECT count(*) FROM query create a conditional loop These are fine interim solution, but could get expensive and we'd like to be cost efficient as we scale. Thus, we'd love to have pagination natively supported via the API.

It would be great to submit contracts for decoding via an API endpoint.

Add another execution type for queries which need to be executed very frequently via the API but which execute in a few seconds.

Currently, the returned date is in the format: 2022-10-22T00:00:00+00:00 but a parameter is in the format: 2022-10-22 00:00:00 In order to minimize our datapoint usage of the API, we store the last replication key value, but because of this format mismatch, we need to convert returned dates to parameter dates.

As Dune API is launched, this opens up the possibility of having a terraform provider for it. This might not make sense for individuals. But for medium to larger teams, it might allow ease of managing multiple queries and dashboards as well as the changes made to them. I'm keen to kickstart this but want to see if there are enough interest in this ?

I want to skip needing to create a query and execute it every time I want to read a table's data.