Last tested: March 2021
You might want the behavior of
sql_always_where to apply the view level rather than the explore level.
In that case, you can:
Build a derived table with the desired WHERE clause,
or use a sql_table_name like:
sql_table_name: (SELECT * FROM table WHERE X != 0) ;;
It is a feature request to be able to do this natively/with a parameter.
This content is subject to limited support.