Monkey Pipes

monkey_pipes.ipynb

This is pretty cool. One way to avoid random table names is to make it a function.

def pipe(rel, *stmts):
    for i, stmt in enumerate(stmts):
        name = f"_tlb_{i}"
        rel = rel.query(name, f"from {name} {stmt}")
    return rel

result = pipe(
    rel,
    "select species, sepal_length as sl, sepal_width as sw",
    "where sl > 4.5",
    "where sw between 3.1 and 3.5",
    "select species, avg(sl), max(sw) group by all",
    "order by 2",
    "limit 2",
)

but not as cool as overloading |