#311 Incompatibilty 'sqlalchemy<2' with 'pandas>=2.2'

[Anonymous]

Originally created by: elephantum

tests/test_batch_transform_scheduling.py:38: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
datapipe/datatable.py:512: in store_chunk
    ) = self.meta_table.get_changes_for_store_chunk(data_df, now)
datapipe/datatable.py:306: in get_changes_for_store_chunk
    existing_meta_df = self.get_metadata(
datapipe/datatable.py:173: in get_metadata
    res.append(pd.read_sql_query(chunk_sql, con=con))
venv/lib/python3.10/site-packages/pandas/io/sql.py:526: in read_sql_query
    return pandas_sql.read_query(
venv/lib/python3.10/site-packages/pandas/io/sql.py:2739: in read_query
    cursor = self.execute(sql, params)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <pandas.io.sql.SQLiteDatabase object at 0x7f0e2bec7d60>
sql = <sqlalchemy.sql.selectable.Select object at 0x7f0e2b53c0a0>, params = None

    def execute(self, sql: str | Select | TextClause, params=None):
        if not isinstance(sql, str):
>           raise TypeError("Query must be a string unless using sqlalchemy.")
E           TypeError: Query must be a string unless using sqlalchemy.

venv/lib/python3.10/site-packages/pandas/io/sql.py:2671: TypeError