When using the Python connector in conjunction with SQLAlchemy, we introduced a new dialect with the "_2" suffix to accommodate SQLAlchemy 2.0. For instance, the QB Python connector features a dialect named "quickbooks_2."
Previously, we utilized automap_base in the following manner:
engine = create_engine("quickbooks:///?<connection string>")
However, if the customer wishes to employ SQLAlchemy 2.0 and prevent potential errors when using automap_base, the following code should be used:
engine = create_engine("quickbooks_2:///?<connection string>")
Best answer by Ankit SinghView original