Is there a database that does the WHERE deleted=null for you?
Like, some way to create a special column that makes it so every query to that table automatically has a certain filter unless you use some other keyword to override it?
Like, some way to create a special column that makes it so every query to that table automatically has a certain filter unless you use some other keyword to override it?
Here is the syntax for Snowflake. CREATE MATERIALIZED VIEW mymv COMMENT='filtered view' AS SELECT * FROM mytable WHERE isdeleted=0;
not = NULL!!!
deleted IS NULL OR LOWER(deleted) = 'null'