Dependent Filter Workarounds?

This comes up rather frequently and I figure if it could be done it would have been done by now but it doesn’t hurt to ask before going down the road of building something within an embed application outside of Metabase.

Until GitHub Issue #5540 Limit the number of options displayed in a filter based on the selection of another filter is implemented (please Upvote :+1:), would something like this work?

Is there a way to change the table or view on which a filter widget is based using some criteria? Or substitute one filter widget for another based on some criteria? Perhaps using SQL, for example:

And I’m not sure if this is related or not, the last “Try It” example in the SQL editor Help section appears to link the two filter widgets even when they’re mapped to two different fields in the product table (v0.32.5, Firefox ESR 52.9.0, Win 6.0.6002):