PostgreSQL foreign data wrappers are a great way to expose APIs to SQL. And SQL is a great way to reason over the data.

Note: Since the node name may differ depending on your version (s) of SQL Server, the simplest way to find it is to open regedit and search for SQLDataRoot.