feat: add support `delete from ... where ...`

[j-blackwell]

Is your feature request related to a problem?

No response

What is the motivation behind your request?

I will often be running delete statements before insert statements. I can construct an ibis table expression to highlight the rows that I'd like to delete (i.e. table.filter(...), but can't delete these records without going via SQL.

Describe the solution you'd like

Similar to the .truncate_table() method of the sql backend:

class SQLBackend(BaseBackend):
    ...

    def delete(self, table: ibis.Table): # or delete_from, or delete_where
        ...

What version of ibis are you running?

10.3.1

What backend(s) are you using, if any?

SQLBackend

Code of Conduct

• I agree to follow this project's Code of Conduct