NobleBlocks

Research indexJournal article

QueryBrew: System-Agnostic SQL-to-SQL Query Optimization

Schmidt, Reif, Birler and 1 other

Proceedings of the VLDB Endowment1 Aug 2026

NobleIDark:/48914/w1/20261004/9A25CCA9DOI10.14778/3827998.3828048

Paywalled

The full text is at the publisher

You can read the abstract here, or open it at the publisher.

Read at the publisher

Abstract

Efficient SQL execution heavily depends on the query optimizer's ability to find efficient query plans. Existing query optimizers differ widely in their capabilities, leading to significant differences in execution complexity across many queries. In this demonstration, we present QueryBrew, a system-agnostic query optimization service that decouples the optimizer from the database engine through SQL-to-SQL rewriting. QueryBrew takes arbitrary SQL queries, refines them using the state-of-the-art Umbra optimizer, and distills the optimized execution plan back into an operator-oriented SQL representation. This allows any target SQL database, such as PostgreSQL, DuckDB, ClickHouse, or SQL Server, to inherit advanced optimization techniques, such as general unnesting, simplification, and adaptive join ordering, without modification. The QueryBrew UI lets users explore and analyze the changes made by Umbra's query optimizer and how they affect execution in the target system. SQL-to-SQL optimization can improve runtimes by more than one order of magnitude for correlated and many-join queries.

Discussion

Citations

More

Suggest a correction or report