JSON filter fails if column contains spaces

[simonw]

Got this exception:

ERROR: conn=<sqlite3.Connection object at 0x10ea68e40>, sql = 'select Address, Affiliation, County, [Has Report], [Latest report notes], [Latest report yes], Latitude, [Location Type], Longitude, Name, id, [Appointment scheduling instructions], [Availability Info], [Latest report] from locations where rowid in (\n select locations.rowid from locations, json_each(locations.Availability Info) j\n where j.value = :p0\n ) and "Latest report yes" = :p1 order by id limit 101', params = {'p0': 'Yes: appointment required', 'p1': '1'}: near "Info": syntax error

[simonw]

Bug is here:

datasette/datasette/filters.py

Lines 149 to 165 in 42caabf

	TemplatedFilter(
	"arraycontains",
	"array contains",
	"""rowid in (
	select {t}.rowid from {t}, json_each({t}.{c}) j
	where j.value = :{p}
	)""",
	'{c} contains "{v}"',
	),
	TemplatedFilter(
	"arraynotcontains",
	"array does not contain",
	"""rowid not in (
	select {t}.rowid from {t}, json_each({t}.{c}) j
	where j.value = :{p}
	)""",
	'{c} does not contain "{v}"',

Those json_each lines should be:

select {t}.rowid from {t}, json_each([{t}].[{c}]) j