
The NextDB security policy for deleting data is the same as updates.
In order to execute a delete, you need to have first retrieved a
temporary encrypted key for the row you want to delete. In other words
you must first query for the row, and then you supply the encrypted row
id back with the delete. The second aspect of this security policy is that
the query that is used to initially get the row id must have "FOR DELETE"
enabled. In other words, some queries are read only, while others can allow
either "FOR UPDATE" and/or "FOR DELETE". Batch deletes are not allowed, and
row level security is enabled at the query level with the "FOR DELETE" flag.