Load some pages from a different Hosting

I have a domain e.g.,
https://example.com configured to use a particular hosting in DNS A records
Now I have a url path
I need to configure this path to use a different hosting
How can I achieve this

If you weren’t using Cloudflare, how would you achieve this?

With Cloudflare, you could use Workers, but it’s going to take some creative scripting. Something similar to: