[clscott]

Postgres calls these foreign data wrappers (FDW)

https://wiki.postgresql.org/wiki/Foreign_data_wrappers

[refset]

Steampipe demonstrates a rather impressive range of scenarios for using FDWs + SQL in place of more traditional ETL and API integrations: https://steampipe.io/

[banku_brougham]

I like this when I tried it out. The AWS API plugin was neat, query resources with SQL.

However, I like to limit my toolset to three things, these days thats duckdb, julia for analysis side, and... OK two things.

Oh yeah Trino for our distributed compute.