My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to ...

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