Skip to main content
Enumeration of supported connection types in Squirrels. For example usage, see ConnectionProperties. This enum can be imported from the squirrels.connections or the squirrels module.

​
Enum values

​
SQLALCHEMY
ConnectionTypeEnum
SQLAlchemy-based connections using standard database drivers. This is the default connection type and supports the widest range of databases.Supports placeholders in SQL queries, using :param_name syntax for named parameters.
​
DUCKDB
ConnectionTypeEnum
Native DuckDB connections for fast analytical queries. Use this for DuckDB databases and also for connecting to PostgreSQL, MySQL, and SQLite through DuckDB’s connectors.Supports placeholders in SQL queries, using $param_name syntax for named parameters.
​
CONNECTORX
ConnectionTypeEnum
ConnectorX-based connections for fast data loading from databases. Optimized for bulk data transfers but does not support placeholders in SQL queries.
​
ADBC
ConnectionTypeEnum
Arrow Database Connectivity (ADBC) connections for high-performance data transfer using Apache Arrow. Does not support placeholders in SQL queries.