Ibis Project Blog

Python productivity framework for the Apache Hadoop ecosystem. Development updates, use cases, and internals.

Ibis for SQL Programmers Guide

Yesterday, on the Ibis documentation I published the first version of Ibis for SQL Programmers, a practical guide to how SQL concepts map onto the Ibis DSL. To be clear, all of your data will stay in a SQL engine, but you can interact with it using Ibis using Python code that can be simpler to write and also more composable and reusable. Also, Ibis statically analyzes types and expressions as you go, catching a large class of common mistakes made during SQL programming.

This will be an evolving document, so if you find something that you use commonly in SQL and would like to see it added, please reach out to us on the project issue tracker.