From SQLAlchemy
The CData Python Connector for SuiteCRM includes a Dialect class that enables integration with SQLAlchemy. The following sections detail various aspects of this integration:
Connecting from SQLAlchemy
See Connecting to construct a URL with which SQLAlchemy loads and uses the appropriate connector automatically.
Reflecting metadata with SQLAlchemy
Reflecting Metadata shows how to model SuiteCRM tables with mapped classes.
Querying Data from SQLAlchemy
Querying Data demonstrates how to use mapped classes to query the associated tables.
Modifying Data from SQLAlchemy
The provider provides INSERT/UPDATE/DELETE functionality in SQLAlchemy. Modifying Data shows how to affect the data in the data source by calling the session's "execute()" method.