v0.1.3 — Sidol

v0.1.3 — The Airtable Update & Core Resilience

This release introduces full support for Airtable as a primary data source and hardens the Sidol core engine against case-sensitivity and data type mismatches.

🚀 New Features

Airtable Connector (Full CRUD)

Airtable is now a first-class citizen in Sidol.

• Full SQL Support: SELECT, INSERT, UPDATE, and DELETE now work seamlessly against Airtable bases.
• "Database Mode": You can now mount an entire Airtable base as a database using db.use(airtable_connector). Sidol will automatically discover and route queries to any table in the base.
• Auto-Flattening: Nested Airtable structures (like Linked Records and User objects) are automatically flattened or JSON-stringified for SQL compatibility.

Core Engine Hardening

• Case Sensitivity: The router and session now preserve table casing. This is critical for case-sensitive IDs and table names (like those in Airtable and ServiceNow).
• Resilient Type Inference: The SQL engine now uses schema hints to guide pyarrow table creation, preventing crashes when data sources return mixed types (e.g., a column containing both integers and JSON error objects).

🛠️ Internal Improvements

• ConnectorContext: Standardized propagation of session metadata (timeouts, trace IDs) across all connector methods.
• Testing Standard: Introduced BaseConnectorTestCase to ensure all current and future connectors meet the same rigorous quality bar.

🐞 Bug Fixes

• Fixed a bug where table names were forced to lowercase in the registry.
• Fixed a 422 error when filtering Airtable records by the id field.
• Fixed a ruff linting issue regarding blank line whitespace and multi-statement lines.

---

Full Changelog: v0.1.2...v0.1.3

Sidol v0.1.2 — SQL for Everything

Full Changelog: v0.1.0...v0.1.2

First public release of Sidol.

What's included

• SELECT queries via DuckDB — fast, federated, in-memory
• INSERT / UPDATE / DELETE routed to connector write APIs via sqlglot
• Built-in connectors: ServiceNow, CSV, SQLite
• Extensible BaseConnector for any source
• Full type annotations (mypy strict)
• Zero ruff warnings

Install

pip install sidol

Sidol v0.1.0 — SQL for Everything

First public release of Sidol.

What's included

• SELECT queries via DuckDB — fast, federated, in-memory
• INSERT / UPDATE / DELETE routed to connector write APIs via sqlglot
• Built-in connectors: ServiceNow, CSV, SQLite
• Extensible BaseConnector for any source
• Full type annotations (mypy strict)
• Zero ruff warnings

Install

pip install sidol