[FEATURE] - Audit and mark macros for deprecation

[fivetran-catfritz]

We should review our macros and mark the outdated ones for deprecation. This will also require an audit of our packages to see which are using the old macros, or if they should be using a macro in place of package-specific logic or macros.