Clearly this two-API solution depends on the existence of plug-ins to map both APIs to tables. ... and JSON columns. But it’s still just SQL. Can such plug-ins feasibly be built for every API?

SQL is the universal language of data, ... Sometimes, when an API response includes a complex JSON structure such as an AWS policy document, the result shows up in a JSONB column. Per-API plugins.

Visualizing the Hacker News API with HCL and SQL. feature. Jul 27, 2022 7 mins. APIs GitHub PostgreSQL.