Per-host split DNS
Is there a way in pfSense to split DNS on a per-host basis? I have a machine that needs to get the correct DNS reply for a hostname that's otherwise being overridden globally, how can I do this? I can't tell it to use a different DNS server because I need lookups of local DHCP addresses, and I can't add the address to /etc/hosts because the resolved IP changes too often.
It's looking like I need a second DNS server which forwards to pfSense for everything except the one magic hostname, but that feels like using a sledgehammer to crack open a peanut. I'd prefer not to have to maintain a second DNS server outside of pfSense so I'm hoping that I'm just being dumb and there's someone smart out there…