[Core feature] Support pandas 2 in flytekit

[eapolinario]

Motivation: Why do you think this is important?

pandas 2 was released in April/2023, but it's still not supported by flytekit due to this restriction.

Goal: What should the final outcome look like, ideally?

flytekit should be able to support both major versions of the library.

Describe alternatives you've considered

None. Pandas is integral to Data Science and as time goes by we'll be forced to either update to thew new major version or add support for both versions.

Propose: Link/Inline OR Additional context

No response

Are you sure this issue hasn't been raised already?

• Yes

Have you read the Code of Conduct?

• Yes

[github-actions]

Hello 👋, this issue has been inactive for over 9 months. To help maintain a clean and focused backlog, we'll be marking this issue as stale and will engage on it to decide if it is still applicable.
Thank you for your contribution and understanding! 🙏