Sophisticated techniques for working with complex JSON structures efficiently
Build a custom Describe Table function in postgres using File FDW
Read REST services as a local table using PostgreSQL
Regardless of what database you use, you can probably harness JSON recordsets to improve your queries.
Harnessing the power of Postgres File FDW to access system info
