PrettyPrint JSON in String attributes

[dkBrazz]

Is your feature request related to a problem?

Sometimes JSON values are stored as String values instead of Map, and to examine such JSONs I need to copy text value and paste it into a JSON new scratch

In Some cases we have "xxxProperties" tables, containing mixed kinds of values in a "propertyValue" field with type "String"
For some properties it might be a boolean, int, string or a json

Describe the solution you'd like

Detection

Autodetection of json values in String attributes might be tricky, so I might be better to make it configurable

• for a DB connection I would configure a table.attributeName pattern which I expect to be save to pbe parsed as JSON (in case of parsing errors I would expect a warning in IDE)
• for a specific table view I would liket to have a toggle "autodetect JSON in Strings" which forces aggressive JSON autodetection, an all attributes in all items, including mixed attributes - part of items may have "propertyValue" unparsed, and some items having a valid JSON in "propertyValue" will show it as parsed

Viewing

• In table view it should look similar to "Map" typed attributes
• In JSON / Dynamo JSON view it might be a language injection onto a String value (https://plugins.jetbrains.com/docs/intellij/language-injection.html), Ideally - with the possibility to see it pretty-printed

Additional context

No response

[AntonShuvaev]

Thanks for the suggestion. I will consider adding this in the future.