[Feature] Union Feature Enhancement

[fivetran-joemarkiewicz]

Is there an existing feature request for this?

• [X] I have searched the existing issues

Describe the Feature

Apply the same union feature that is available in other packages (like the ad reporting packages) to the HubSpot package.

Describe alternatives you've considered

There are no real alternatives at the moment.

Are you interested in contributing this feature?

• [ ] Yes.
• [ ] Yes, but I will need assistance and will schedule time during your office hours for guidance.
• [ ] No.

Anything else?

No response