Implement sensitive data sanitization for psycopg2 instrumentation

[BuffaloWill]

Although psycopg2 uses dbapi, it does not instrument capture_parameters=True. It's therefore missing the ability for a user to enable/disable raw db.statement's.

For example, I would expect to apply the parameter similar to enable_commenter and see the raw db.statement:

Psycopg2Instrumentor().instrument(capture_parameters=True)

In my testing, I am seeing db.statements sanitized by default.

I think this is the relevant code:

opentelemetry-python-contrib/instrumentation/opentelemetry-instrumentation-psycopg2/src/opentelemetry/instrumentation/psycopg2/__init__.py

Lines 143 to 154 in e4d8f10

	dbapi.wrap_connect(
	__name__,
	psycopg2,
	"connect",
	self._DATABASE_SYSTEM,
	self._CONNECTION_ATTRIBUTES,
	version=__version__,
	tracer_provider=tracer_provider,
	db_api_integration_factory=DatabaseApiIntegration,
	enable_commenter=enable_sqlcommenter,
	commenter_options=commenter_options,
	)

[BuffaloWill]

Referencing #1543 as well

[tammy-baylis-swi]

Adding references to

• #1237 - Otel JS has implemented something similar
• Sanitization of span attribute db.statement #1376 - hard-coded statements aren't sanitized