Hi @billowy-army-68599. Thanks very much for reaching out!
I found that it is possible to achieve the desired result using the Automation API.
Short feedback:
This was a little hard to find because from the documentation it seems like the automation API is intended to be used as a drop-in replacement to the Pulumi CLI. Because of this I initially thought that I might need to have it running from within the same folder where my Pulumi stacks are(i.e., TypeScript modules). At the end I found out that I can just pass an empty program as an argument(i.e., a no-op lambda function).