Invalid SQL on array fields

[mroswell]

[mroswell]

Maybe something to do with sqlite json1 extension?

{
    "python": {
        "version": "3.9.2",
        "full": "3.9.2 (default, Feb 24 2021, 13:30:36) \n[Clang 12.0.0 (clang-1200.0.32.29)]"
    },
    "datasette": {
        "version": "0.55"
    },
    "asgi": "3.0",
    "uvicorn": "0.13.3",
    "sqlite": {
        "version": "3.34.0",
        "fts_versions": [
            "FTS5",
            "FTS4",
            "FTS3"
        ],
        "extensions": {
            "json1": null
        },
        "compile_options": [...]
      }
}

[simonw]

The workaround here was to rename the columns to not have a space in them - but it turns out the bug is fixed in Datasette (but not released yet), see simonw/datasette#1239