Add DELETE statement support

[aviralgarg05]

Description

Implement support for SQL DELETE statements to allow users to remove rows from tables.

Proposed Solution

• Add DELETE FROM table_name WHERE condition parsing in the SQL parser
• Implement delete execution logic in the executor
• Support WHERE clause filtering for targeted deletes
• Add validation to prevent deletion without WHERE clause (or require explicit DELETE FROM table)

Acceptance Criteria

• Parse DELETE statements correctly
• Execute delete operations with WHERE clause support
• Add unit tests for delete functionality
• Update documentation with examples

Technical Notes

• Reference existing WHERE clause implementation from SELECT
• Ensure sled storage layer handles row deletion properly
• Consider adding a confirmation mechanism for large deletes

[coderabbitai]

📝 CodeRabbit Plan Mode

Generate an implementation plan and prompts that you can use with your favorite coding agent.

• Create Plan

Examples

• Example 1
• Example 2

---

---

🧪 Issue enrichment is currently in open beta.

You can configure auto-planning by selecting labels in the issue_enrichment configuration.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord or schedule a call!

[sshekhar563]

Can you please assign this issue to me ?