Snakes on a Plan: Compiling Python Functions into Plain SQL Queries
Summary: ByePy compiles Python functions with arbitrary control flow into plain recursive SQL:1999 queries, allowing a single database query to run the entire function. Single-query execution eliminates Python-DB back-and-forth and yields up to 10x speedups. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Name withheld (University of Tübingen)
- 2. Name withheld (University of Tübingen)
- 3. Name withheld (University of Tübingen)
BibTeX Citation
@inproceedings{withheld_sigmod22,
title = {{Snakes on a Plan: Compiling Python Functions into Plain SQL Queries}},
author = {withheld, Name and withheld, Name and withheld, Name},
series = {{SIGMOD} '22},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3514221.3520175},
url = {https://dl.acm.org/doi/10.1145/3514221.3520175},
year = {2022}
}Incoming Citations (Sorted by Pagerank)
Showing 7 of 7 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,253 | Efficient and Portable Einstein Summation in SQL | 2023 | SIGMOD | 6.8029311e-05 |
| 6,614 | Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine | 2025 | SIGMOD | 5.8216658e-05 |
| 8,096 | Efficient Execution of User-Defined Functions in SQL Queries | 2023 | VLDB | 5.4875738e-05 |
| 9,456 | QURE: AI-Assisted and Automatically Verified UDF Inlining | 2025 | SIGMOD | 5.2643416e-05 |
| 10,040 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB | 5.1723558e-05 |
| 10,680 | Ultraverse: An Efficient What-if Analysis Framework for Software Applications Interacting with Database Systems | 2025 | SIGMOD | 5.093636e-05 |
| 11,275 | Hardware-Efficient Data Imputation through DBMS Extensibility | 2024 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 894 | Froid: Optimization of Imperative Programs in a Relational Database | 2018 | VLDB | 0.00013367658 |
| 1,118 | The POSTGRES Data Model | 1987 | VLDB | 0.00012104924 |
| 2,684 | Compiling PL/SQL Away | 2020 | CIDR | 8.25952e-05 |
| 2,939 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD | 7.9395908e-05 |
| 3,257 | One WITH RECURSIVE is Worth Many GOTOs | 2021 | SIGMOD | 7.590651e-05 |
| 5,828 | PL/SQL Without the PL | 2020 | SIGMOD | 6.073983e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,000 | Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling | 2021 | VLDB |
| 2 | 6,314 | YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases | 2022 | VLDB |
| 3 | 9,855 | YeSQL: Rich User-Defined Functions without the Overhead | 2022 | VLDB |
| 4 | 8,636 | Adaptive Code Generation for Data-Intensive Analytics | 2021 | VLDB |
| 5 | 10,040 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB |
| 6 | 4,452 | Just-in-time compilation for SQL query processing | 2013 | VLDB |
| 7 | 3,257 | One WITH RECURSIVE is Worth Many GOTOs | 2021 | SIGMOD |
| 8 | 5,828 | PL/SQL Without the PL | 2020 | SIGMOD |
| 9 | 5,791 | Accelerating Python UDFs in Vectorized Query Execution | 2022 | CIDR |
| 10 | 2,684 | Compiling PL/SQL Away | 2020 | CIDR |