Ibis

Ibis is a Python library that provides a unified, pandas-like interface for data manipulation across multiple backends, including DuckDB, BigQuery, Snowflake, and PostgreSQL. Its goal is to allow users to write code once and execute it on any backend, abstracting away the differences between SQL dialects and local processing engines. Ibis is an excellent choice for data engineers who need to build portable data pipelines that can run on various data warehouses and local engines without changing the underlying logic.