TLDR: Paper Notes - SQL Has Problems. We Can Fix Them Pipe Syntax In SQL

Date: 2024-09-03 Source: https://arpitbhayani.me/blogs/sql-has-problems-we-can-fix-them-pipe-syntax-in-sql

Overview

Explore GoogleSQL's new pipe syntax for SQL - Improves readability, extensibility, and debugging with operators like ASSERT and LOG. These are my notes based on the paper Paper Notes - SQL Has Problems.

Key Points

• pipe syntax that makes SQL more linear, extensible, and readable
• “prefix property” that allows running partial queries to see intermediate results, aiding in debugging
• experimental debugging operators (ASSERT
• The Fundamental Issues with Standard SQL: GROUP BY) doesn’t reflect the actual data flow, which begins with table scans in the FROM clause.
• The Pipe Syntax Solution: In traditional SQL, queries are typically written in a single, monolithic statement.
• The pipe syntax dramatically improves SQL’s extensibility with Table-Valued Functions (TVFs).