Where to start with Split-Horizon DNS?

Scenario:
I’ve got my LAN with subnet 192.179.0.0/24 and my Tailscale network with subnet 10.45.10.0/24. 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