Add UPDATE statement support

[aviralgarg05]

Description

Implement support for SQL UPDATE statements to allow users to modify existing rows in tables.

Proposed Solution

• Add UPDATE table_name SET column = value WHERE condition parsing
• Support multiple column updates in a single statement
• Implement update execution logic with WHERE clause filtering
• Add type checking for updated values

Acceptance Criteria

• Parse UPDATE statements correctly
• Support SET clause with multiple columns
• Execute update operations with WHERE clause support
• Add unit tests for update functionality
• Update documentation with examples

Technical Notes

• Reuse existing WHERE clause evaluation from expression.rs
• Ensure atomic updates in sled storage
• Handle type mismatches gracefully with clear error messages

[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

---

🔗 Similar Issues

Related Issues

• Add DELETE statement support #45

👤 Suggested Assignees

• aviralgarg05

---

🧪 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 ?