fix(targets)!: Default handling of ACTIVATE_VERSION messages to soft deletes and add new SQLConnector.delete_old_versions method

[edgarrmondragon]

Related:

• Closes bug: activate_version deletes rows inserted in earlier batches (and deletes despite hard_delete not being set) #2103
• Maybe bug: target table is being reset after a successful sync, then completes without logging an error #2117

---

📚 Documentation preview 📚: https://meltano-sdk--2105.org.readthedocs.build/en/2105/

[codspeed-hq]

CodSpeed Performance Report

Merging #2105 will not alter performance

_{Comparing 2103-bug-activate_version-deletes-rows-inserted-in-earlier-batches-and-deletes-despite-hard_delete-not-being-set (a089fd1) with main (f914452)}

Summary

✅ 6 untouched benchmarks

[codecov]

Codecov Report

All modified and coverable lines are covered by tests ✅

Comparison is base (f914452) 87.84% compared to head (a089fd1) 87.89%.

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #2105      +/-   ##
==========================================
+ Coverage   87.84%   87.89%   +0.05%     
==========================================
  Files          60       60              
  Lines        4953     4958       +5     
  Branches     1007     1008       +1     
==========================================
+ Hits         4351     4358       +7     
  Misses        424      424              
+ Partials      178      176       -2     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.