I wanted to see how far PostgreSQL extensibility could go.

Most People Think PostgreSQL Is Just a Database, but PostgreSQL is actually a programmable system. With extensions and procedural languages, it can do far more than simply store and retrieve data.

Recently I started thinking about a simple idea:

What if PostgreSQL could call REST APIs directly from SQL queries?

Instead of always relying on a backend service to act as an integration layer, some interactions with external systems might happen directly from the database.