title: How to prevent bulk row deletion operations?
body: <p>I can prevent DELETE completely like this:</p>
  
  <pre><code>CREATE TRIGGER prevent_multiple_row_del
  BEFORE DELETE ON ALL
  BEGIN
  RAISE EXCEPTION 'Cant delete more than 1 row at a time';
  END;
  </code></pre>
  
  <p>But how do I check if the delete operation will lead to deletion of multiple rows? Deletion is not a problem, as long as it's limited to a constant number (1 or 5 or 10, as long as it's not unlimited).</p>
  
  <p>Alternatively, how do I allow deletions but prevent deletions of full tables?</p>