What about "SQL support for JavaScript Object Notation (JSON)"? www.iso.org/standard/67367.html<http://www.iso.org/standard/67367.html>?
There are two categories of JSON functions (8 functions) for query and for constructor, some clauses like PLAN, etc are introduced in this standard. I did not see the supports in mainstream DBs(Oracle and Sql Server) covering all of them, but IS JSON, JSON_QUERY and JSON_VALUE are both implemented SQL server support https://docs.microsoft.com/en-us/sql/relational-databases/json/validate-query-and-change-json-data-with-built-in-functions-sql-server Oracle: https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6374 MySQL and Postgres have a lot functions to handle JSON, besides JSON_OBJECT or one or two other functions, seems none of its function is standardized. https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html Postgres <https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html>https://www.postgresql.org/docs/current/static/functions-json.html While I think the scope could be self contained, if it is not suitable for this activity do we want to put this into Calcite roadmap? Best, Chunhui ________________________________ From: Julian Hyde <[email protected]> Sent: Monday, February 26, 2018 4:00:21 PM To: dev Subject: Re: Google Summer of Code 2018 Yes. > On Feb 26, 2018, at 2:32 PM, Michael Mior <[email protected]> wrote: > > Thanks Julian! Would these be some good JIRAs to tag? > > https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_CALCITE-2D1737&d=DwICAg&c=cskdkSMqhcnjZxdQVpwTXg&r=7bZjGOKpQi7qeyQ_xRpzEQ&m=LYUbb9SvNkKb5PpYzt7-eWRg5qGj9K6txN2zGGcqakg&s=KXsK-qlYTOf5W1KDQmlqjA7CIj4_CtGlmWirBlPxopI&e= > https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_CALCITE-2D1861&d=DwICAg&c=cskdkSMqhcnjZxdQVpwTXg&r=7bZjGOKpQi7qeyQ_xRpzEQ&m=LYUbb9SvNkKb5PpYzt7-eWRg5qGj9K6txN2zGGcqakg&s=6xfRRfhSus-SrVHKvEIYKzcyAaEAUJBLdHbkqjUhrRk&e= > https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_CALCITE-2D2031&d=DwICAg&c=cskdkSMqhcnjZxdQVpwTXg&r=7bZjGOKpQi7qeyQ_xRpzEQ&m=LYUbb9SvNkKb5PpYzt7-eWRg5qGj9K6txN2zGGcqakg&s=oLu_OiKf-cFe1RxcmAnv2CFW6QPGbpz5uYeiN5y3EMs&e= > > -- > Michael Mior > [email protected] > > 2018-02-26 14:46 GMT-05:00 Julian Hyde <[email protected]>: > >> Here are two areas that are self-contained and rewarding: >> * Spatial functions >> * Spark adapter >> >> Julian >> >> >> >>> On Feb 24, 2018, at 4:24 PM, Michael Mior <[email protected]> wrote: >>> >>> You have probably seen that Apache was accepted as an organization for >> this >>> year's GSoC. I thought I would see if anyone in the Calcite community can >>> think of any issues that would be a good fit. It's no guarantee we would >>> get someone to work on it, but it could be a good push to move some >>> isolated bits of functionality forward that may not get much attention >>> otherwise. >>> >>> -- >>> Michael Mior >>> [email protected] >> >>
