BabelDB - Query Anything

90 second demonstration of what is possible with BabelDB.
// Query the web - JSON / CSV / HTML
https://api3.binance.com/api/v3/ticker/price
select * from query_web('https://api3.binance.com/api/v3/ticker/price');
https://www.gov.uk/bank-holidays.json#.scotland
query_web('https://www.iso20022.org/sites/default/files/ISO10383_MIC/ISO10383_MIC.csv')

query_web('https://en.wikipedia.org/wiki/List_of_best-selling_game_consoles')
SELECT  PARSEDATETIME(Released,'yyyy') AS DATE,Platform,Firm FROM query_web('https://en.wikipedia.org/wiki/List_of_best-selling_game_consoles')
SELECT PARSEDATETIME(Released,'yyyy') AS DATE,CAST(REPLACE("Units Sold",'million','') AS FLOAT) AS Platform,Platform AS Platform_SD_MARKPOINT FROM query_web('https://en.wikipedia.org/wiki/List_of_best-selling_game_consoles') WHERE Firm LIKE 'Nintendo' ORDER BY date

show tables;
SELECT TABLE_NAME as name FROM QUERY_DB('DEMODB','show tables')
  UNION ALL SELECT * FROM QUERY_DB('play.clickhouse.com','show tables;')

FM.B.U2.EUR.4F.KR.MRR_FR.LEV:ECB
FEDFUNDS:FRED
query_sym('FM.B.U2.EUR.4F.KR.MRR_FR.LEV:ECB') 
query_sym('FEDFUNDS:FRED')

SELECT DATE,FEDFUNDS,null AS "FM.B.U2.EUR.4F.KR.MRR_FR.LEV" FROM query_sym('FEDFUNDS:FRED')
UNION ALL  (SELECT DATE,null AS FEDFUNDS,"FM.B.U2.EUR.4F.KR.MRR_FR.LEV" FROM query_sym('FM.B.U2.EUR.4F.KR.MRR_FR.LEV:ECB') )
    ORDER BY DATE  ASC 
  
SELECT *,  CASE WHEN FEDFUNDS<0.06 THEN 'LOWPOINT' ELSE null END AS FEDFUNDS_SD_MARKPOINT,
        CASE WHEN DATE>='2017-08-01' THEN 1.16 ELSE null END AS bought,
        CASE WHEN DATE<'1989-04-01' THEN 9.36 ELSE null END AS sold,
         CASE WHEN FEDFUNDS>8.89  THEN 'badtimes' ELSE null END AS FEDFUNDS_SD_MARKAREA FROM  query_sym('FEDFUNDS:FRED')

  
query_data("[{d:'2011-01-01', v:9},{d:'2011-01-02', v:6},{d:'2011-01-03', v:8},{d:'2011-01-04', v:4}]")

query_data('Date,val
2001-01-07,88
2001-01-08,99
2001-01-09,55
2001-01-10,66
2001-01-11,70
2001-01-12,75
')
BabelDB - Query Anything

See Also
