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
- 12327
- Venue
- VLDB
- Year
- 2021
- Pagerank
- 9.2124242e-05
- Overall Rank
- 2,242 | 84.42%
- 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,930 |
User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases |
2022 |
VLDB |
5.8171482e-05 |
| 6,191 |
Accelerating Python UDFs in Vectorized Query Execution |
2022 |
CIDR |
5.1598046e-05 |
| 6,374 |
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.0874998e-05 |
| 6,694 |
WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications |
2024 |
SIGMOD |
4.9552327e-05 |
| 6,703 |
YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases |
2022 |
VLDB |
4.9514593e-05 |
| 6,863 |
Declarative Sub-Operators for Universal Data Processing |
2023 |
VLDB |
4.9003859e-05 |
| 7,407 |
An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA |
2024 |
VLDB |
4.7326045e-05 |
| 8,725 |
OneProvenance: Efficient Extraction of Dynamic Coarse-Grained Provenance From Database Query Event Logs |
2023 |
VLDB |
4.453957e-05 |
| 8,880 |
Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like? |
2025 |
VLDB |
4.4254065e-05 |
| 9,348 |
The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining |
2025 |
VLDB |
4.3504473e-05 |
| 9,765 |
The UDFBench Benchmark for General-purpose UDF Queries |
2025 |
VLDB |
4.2815042e-05 |
| 9,869 |
Are Database System Researchers Making Correct Assumptions About Transaction Workloads? |
2025 |
SIGMOD |
4.2626861e-05 |
| 9,883 |
SQL Engines Excel at the Execution of Imperative Programs |
2024 |
VLDB |
4.2594931e-05 |
| 10,099 |
PLForge: Enhancing Language Models for Natural Language to Procedural Extensions of SQL |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,423 |
Query Decorrelation in the Fabric Data Warehouse |
2025 |
SIGMOD |
4.1905499e-05 |
| 10,469 |
UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines |
2025 |
SIGMOD |
4.1905499e-05 |
| 10,802 |
Horizon: Robust Checks for SQL Migration Using LLMs |
2025 |
VLDB |
4.1905499e-05 |
| 10,998 |
Understanding and Reusing Test Suites Across Database Systems |
2024 |
SIGMOD |
4.1905499e-05 |
| 11,290 |
To UDFs and Beyond: Demonstration of a Fully Decomposed Data Processor for General Data Wrangling Tasks |
2023 |
VLDB |
4.1905499e-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 |
| 59 |
Efficiently Compiling Efficient Query Plans for Modern Hardware |
2011 |
VLDB |
0.0006445664 |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059446482 |
| 87 |
Hekaton: SQL Server’s Memory-Optimized OLTP Engine |
2013 |
SIGMOD |
0.00052844656 |
| 405 |
Massive Stochastic Testing of SQL |
1998 |
VLDB |
0.00024046204 |
| 848 |
Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask |
2018 |
VLDB |
0.00015933538 |
| 1,107 |
Froid: Optimization of Imperative Programs in a Relational Database |
2018 |
VLDB |
0.0001397627 |
| 1,457 |
Rewriting Procedures for Batched Bindings |
2008 |
VLDB |
0.00011891025 |
| 2,383 |
How to Architect a Query Compiler |
2016 |
SIGMOD |
8.9198524e-05 |
| 2,843 |
How to Architect a Query Compiler, Revisited |
2018 |
SIGMOD |
8.0334687e-05 |
| 3,085 |
Compiling PL/SQL Away |
2020 |
CIDR |
7.5960713e-05 |
| 3,298 |
Extracting Equivalent SQL from Imperative Code in Database Applications |
2016 |
SIGMOD |
7.2527707e-05 |
| 3,430 |
Demonstration of the Cosette Automated SQL Prover |
2017 |
SIGMOD |
7.0985442e-05 |
| 4,373 |
Just-in-time compilation for SQL query processing |
2013 |
VLDB |
6.2365066e-05 |
| 4,645 |
Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates |
2020 |
SIGMOD |
6.0190618e-05 |
| 4,772 |
Recurring Job Optimization in Scope |
2012 |
SIGMOD |
5.9280555e-05 |
| 4,909 |
A Method for Optimizing Opaque Filter Queries |
2020 |
SIGMOD |
5.8354189e-05 |
| 5,540 |
Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling |
2021 |
VLDB |
5.450319e-05 |
| 6,112 |
PL/SQL Without the PL |
2020 |
SIGMOD |
5.2009649e-05 |
| 6,245 |
Iterative Query Processing based on Unified Optimization Techniques |
2019 |
SIGMOD |
5.1341887e-05 |
| 6,646 |
Functional-Style SQL UDFs With a Capital 'F' |
2020 |
SIGMOD |
4.9734285e-05 |
| 7,447 |
DBridge: Translating Imperative Code to SQL |
2017 |
SIGMOD |
4.7227748e-05 |
| 8,162 |
MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates |
2020 |
SIGMOD |
4.5686903e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 1,509 |
Estimating Progress of Execution for SQL Queries |
2004 |
SIGMOD |
0.0001158945 |
| 6,703 |
YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases |
2022 |
VLDB |
4.9514593e-05 |
| 5,363 |
An In-Depth Benchmarking of Text-to-SQL Systems |
2021 |
SIGMOD |
5.5467941e-05 |
| 9,031 |
Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile |
2015 |
VLDB |
4.3998298e-05 |
| 8,580 |
Efficient Execution of User-Defined Functions in SQL Queries |
2023 |
VLDB |
4.4876382e-05 |
| 4,074 |
Processing Queries Against Database Procedures: A Performance Analysis |
1988 |
SIGMOD |
6.4711064e-05 |
| 10,469 |
UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines |
2025 |
SIGMOD |
4.1905499e-05 |
| 4,567 |
User-Defined Table Operators: Enhancing Extensibility for ORDBMS |
1999 |
VLDB |
6.0728188e-05 |
| 14,050 |
Supporting Procedural Constructs in SQL Compilers |
1996 |
VLDB |
- |
| 9,765 |
The UDFBench Benchmark for General-purpose UDF Queries |
2025 |
VLDB |
4.2815042e-05 |