[Feature] Update joins for recharge__subscription_overview.sql

[fivetran-catfritz]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

The joins of recharge__subscription_overview CTE subscriptions_charges should be simplified since we now know purchase_item_id = subscription_id for subscriptions. Update from:

    from subscriptions
    left join customers_charge_lines
        on customers_charge_lines.customer_id = subscriptions.customer_id
        and customers_charge_lines.address_id = subscriptions.address_id
        and customers_charge_lines.external_product_id_ecommerce = subscriptions.external_product_id_ecommerce

to

    from subscriptions
    left join customers_charge_lines
        on customers_charge_lines.purchase_item_id = subscriptions.subscription_id

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