[Feature] JSON SQL Datatype

[Razikus]

What would you like to be added or enhanced Add the SQL JSON Datatype

Why is this needed This will allow user to have dynamic schema of values in SQL approach.

Now you have to switch between KV store and SQL, or have column as VARCHAR, always parse JSON and search in it by yourself. Querying a JSON column should be a lot more efficient than this.

Additional context Postgres documentation https://www.postgresql.org/docs/current/datatype-json.html https://www.postgresql.org/docs/9.5/functions-json.html

MySQL https://dev.mysql.com/doc/refman/8.0/en/json.html

[jeroiraz]

Thanks @Razikus!