Support Semi-structured Data Types (like json format)

[BohuTANG]

Discussed in #3911

^{Originally posted by ZhiHanZ January 19, 2022}
clickhouse json format is especially helpful for logging and monitoring application and we could support it
https://clickhouse.com/docs/en/interfaces/formats/#jsoneachrow
https://clickhouse.com/docs/en/sql-reference/functions/json-functions/
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

[BohuTANG]

If we support Semi-structured Data Types like snowflake :
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

We can make the functions more powerful and streamlined, for example, clickhouse URLS functions:
https://clickhouse.com/docs/en/sql-reference/functions/url-functions/

We can only use a parse_url -> Object to do all the URLS function in clickhouse:

select parse_url('https://github.com:80/repo/trunck');
{   "fragment": null,   "host": "github.com",   "parameters": null,   "path": "repo/trunck",   "port": "80",   "query": null,   "scheme": "https" }

select parse_url('https://github.com:80/repo/trunck'):scheme;
"https"

select parse_url('https://www.snowflake.com/'):host;
"github.com"

select parse_url('https://www.snowflake.com/'):port;
"80"

[ZhiHanZ]

interesting papers:
https://db.in.tum.de/people/sites/durner/papers/json-tiles-sigmod21.pdf

[b41sh]

/assignme