Unblock CI failures from scikit-learn 1.4.0, pandas 2.2.0

[charlesbluca]

Looks like the recent releases of scikit-learn 1.4.0 & pandas 2.2.0 have caused upstream failures that are blocking CI; this PR aims to resolve those:

• xfailed tpot tests on scikit-learn>=1.4 for now as it seems like most development on the original package is slowed now https://github.com/EpistasisLab/tpot/issues/1322
• unpinned SQLAlchemy to allow for 2, which is required for pandas 2.2.0
• modified test_join_reorder to pass irrespective of the resulting sort

[codecov-commenter]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Comparison is base (3ffba21) 85.56% compared to head (d0df6c5) 85.52%.

:exclamation: Your organization needs to install the Codecov GitHub app to enable full functionality.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #1295 +/- ## ========================================== - Coverage 85.56% 85.52% -0.05% ========================================== Files 77 77 Lines 4255 4256 +1 Branches 794 794 ========================================== - Hits 3641 3640 -1 - Misses 445 447 +2 Partials 169 169 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.