SQLAlchemy instrumentation sets `otel.library.name` as the vendor, not the library name

[simondale00]

Describe your environment

• Python 3.9.6
• opentelemetry.instrumentation.sqlalchemy==0.28b1

Steps to reproduce

Create an application that leverages SQLAlchemy and MySQL (or any vendor; I just used MySQL)
Install opentelemetry.instrumentation.sqlalchemy==0.28b1
Make a request to your backend application.
Observe the resulting spans.

What is the expected behavior?

The otel.library.name should report as opentelemetry.instrumentation.sqlalchemy.

What is the actual behavior?

The otel.library.name is the DB vendor. In my case, it's mysql:

This is super confusing when there is a separate opentelemetry.instrumentation.mysql package that I'm not using.

Additional context

Nope!