[Feature] align campaign and program with connector updates

[fivetran-jamie]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

There have been updates to the connector that the package should probably fold in:

• New fields (including = _fivetran_deleted flags) added to the program and campaign tables
• Custom columns now added to program -> let's add passthrough columns and check if we need to add them to any other models (i would guess campaign too)
• deprecated program_name field from the campaign table

Describe alternatives you've considered

don't update

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