Restrict view to specific columns in table

[stucork]

Update (2023): This feature has now shipped, and you can choose which columns are available in any view!

---

Original post:

Hi @zacherygrew and welcome to the forum,

You might find this linked feature request useful:

[DONE] Client-readable views on a subset of columns

Often, one must record housekeeping information in a row, e.g., transaction id for an item purchased. This is usually put in its own set of columns, separate from the columns that a user should see. Existing mechanisms can filter the rows, so that a user can see only the rows they “own”, but (unless I’m missing something) it doesn’t filter out app-private columns. But if we leave that to Python code, then we have to return the result as a list of dicts. Unfortunately, returning an accurate l…