Pandas read_sql function yields an error message warning me that It's not implemented for SQLalchemy 2.0, even though I'm not using 2.0

I'm a SQLalchemy begginer and am using Pandas to create and work with databases. I was able to create a database sucessfully using a CSV file:

engine = create_engine("sqlite+pysqlite:///:memory:", echo=True, future=True)
df = pd.read_csv("<filepath>",delimiter=",")

The problem starts when I try to create a dataframe object from that same database:

sql = "SELECT * FROM teste"
df2 = pd.read_sql(sql, engine)

It doesn't work and gives me the following error:

NotImplementedError: This method is not implemented for SQLAlchemy 2.0.

This is very weird because I'm using SQLalchemy version 1.4.40. Does anyone have an idea what is going on?