On 19 Jun 2017, at 2:50pm, Robert M. Münch <robert.mue...@saphirion.com> wrote:
> Hi, I have a table A(rec_id, JSON-of-record) and I create a view like this: > > CREATE VIEW json AS SELECT rec_id, json_extract(json_value,'$.col-1') as > col1, json_extract(json_value,'$.col-2') as col2, ... , > json_extract(json_value,'$.col-50') as col50 FROM a > > > All SELECT requests will then run against the view. > > This view works and of course takes some time to build. Please supply a same SELECT command that you would use this VIEW for. I’m especially interested in clauses such as GROUP BY, ORDER BY and WHERE. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users