Investigate `logfire` integration at an `httpx` and `sqlalchemy` level

**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](https://docs.pydantic.dev/logfire/integrations/httpx/#usage
) and [sqlalchemy](https://docs.pydantic.dev/logfire/integrations/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.