Back to papers
Procedural Extensions of SQL: Understanding their usage in the wild
Summary: Empirical study of procedural SQL usage across workloads—procedures, UDFs, triggers—reveals magnitude and complexity. SQL-ProcBench: a real-workload benchmark for procedural SQL; cross-engine experiments expose research challenges and opportunities.
(summarized by gpt-5-nano on Feb 09 2026)
- Paper ID
- 12326
- Venue
- VLDB
- Year
- 2021
- Pagerank
- 9.2212748e-05
- Overall Rank
- 2,237 | 84.44%
- DOI
-
10.14778/3457390.3457402
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 19 of 19 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 4,924 |
User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases |
2022 |
VLDB |
5.822682e-05 |
| 6,189 |
Accelerating Python UDFs in Vectorized Query Execution |
2022 |
CIDR |
5.1647573e-05 |
| 6,375 |
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 |
5.0923872e-05 |
| 6,692 |
WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications |
2024 |
SIGMOD |
4.9599916e-05 |
| 6,701 |
YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases |
2022 |
VLDB |
4.9561066e-05 |
| 6,863 |
Declarative Sub-Operators for Universal Data Processing |
2023 |
VLDB |
4.905092e-05 |
| 7,408 |
An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA |
2024 |
VLDB |
4.7371479e-05 |
| 8,729 |
OneProvenance: Efficient Extraction of Dynamic Coarse-Grained Provenance From Database Query Event Logs |
2023 |
VLDB |
4.4582221e-05 |
| 8,884 |
Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like? |
2025 |
VLDB |
4.4283999e-05 |
| 9,343 |
The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining |
2025 |
VLDB |
4.3546206e-05 |
| 9,763 |
The UDFBench Benchmark for General-purpose UDF Queries |
2025 |
VLDB |
4.2856106e-05 |
| 9,870 |
Are Database System Researchers Making Correct Assumptions About Transaction Workloads? |
2025 |
SIGMOD |
4.2667743e-05 |
| 9,884 |
SQL Engines Excel at the Execution of Imperative Programs |
2024 |
VLDB |
4.2635782e-05 |
| 10,099 |
PLForge: Enhancing Language Models for Natural Language to Procedural Extensions of SQL |
2026 |
SIGMOD |
4.1945683e-05 |
| 10,412 |
Query Decorrelation in the Fabric Data Warehouse |
2025 |
SIGMOD |
4.1945683e-05 |
| 10,459 |
UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines |
2025 |
SIGMOD |
4.1945683e-05 |
| 10,796 |
Horizon: Robust Checks for SQL Migration Using LLMs |
2025 |
VLDB |
4.1945683e-05 |
| 10,995 |
Understanding and Reusing Test Suites Across Database Systems |
2024 |
SIGMOD |
4.1945683e-05 |
| 11,288 |
To UDFs and Beyond: Demonstration of a Fully Decomposed Data Processor for General Data Wrangling Tasks |
2023 |
VLDB |
4.1945683e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 22 of 22 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 60 |
Efficiently Compiling Efficient Query Plans for Modern Hardware |
2011 |
VLDB |
0.00064439773 |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059038975 |
| 87 |
Hekaton: SQL Server’s Memory-Optimized OLTP Engine |
2013 |
SIGMOD |
0.00052389723 |
| 406 |
Massive Stochastic Testing of SQL |
1998 |
VLDB |
0.00024053686 |
| 853 |
Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask |
2018 |
VLDB |
0.00015940507 |
| 1,108 |
Froid: Optimization of Imperative Programs in a Relational Database |
2018 |
VLDB |
0.00013984276 |
| 1,456 |
Rewriting Procedures for Batched Bindings |
2008 |
VLDB |
0.00011899772 |
| 2,383 |
How to Architect a Query Compiler |
2016 |
SIGMOD |
8.9294108e-05 |
| 2,817 |
Recurring Job Optimization in Scope |
2012 |
SIGMOD |
8.0677653e-05 |
| 2,838 |
How to Architect a Query Compiler, Revisited |
2018 |
SIGMOD |
8.0408472e-05 |
| 3,080 |
Compiling PL/SQL Away |
2020 |
CIDR |
7.603389e-05 |
| 3,296 |
Extracting Equivalent SQL from Imperative Code in Database Applications |
2016 |
SIGMOD |
7.2596583e-05 |
| 3,432 |
Demonstration of the Cosette Automated SQL Prover |
2017 |
SIGMOD |
7.1008151e-05 |
| 4,376 |
Just-in-time compilation for SQL query processing |
2013 |
VLDB |
6.2424797e-05 |
| 4,648 |
Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates |
2020 |
SIGMOD |
6.0247446e-05 |
| 4,909 |
A Method for Optimizing Opaque Filter Queries |
2020 |
SIGMOD |
5.8338804e-05 |
| 5,530 |
Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling |
2021 |
VLDB |
5.4554282e-05 |
| 6,108 |
PL/SQL Without the PL |
2020 |
SIGMOD |
5.2059662e-05 |
| 6,245 |
Iterative Query Processing based on Unified Optimization Techniques |
2019 |
SIGMOD |
5.1391202e-05 |
| 6,645 |
Functional-Style SQL UDFs With a Capital 'F' |
2020 |
SIGMOD |
4.978205e-05 |
| 7,448 |
DBridge: Translating Imperative Code to SQL |
2017 |
SIGMOD |
4.7273104e-05 |
| 8,158 |
MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates |
2020 |
SIGMOD |
4.5730772e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 1,512 |
Estimating Progress of Execution for SQL Queries |
2004 |
SIGMOD |
0.00011597041 |
| 6,701 |
YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases |
2022 |
VLDB |
4.9561066e-05 |
| 5,353 |
An In-Depth Benchmarking of Text-to-SQL Systems |
2021 |
SIGMOD |
5.5521332e-05 |
| 9,029 |
Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile |
2015 |
VLDB |
4.4040532e-05 |
| 8,583 |
Efficient Execution of User-Defined Functions in SQL Queries |
2023 |
VLDB |
4.4919445e-05 |
| 4,071 |
Processing Queries Against Database Procedures: A Performance Analysis |
1988 |
SIGMOD |
6.4763928e-05 |
| 10,459 |
UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines |
2025 |
SIGMOD |
4.1945683e-05 |
| 4,569 |
User-Defined Table Operators: Enhancing Extensibility for ORDBMS |
1999 |
VLDB |
6.0782978e-05 |
| 14,036 |
Supporting Procedural Constructs in SQL Compilers |
1996 |
VLDB |
- |
| 9,763 |
The UDFBench Benchmark for General-purpose UDF Queries |
2025 |
VLDB |
4.2856106e-05 |