mechatroner / RBQL

🦜RBQL - Rainbow Query Language: SQL-like query engine for (not only) CSV file processing. Supports SQL queries with Python and JavaScript expressions.
https://rbql.org
MIT License
281 stars 13 forks source link

add fold() and unfold() functions #2

Closed mechatroner closed 5 years ago

mechatroner commented 6 years ago

fold(a1) - aggregate function which should return an array of aggregated values, instead of a single value like other aggregate functions. unfold([val1, val2, ..., valN]) - should repeat output record multiple times, once for each value in the argument array. Something relative to CROSS APPLY but easier to use.