Investigate logfire integration at an httpx and sqlalchemy level

[devraj]

Is your feature request related to a problem? Please describe.
@samuelcolvin and team @pydantic have released logfire which is a log observability tool built on top of pydantic.

It supports usage with httpx and sqlalchemy, this ticket is to request a review of the functionality it provides and see if there's value in integrating it into the library.

Describe the solution you'd like
The idea came to me from use cases around using this library for commercial products and that we could benefit from get some observability as the applications scale up.

Key points to consider:

• Authentication against the logfile service
• Make it an opt-in function because of performance and the fact that you need to be part of the service
• Make it an optional endpoint so the user does not have to vendor logfile in by default

Describe alternatives you've considered
NA

Additional context
Study the logfile implementation to learn about async use of logging messages with the service without affecting the performance of the framework.