Ibis Data Interface

Ibis provides a database-agnostic Python DataFrame API. Write queries once in Python; Ibis translates them to optimized SQL for the connected backend (DuckDB, PostgreSQL, SQLite, etc.).

Why Ibis

• Portability: Develop with DuckDB, deploy against PostgreSQL -- change only the connection
• Lazy evaluation: Operations build an expression tree; nothing executes until .execute()
• Full SQL power: Window functions, CTEs, joins, aggregations -- all through Python
• No ORM: You get SQL performance without SQL strings

Connecting

import ibis

# DuckDB (default for local/parquet work)
con = ibis.duckdb.connect()
con = ibis.duckdb.connect("my.duckdb")