How to support deletes?

### Is your feature request related to a problem or challenge?

`delete from foo where id = 1;`

currently gives me

`Unsupported logical plan: Dml(Delete).`

is support for it missing currently? I don't see a corresponding method in the table provider either?

### Describe the solution you'd like

delete statements should work

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Start by tracing where the logical plan reports `Dml(Delete)` as unsupported and inspect the table provider API mentioned in the issue. Define the required delete behavior and verify that `delete from foo where id = 1;` executes successfully with appropriate tests.

Written by the indexing model from the issue text.