ibis

Ibis provides a consistent Python dataframe API across over 20 backends, including DuckDB and BigQuery, allowing code to run anywhere with minimal changes, as highlighted in the portability section.

Automatically translates Python operations into optimized SQL for most backends, enabling scalable performance while using Python syntax, as shown in the SQL generation examples.

With interactive mode, users get immediate feedback on data manipulations, facilitating iterative exploration, demonstrated in the penguins dataset example.

Expressions are lazily evaluated, deferring computations until necessary, which can improve efficiency in complex pipelines, as mentioned in the key features.