YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases

Summary: YeSQL embeds rich Python scalar, aggregate, and table UDFs directly into relational plans via a pluggable architecture. Tracing JIT, UDF fusion, parallelism, statefulness, and reduced engine–VM switching deliver up to 68× speedups. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 12909
Venue: VLDB
Year: 2022
Pagerank: 5.9157364e-05
Overall Rank: 6,314 | 56.69%
DOI: 10.14778/3547305.3547328

Incoming Non-self Citations Over Time

Authors

1. Yannis Foufoulas (Athena Research Center; University of Athens)
2. Alkis Simitsis (Athena Research Center)
3. Lefteris Stamatogiannakis (University of Athens)
4. Yannis Ioannidis (Athena Research Center; University of Athens)

BibTeX Citation

@article{foufoulas_vldb22,
        title = {{YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases}},
        author = {Foufoulas, Yannis and Simitsis, Alkis and Stamatogiannakis, Lefteris and Ioannidis, Yannis},
        journal = {PVLDB},
        series = {{VLDB} '22},
        volume = {15},
        number = {10},
        pages = {2270--2283},
        doi = {10.14778/3547305.3547328},
        url = {https://doi.org/10.14778/3547305.3547328},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,015	Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL	2024	CIDR	6.008272e-05
6,253	Declarative Sub-Operators for Universal Data Processing	2023	VLDB	5.940599e-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
8,465	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	5.4194578e-05
9,415	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.2742285e-05
9,855	YeSQL: Rich User-Defined Functions without the Overhead	2022	VLDB	5.2082931e-05
9,917	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	5.1955087e-05
10,040	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	5.1723558e-05
10,072	Query Compilation Without Regrets	2024	SIGMOD	5.1624689e-05
10,740	UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines	2025	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
649	Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask	2018	VLDB	0.00015320656
894	Froid: Optimization of Imperative Programs in a Relational Database	2018	VLDB	0.00013367658
1,229	Weld: A Common Runtime for High Performance Data Analytics	2017	CIDR	0.00011578425
1,768	Tuplex: Data Science in Python at Native Code Speed	2021	SIGMOD	9.8041636e-05
1,892	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.5277793e-05
2,651	Magpie: Python at Speed and Scale using Cloud Backends	2021	CIDR	8.2918086e-05
2,684	Compiling PL/SQL Away	2020	CIDR	8.25952e-05
2,847	AIDA - Abstraction for Advanced In-Database Analytics	2018	VLDB	8.0583142e-05
3,992	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.9695338e-05
4,292	Putting Pandas in a Box	2021	CIDR	6.7784325e-05
5,791	Accelerating Python UDFs in Vectorized Query Execution	2022	CIDR	6.0873094e-05
6,328	Functional-Style SQL UDFs With a Capital 'F'	2020	SIGMOD	5.9113895e-05
6,604	Machine Learning, Linear Algebra, and More: Is SQL All You Need?	2022	CIDR	5.8240599e-05
8,674	Boosting Efficiency of External Pipelines by Blurring Application Boundaries	2022	CIDR	5.3869233e-05
9,443	Introducing a Query Acceleration Path for Analytics in SQLite3	2022	CIDR	5.2676282e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,516	Using SQL to Build New Aggregates and Extenders for Object-Relational Systems	2000	VLDB
2	1,892	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB
3	7,769	G-SQL: Fast Query Processing via Graph Exploration	2016	VLDB
4	1,264	SQL/MapReduce: A practical approach to self-describing, polymorphic, and parallelizable user-defined functions	2009	VLDB
5	4,645	User-Defined Table Operators: Enhancing Extensibility for ORDBMS	1999	VLDB
6	9,917	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB
7	10,740	UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines	2025	SIGMOD
8	5,791	Accelerating Python UDFs in Vectorized Query Execution	2022	CIDR
9	8,096	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB
10	9,855	YeSQL: Rich User-Defined Functions without the Overhead	2022	VLDB