SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL
Summary: Introduces pipe-structured data-flow syntax as a backwards-compatible GoogleSQL extension, avoiding a new language. Arbitrary operator ordering simplifies multi-level aggregation and subqueries while enabling incremental SQL evolution within existing ecosystems. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jeff Shute (Google)
- 2. Shannon Bales (Google)
- 3. Matthew Brown (Google)
- 4. Jean-Daniel Browne (Google)
- 5. Brandon Dolphin (Google)
- 6. Romit Kudtarkar (Google)
- 7. Andrey Litvinov (Google)
- 8. Jingchi Ma (Google)
- 9. John Morcos (Google)
- 10. Michael Shen (Google)
- 11. David Wilhite (Google)
- 12. Xi Wu (Google)
- 13. Lulan Yu (Google)
BibTeX Citation
@article{shute_vldb24,
title = {{SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL}},
author = {Shute, Jeff and Bales, Shannon and Brown, Matthew and Browne, Jean-Daniel and Dolphin, Brandon and Kudtarkar, Romit and Litvinov, Andrey and Ma, Jingchi and Morcos, John and Shen, Michael and Wilhite, David and Wu, Xi and Yu, Lulan},
journal = {PVLDB},
series = {{VLDB} '24},
volume = {17},
number = {12},
pages = {4051--4063},
doi = {10.14778/3685800.3685826},
url = {https://doi.org/10.14778/3685800.3685826},
year = {2024}
}Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,535 | Runtime-Extensible Parsers | 2025 | CIDR | 6.1828827e-05 |
| 5,547 | Beyond Relations: A Case for Elevating to the Entity-Relationship Abstraction | 2025 | CIDR | 6.1790655e-05 |
| 7,603 | GQL and SQL/PGQ: Theoretical Models and Expressive Power | 2025 | VLDB | 5.5853593e-05 |
| 9,350 | Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs | 2025 | SIGMOD | 5.2841297e-05 |
| 9,841 | Semantic Integrity Constraints: Declarative Guardrails for AI-Augmented Data Processing Systems | 2025 | VLDB | 5.2101877e-05 |
| 10,117 | Semantic Data Modeling, Graph Query, and SQL, Together at Last? | 2026 | CIDR | 5.093636e-05 |
| 10,133 | Database Research needs an Abstract Relational Query Language | 2026 | CIDR | 5.093636e-05 |
| 10,220 | Dialect-Agnostic SQL Parsing via LLM-Based Segmentation | 2026 | SIGMOD | 5.093636e-05 |
| 11,084 | Exploring Exploratory Querying | 2025 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 7 of 7 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 845 | Spanner: Becoming a SQL System | 2017 | SIGMOD | 0.00013660379 |
| 1,494 | Procella: Unifying serving and analytical data at YouTube | 2019 | VLDB | 0.00010577585 |
| 1,691 | PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS | 2004 | VLDB | 9.9999141e-05 |
| 2,602 | NL2SQL is a solved problem... Not! | 2024 | CIDR | 8.3535452e-05 |
| 2,889 | F1 Query: Declarative Querying at Scale | 2018 | VLDB | 7.9935046e-05 |
| 4,796 | A Critique of Modern SQL And A Proposal Towards A Simple and Expressive Query Language | 2024 | CIDR | 6.5031952e-05 |
| 4,907 | One SQL to Rule Them All – an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables | 2019 | SIGMOD | 6.4494002e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,409 | From Regular Expressions to Nested Words: Unifying Languages and Query Execution for Relational and XML Sequences | 2010 | VLDB |
| 2 | 1,558 | SchemaSQL - A Language for Interoperability in Relational Multi-database Systems | 1996 | VLDB |
| 3 | 10,117 | Semantic Data Modeling, Graph Query, and SQL, Together at Last? | 2026 | CIDR |
| 4 | 6,627 | Schema-free SQL | 2014 | SIGMOD |
| 5 | 9,682 | Graph Data Models, Query Languages and Programming Paradigms | 2018 | VLDB |
| 6 | 1,797 | How to Architect a Query Compiler | 2016 | SIGMOD |
| 7 | 7,603 | GQL and SQL/PGQ: Theoretical Models and Expressive Power | 2025 | VLDB |
| 8 | 10,220 | Dialect-Agnostic SQL Parsing via LLM-Based Segmentation | 2026 | SIGMOD |
| 9 | 4,907 | One SQL to Rule Them All – an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables | 2019 | SIGMOD |
| 10 | 4,796 | A Critique of Modern SQL And A Proposal Towards A Simple and Expressive Query Language | 2024 | CIDR |