Migrate off of Pendulum

[aaronsteers]

Pendulum 3.0 is abandoned and Pendulum 2.x is not compatible with newer versions of Python. It seems the best path forward is to migrate to whenever, PyArrow, or another suitable replacement.

For more context, my comments here explain in detail where the blockers are and some options to move forward:

• Chore[Python-CDK]: Bump Pendulum airbyte#47266 (comment)

[maxi297]

Grooming:

• Another benefit: support for nanoseconds
• There seems to be two things to be done:
  • Remove pendulum to be able to update to Python 3.12+
  • Benefits from the more granular precision and maybe faster
• Sources can also use pendulum directly which can prevent us from updating the Python base image. Can we do the analysis for which sources would be blocked by that?