Support PEP 561 to all packages

[Kludex]

This issue tracks work on supporting PEP 561 on the opentelemetry-python-contrib packages.

Important

Having #3116 merged, or an alternative proposed would help us a lot here.

Package	PEP 561	Pull Requests
opentelemetry-instrumentation-aio-pika	❌
opentelemetry-instrumentation-aiokafka	❌
opentelemetry-instrumentation-aiohttp-client	❌
opentelemetry-instrumentation-aiohttp-server	❌
opentelemetry-instrumentation-aiopg	❌
opentelemetry-instrumentation-asgi	❌
opentelemetry-instrumentation-asyncio	❌
opentelemetry-instrumentation-asyncpg	❌
opentelemetry-instrumentation-aws-lambda	❌
opentelemetry-instrumentation-boto	❌
opentelemetry-instrumentation-boto3sqs	❌
opentelemetry-instrumentation-botocore	❌
opentelemetry-instrumentation-cassandra	❌
opentelemetry-instrumentation-celery	❌
opentelemetry-instrumentation-click	❌
opentelemetry-instrumentation-confluent-kafka	❌
opentelemetry-instrumentation-dbapi	❌	#3068 (🙏)
opentelemetry-instrumentation-django	❌
opentelemetry-instrumentation-elasticsearch	❌
opentelemetry-instrumentation-falcon	❌
opentelemetry-instrumentation-fastapi	❌
opentelemetry-instrumentation-flask	❌
opentelemetry-instrumentation-grpc	❌
opentelemetry-instrumentation-httpx	❌
opentelemetry-instrumentation-jinja2	❌	#3137 (🙏)
opentelemetry-instrumentation-kafka-python	❌
opentelemetry-instrumentation-logging	❌
opentelemetry-instrumentation-mysql	❌
opentelemetry-instrumentation-mysqlclient	❌
opentelemetry-instrumentation-pika	❌
opentelemetry-instrumentation-psycopg	❌	#3067 (🙏)
opentelemetry-instrumentation-psycopg2	❌
opentelemetry-instrumentation-pymemcache	❌
opentelemetry-instrumentation-pymongo	❌	#3136 (🙏)
opentelemetry-instrumentation-pymysql	❌
opentelemetry-instrumentation-pyramid	❌	⚠️ Last release was August 2023!
opentelemetry-instrumentation-redis	✅	#3110
opentelemetry-instrumentation-remoulade	❌
opentelemetry-instrumentation-requests	❌	#3135
opentelemetry-instrumentation-sqlalchemy	❌
opentelemetry-instrumentation-sqlite3	❌	#3133 (🙏)
opentelemetry-instrumentation-starlette	✅	#3045
opentelemetry-instrumentation-system-metrics	❌	#3132 (🙏)
opentelemetry-instrumentation-threading	❌	#3116
opentelemetry-instrumentation-tornado	❌
opentelemetry-instrumentation-tortoiseorm	❌
opentelemetry-instrumentation-urllib	❌	#3131 (🙏
opentelemetry-instrumentation-urllib3	❌	#3130 (🙏)
opentelemetry-instrumentation-wsgi	❌	#3129 (🙏 )
opentelemetry-distro	✅
opentelemetry-instrumentation	✅
opentelemetry-util-http	❌	#3127 (🙏 )

🙏 : Review wanted.

Notes

1. opentelemetry-instrumentation already has a py.typed, but it's missing a lot of type hints. I've opened Improve type hints in opentelemetry.instrumentation.utils #3128 to help a bit there, but we need a type checker to be more efficient.
2. Add type checker #3116 contains the ty.typed for threading and the type checker PR. Happy to separate if wanted.