The Automation API is just a different way to run Pulumi, it calls the CLI under the hood (e.g., see
the Python SDK). As far as I'm aware, there are no limitations. So if you have a Pulumi program that includes local Terraform modules that you can run via the Pulumi CLI, you can also run it using the Automation API.