LiveQuery Github Suggestion

A simple example to show the "duplication" of related queries when a user needs to show intermediate results along aggregated data.

Query 1 - Uniswap V3 Ethereum router activity

Query 2 - Uniswap V3 Arbitrum router activity

Query 3 leads to a rerun of Queries 1 & 2.

If flipside API was available on LiveQuery query 3 would simplify to:

SELECT
livequery.live.udf_api('https://flipsidecrypto.xyz/edit/queries/query1_id') as response
UNION
livequery.live.udf_api('https://flipsidecrypto.xyz/edit/queries/query2_id')

For more complex queries this could lead to a meaningful reduction in the use of resources.

Query 1 - Ethereum data

Query 2 - Arbitrum Data

Query 3 - Aggregated Data