We don't need to live with SQL's flaws. The language is fixable! This paper shows how pipe-structured data flow, inspired by other languages and APIs, can be added to SQL with moderate effort. The resulting language is still SQL, but it's a better SQL. It's more flexible, more extensible, and easier to use.
Instead of traditional SQL, where operations are combined into a single statement, piped SQL breaks them into a sequence of steps. For example, the query: SELECT name, price FROM products WHERE price > 10; would now be written as: products | WHERE price > 10 | SELECT name, price.
Adopting Pipe Syntax for SQL could offer several practical benefits including improved code readability and maintainability, better tooling and IDE support, and enhanced productivity. Since the new syntax is designed to simplify the process of writing, reading, and maintaining SQL queries, it could lead to faster development cycles and more intuitive query structures.
Collection
[
|
...
]