This is how I would do it: 1 table for the list of items, 1 helper table for the query column, choice components to write to the helper table (similar to choosing variables to roll up in a pivot table), a few user-specific columns associated to these choice components to filter the query column, rollups on the query column.
This approach is not at all as elegant or simple as pivot tables.
You can vote here: