# FugueSQL: Interoperable Python and Trino for interactive workloads

DevFeed: [FugueSQL: Interoperable Python and Trino for interactive workloads](<https://devfeed.tech/articles/fuguesql-interoperable-python-and-trino-for-interactive-workloads-8732.md>)

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

Author: Kevin Kho and Cole Bowden

Published: 2023-07-27T00: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>), [interoperability](<https://devfeed.tech/topics/interoperability.md>), [pandas](<https://devfeed.tech/topics/pandas.md>), [Code](<https://devfeed.tech/topics/code.md>), [Programming](<https://devfeed.tech/topics/programming.md>), [Back end](<https://devfeed.tech/topics/backend.md>)

Tags: [backend](<https://devfeed.tech/tags/backend.md>), [ecosystem](<https://devfeed.tech/tags/ecosystem.md>), [github](<https://devfeed.tech/tags/github.md>), [integration](<https://devfeed.tech/tags/integration.md>), [interoperability](<https://devfeed.tech/tags/interoperability.md>), [performance](<https://devfeed.tech/tags/performance.md>), [python](<https://devfeed.tech/tags/python.md>), [scale](<https://devfeed.tech/tags/scale.md>), [sql](<https://devfeed.tech/tags/sql.md>), [testing](<https://devfeed.tech/tags/testing.md>)

## AI overview

The article recaps a Trino Fest session about FugueSQL, a Python programming model that improves interoperability between Python and SQL. Fugue converts Python code into SQL for high-performance, large-scale execution on Trino, while demos show query decomposition, pandas integration, built-in extensions, and incremental unit testing before production.

## Source excerpt

Fugue may be an unfamiliar name to those in the Trino ecosystem. It's another Python tool, a programming model built to enhance interoperability between Python and SQL. On the Python side of things, it's a wrapper around common tools like pandas and Polars that convert code into SQL for high-performance, large-scale query execution. So why are we talking about it at Trino Fest? Because Fugue recently launched an integration with Trino, enabling you to write Python code that can be converted to SQL to run on a high-powered Trino backend.