That's what I was referring to, wondering if anyone uses it and why. It even says "Why This is a Bad Idea" at the bottom.

Maybe for databases queried directly by users who also need to mix in API responses, and you're wrapping this all up in triggers or some other stored procedure cause you really want to use Postgres without some controller written in Python or JS.

No. (You don't want to cause blocking I/O in transactions.)

Non-blocking: https://github.com/supabase/pg_net

Impressive!

Yeah, still not sure I’d use it but a pretty interesting thing to do with the database.