rowid is not included in dropdown filter menus

[simonw]

For rowid tables the rowid column isn't shown in the list of filter options:

This also means if you link to e.g. ?rowid__gt=1060124 the resulting filter interface will be slightly broken: clicking the "apply" button again will lose your filter for example.

[simonw]

Example: https://v0-32.datasette.io/fixtures/infinity?rowid__gt=1

[simonw]

Weird, it looks like this was a deliberate decision:

datasette/datasette/views/table.py

Lines 590 to 592 in a9909c2

	filter_columns = columns[:]
	if use_rowid and filter_columns[0] == "rowid":
	filter_columns = filter_columns[1:]

From this commit - 52a5e95 - which closed #162

[simonw]

So I need to make sure the Link column isn't displayed in the filters, as seen in this screenshot from #162:

I'll add a test for that against this table: https://v0-32.datasette.io/fixtures/compound_primary_key