Explore renaming/enhancing opentelemetry-helpers-sql-obfuscation gem

[hannahramadan]

Currently, the opentelemetry-helpers-sql-obfuscation gem contains the logic for SQL sanitation; the name of this gem reflects this. However, there are additional instances where shared logic would be helpful for db instrumentations.

This idea came up in context of adding a new attribute to db spans, where currently logic is duplicated across db instrumentations to parse SQL statements for the db collection/table name and add it to a span [context].

We should consider what it takes to rename the obfuscation gem to something more broad, such as sql-processor, and refactoring shared logic in db instrumentations to make use of this gem.

[scbjans]

hi @hannahramadan,
previously we did something similar with the resource detectors:

1. create the new gem, add to CI etc.
2. update the old gem, setting a post_install_message stating the old gem is deprecated and point users to the new gem (e.g. refactor: split resource_detectors into their own gems. #639 )
3. update codebase to make sure new gem is used
4. clean up (e.g Remove opentelemetry-resource_detectors all-in-one gem #659 )