Select from ITEMS() - Githubissues

tastott / jsoql

A SQL-like language for querying JSON data

http://tastott.github.io/jsoql

3 stars 1 forks source link

Select from ITEMS() #100

Closed tastott closed 8 years ago

tastott commented 8 years ago

ITEMS() is the aggregate function which returns an array of the items in the group. It should be possible to use ITEMS() in a FROM clause like so:

SELECT
   Blah,
   (SELECT Thing FROM ITEMS()) AS Things //Transform original items
FROM
   'file://...'
GROUP BY
   Blah