Open mtoy-googly-moogly opened 4 weeks ago
All that refactoring leads to this ... arrays and records working in more places. Using the word "compound" data for this, saving the word "composite" for cube-like sources.
The WN for this is https://github.com/malloydata/whatsnext/blob/main/wns/WN-0015-arrays-and-records/WN-0015.md but this is an MVP level first step. The MVP is based on avoiding some of the most common reasons Meta users are having to drop into SQL when working with compound data
Can select: a compound computation
select:
Can pass a compound computation to a function call
Literals exist for compound types
Some array functions in the standard, or presto library
[X] A query can select an array or an expression that has an array type
[x] There is an array literal
[x] You can pass arrays to functions
[X] There is a record literal
[x] A record can be selected
[x] A literal for an array of records
[x] An array of records can be selected
[x] Record in a source
[x] Array in a source
[x] Array of records in a source
[ ] Tested in all dialects
[ ] Maybe add split/join/contains for @lloydtabb
All that refactoring leads to this ... arrays and records working in more places. Using the word "compound" data for this, saving the word "composite" for cube-like sources.
The WN for this is https://github.com/malloydata/whatsnext/blob/main/wns/WN-0015-arrays-and-records/WN-0015.md but this is an MVP level first step. The MVP is based on avoiding some of the most common reasons Meta users are having to drop into SQL when working with compound data
Can
select:
a compound computationCan pass a compound computation to a function call
Literals exist for compound types
Some array functions in the standard, or presto library
[X] A query can select an array or an expression that has an array type
[x] There is an array literal
[x] You can pass arrays to functions
[X] There is a record literal
[x] A record can be selected
[x] A literal for an array of records
[x] An array of records can be selected
[x] Record in a source
[x] Array in a source
[x] Array of records in a source
[ ] Tested in all dialects
[ ] Maybe add split/join/contains for @lloydtabb