# Ibis: Because SQL is everywhere and so is Python

DevFeed: [Ibis: Because SQL is everywhere and so is Python](<https://devfeed.tech/articles/ibis-because-sql-is-everywhere-and-so-is-python-8722.md>)

Original publisher: [Read original article](<https://trino.io/blog/2023/07/03/trino-fest-2023-ibis.html>)

Author: Phillip Cloud, Cole Bowden

Published: 2023-07-03T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [bridge](<https://devfeed.tech/tags/bridge.md>), [bridging](<https://devfeed.tech/tags/bridging.md>), [data](<https://devfeed.tech/tags/data.md>), [performance](<https://devfeed.tech/tags/performance.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

The article presents Ibis as a lightweight Python library that bridges Python data wrangling and SQL query engines. It converts Python code into SQL for multiple engines, including Trino, allowing users to combine Python's usability with Trino's performance for large-scale queries.

## Source excerpt

The PyData stack has been described as "unreasonably effective," empowering its users to glean insights and analyze moderate amounts of data with a high level of flexibility and excellent visualization. The large-scale, production data stack using a query engine like Trino sits on the other side of the world, capable of handling petabytes and exabytes, but perhaps not integrating as seamlessly with the Python ecosystem as one would hope. SQL has been a means of bridging this gap, but we've now got an exciting solution to bridge it even better: Ibis.