Require WHERE Clause
There are countless stories about people forgetting the WHERE clause in an UPDATE or DELETE and losing data. In queries, not using WHERE can also cause performance issues.
If you are sure you need to act on all data, use
WHERE 1=1 to remind yourself of the consequences of that action.
How the rule works
Bytebase considers this rule to be violated if the SQL has no WHERE clause.
Support database engine
Support for PostgreSQL is coming soon.