Describe the new feature

This was already mentioned in other issues, but it deserves its own entry.

The editor mode of the Edit Database Cell should take advantage of the data type detection and switch automatically each time a cell is selected or a new data is imported. The user must still be able to switch the mode manually.

Subjects to discussion:

• Should we provide a way to disable the automatic switch so the user can easily navigate through the cells using a mode which is not the preferred? For example, sticking to the XML mode while viewing an SVG column or to binary mode in a text column for inspecting special characters.
• If so, how should be disabled? A checkable button besides the mode combo box? Using a wand
  (representing the automagical switch) or a lock (representing that the mode is locked to the last user selection, or not)?

Additional info

Is your feature request related to an issue? Please include the issue number.

This was already mentioned in #1438

As you DO detect what's in a cell, why not change the edit mode to match when a cell is selected?
If I click on a JPEG cell (i have one), why not make the edit mode switch to image automagically?

And in #1173

It would be great if text values are automatically checked for being parseable as JSON (if they are less than e.g. 100KB), and then the editor automatically switches to JSON.

Does this feature exist in another product or project? Please provide a link.

Probably. It isn't something revolutionary.

Do you have a screenshot? Please add screenshots to help explain your idea.

No screenshot. Use your imagination 😄