Supporting Procedural Constructs in SQL Compilers
Summary: Extends an SQL compiler to natively support SQL/PSM-like procedural blocks (BEGIN/END, locals, assignments, conditionals, loops) in a single execution plan, with minimal host-compiler changes. No separate interpreter: procedural control is compiled into a unified plan, with locals as internal host vars to enable cross-boundary optimizations and reduce overhead. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 0 of 0 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,679 | Precision Performance Surgery for PostgreSQL: LLVM-based Expression Compilation, Just in Time | 2016 | VLDB | 4.6806834e-05 |
| 8,010 | Compiling Query Constraints | 1994 | PODS | 4.6065603e-05 |
| 8,626 | Adaptive Code Generation for Data-Intensive Analytics | 2021 | VLDB | 4.4829152e-05 |
| 14,085 | Procedures in Object-Oriented Query Languages | 1995 | VLDB | - |
| 3,080 | Compiling PL/SQL Away | 2020 | CIDR | 7.603389e-05 |
| 9,884 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB | 4.2635782e-05 |
| 2,838 | How to Architect a Query Compiler, Revisited | 2018 | SIGMOD | 8.0408472e-05 |
| 2,383 | How to Architect a Query Compiler | 2016 | SIGMOD | 8.9294108e-05 |
| 4,376 | Just-in-time compilation for SQL query processing | 2013 | VLDB | 6.2424797e-05 |
| 2,237 | Procedural Extensions of SQL: Understanding their usage in the wild | 2021 | VLDB | 9.2212748e-05 |