Where to start with Split-Horizon DNS?

I’ve got my LAN with subnet and my Tailscale network with subnet The goal is such that when on either, it resolves the domain example.com to the IP address relevant their relevant subnets. How do I realistically get this setup? I know pihole (currently running as DNS server) doesn’t allow you to have two A/AAAA records to solve this. Can adguardhome do this? I’ve found 2 other potential options, a bind9 server that uses views to solve this or have two piholes with the only difference being the example.com → (what ever subnet that DNS server is related too).

Any thoughts here is appreciated! SIdenote after figuring this out I want to write a guide here on how to do this. I’ve had headaches over this topic