Skip to main content

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>")

Thanks for sharing, @Venu!


Reply