Special handling for SQLite column of type `JSON`

sqlite-utils should detect and have specially handling for column with a JSON column. For example:

CREATE TABLE "dogs" (
  id INTEGER PRIMARY KEY,
  name TEXT,
  friends JSON 
);

Automatic Nesting

According to "Nested JSON Values", sqlite-utils will only expand JSON if the --json-cols flag is passed. It looks like it'll try to json.load all text column to test if its JSON, which can get expensive on non-json columns.

Instead, sqlite-utils should be default (ie without the --json-cols flags) do the maybe_json() operation on columns with a declared JSON type. So the above table would expand the "friends" column as expected, withoutthe --json-cols flag:

sqlite-utils dogs.db "select * from dogs" | python -mjson.tool

[
    {
        "id": 1,
        "name": "Cleo",
        "friends": [
            {
                "name": "Pancakes"
            },
            {
                "name": "Bailey"
            }
        ]
    }
]

I'm sure there's other ways sqlite-utils can specially handle JSON columns, so keeping this open while I think of more

Start with the sqlite-utils dogs.db "select * from dogs" CLI path and trace how --json-cols invokes maybe_json() for selected columns. Check how declared SQLite column types are exposed, then add coverage for automatic JSON expansion on a column declared JSON without the flag; the example query should produce nested friends values.