I think you are looking for Domain Objects. These work like you mention, where the Gateway does a dns lookup for every FQDN, then caches it.
Updatable Objects work slightly differently, but on the same premise.
Some Services do not function with Domain objects, for various reasons, and we require the Updatable Objects.
These are a dynamic list of IP's that is provided as a service from Check Point. (No special licensing required)
We work with Vendors such as Zoom, Microsoft, and new vendors all the time.
They provide a list of IP's and Domains to us. -- We provide this to you, in the form of an Updatable Object.
We can see in sk163633 -- Updatable Objects for Zoom Services
"Zoom publishes a list of IP ranges and domains which are dynamically updated."
If more granular control is required, you will need to use Domain Objects, or reach out to your local SE, or TAC if this doesn't suit your needs.