very interesting, i have some doubts about the file format and json structure
the json is sometimes referred as 'new csv' file format, the problem is, what file format will connect support? for example... how we will create rows and cell with json format? or we will execute a json->xml convert and after use the xml format of connect ? some exemple of json formats

[  

  {'colum1':'value','colume2':'value'},  // row 1

  {'colum1':'value','colume2':'value'},  // row 2

  ... etc

]

check that this format allow a dynamic column use!

   {'column1':{'dinamic_colomn':1234,'blabla':234},'column2':'value'} ....

or we will use something like

{

 'columns':['column1','column2','column3' .... ],

 'rows':[

    ['a','b','c'], // row 1

    ['a','b','c'], // row 2

    ['a','b','c'], // row 3

  ]

}

we support dynamic too...

    ['a',{'dynamic_column':1234},'c'], // row 3

or any other format?

Interesting comment, Roberto. The first style is much more used, so in my opinion it is the most important one. But the second style is much more compact and it is just perfect for tables, so implementing it would be useful.

i think we could close this as duplicated of https://mariadb.com/kb/en/mariadb/connect-json-table-type/

bertrandop, I've just noticed this task. It might be already done, then you can close it at once.

The JSON table type is now supported by CONNECT. See the online documentation for details.
Note: Fix version is given as 10.0.17 but a first version of this implementation is already included in version 10.016.