Google's new pipe syntax in SQL

>>heyden+(OP)
The next thing I would like is to define a function / macro that has a bunch of |> terms.

I pointed out that you can do this with shell:

Pipelines Support Vectorized, Point-Free, and Imperative Style https://www.oilshell.org/blog/2017/01/15.html

e.g.

    hist() {
      sort | uniq -c | sort -n -r
    }

    $ { echo a; echo bb; echo a; } | hist
      1 bb
      2 a

    $ foo | hist
    ...

Something like that should be possible in SQL!

>>chubot+y2a
It is, using table-valued functions (TVFs).

There's an example at the bottom of this file:

zlacker