with data AS (
-- Get data from target query
SELECT
*
FROM (
SELECT
livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/9a91915c-49fa-4c78-99db-85cf81e0521c/data/latest') as response
), lateral FLATTEN (input => response:data)
)
select * from data