[Feature]: Allow built-in request authentication helpers to be used

[edgarrmondragon]

Feature scope

Taps (catalog, state, stream maps, etc.)

Description

Some of these are nice, and would at least remove from duplication on our side:

• requests.auth.HTTPBasicAuth(username, password)
  Attaches HTTP Basic Authentication to the given Request object.

• requests.auth.HTTPProxyAuth(username, password)
  Attaches HTTP Proxy Authentication to a given Request object.

• requests.auth.HTTPDigestAuth(username, password)
  Attaches HTTP Digest Authentication to the given Request object.

https://requests.readthedocs.io/en/latest/api/#authentication

Custom authenticators are also interesting, and developers would be able to leverage existing auth packages in the wild:

• https://github.com/tedder/requests-aws4auth
• https://github.com/pyauth/requests-http-signature
• https://github.com/Colin-b/requests_auth

https://requests.readthedocs.io/en/latest/user/advanced/#custom-authentication

---

The implementation seems easy enough as we already did most of the work in #842. We'd only need to add a __call__ method to the base auth class:

class APIAuthenticatorBase:
    def __call__(self, request):
        return self.authenticate_request(request)

and also set the auth attribute of the session:

class RESTStream:
    def build_prepared_request(
        self,
        *args: Any,
        **kwargs: Any,
    ) -> requests.PreparedRequest:
        ...
        self.requests_session.auth = self.authenticator
        return self.requests_session.prepare_request(request)