If this thread flushes out the narrow set of circumstances where client_writable views are still worthwhile, and maybe leads to some documentation of best practices for using and not using client_writable views, then I will consider my work here to be done. Thank you for adding to the full picture of this feature.
My primary issue is this:
The only limitation listed on the page documenting this feature (https://anvil.works/docs/data-tables/data-security#views) is “Columns cannot be automatically added to a restricted view.” at the very end of the page.
If the real, crippling, limitations I’ve now documented were on the page, I wouldn’t be tearing out views all over the place. My hope is that this post leads to either some clear statements of limitations (Do not use client_writable views in these scenarios…) in the official docs, or serves as a cautionary sign for a developer in the future, and saves someone else the time of tearing them back out.