Ibis and Trino

The post discusses the integration of Ibis with Trino as a backend, highlighting the flexibility and functionality of using the Ibis DataFrame API for SQL operations. It emphasizes that while the post revisits concepts from a previous PyStarburst-focused exploration, it now employs Ibis to showcase similar SQL tasks, such as selecting, projecting, filtering, joining, and sorting tables. The author shares personal insights, comparing Ibis to PyStarburst, and notes a preference for PyStarburst due to its alignment with PySpark, although acknowledging Ibis's advantage of running the same DataFrame program across multiple SQL engines. The post also touches on the potential for performance optimization and how Ibis and PyStarburst produce similar query plans, with differences in execution highlighted as areas for further research. Despite the technical depth and exploratory nature of the work, the author expresses satisfaction with the experience and encourages further experimentation and learning through resources like Starburst Academy.