Investigate nightly build failure with AstroSDK

[utkarsharma2]

ref - https://astronomer.slack.com/archives/C059004990C/p1717074355350809

[utkarsharma2]

We build nightlies from the OSS main branch and there was a change done on OSS airflow to update the version from 2.9.0.dev0 to 2.10.0.dev0 in PR .

With the latest 1.8.0 of AstroSDK, we have this version of file astro/sql/operators/raw_sql.py -

import airflow

if airflow.__version__ >= "2.3":
    from sqlalchemy.engine.row import LegacyRow as SQLAlcRow
else:
    from sqlalchemy.engine.result import RowProxy as SQLAlcRow

In the above code snippet, version comparison is not correct, which leads to the ImportError: cannot import name 'RowProxy' from 'sqlalchemy.engine.result' and explains the recent failures:

[utkarsharma2]

Since we no longer have a incorrect version check, which was removed in PR. We can do a release for AstroSDK and it should be fixed.