DataType JSON auto convert to String

[motionrus]

To reproduce the problem, I created a dataset from the abc table

create table public.abc
(
  source_id varchar(255) not null,
  json jsonb,
  constraint pk_source_id primary key(source_id)
);

insert into abc (source_id, json) VALUES (1, '{"key": "value"}');

then I checked that my column type was json.

and when I get an object for handlebars, I get very upset that I get a string instead of an object.

and I can't do {{this.json.key}} because there is a string in the json

{"source_id":"1","json":"{'key': 'value'}"}

[gregersn]

After digging a bit in the source code, I found that this is related to the lack of support for complex data types as can be seen here:

superset/superset/utils/core.py

Line 158 in 419d122

# ARRAY = 4 # Mapping all the complex data types to STRING for now

and here:

superset/superset/result_set.py

Line 155 in 419d122

# TODO: revisit nested column serialization once nested types

And is mentioned in related issue, here: #19388

[albuscopperplate]

would be great this to work!

[hf-13]

+1