spyql icon indicating copy to clipboard operation
spyql copied to clipboard

Key value json output and key value loader to emulate left joins

Open dcmoura opened this issue 3 years ago • 1 comments

Allowing to load dictionaries (e.g. key/value from json files), and in the query do dictionaries look-ups. This would cover a kind of LEFT JOIN with an equality condition. e.g.

SELECT adict[id] ... 

If id does not exist in adict , a NULL value should be returned.

dcmoura avatar Jan 03 '22 18:01 dcmoura

Consider

  • [x] creating a dict_agg aggregation function and saving output as json
  • [x] adding a command line option to load the json object into memory.

dcmoura avatar Jan 14 '22 23:01 dcmoura