Feature: DELETE statement LIMIT clause support

[arkamfahry]

Is your feature request related to a problem?

When performing bulk deletes or when deleting large data sets without a LIMIT clause could become a performance bottleneck and it can slow down the DELETE statement.

Describe the solution

Give the DELETE statement the ability to limit the number of records being deleted by adding a LIMIT clause to the DELETE statement

DELETE users LIMIT 100;

Alternative methods

N/A

SurrealDB version

1.0.2 for windows on x86_64

Contact Details

No response

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

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

[kearfy]

I started work on this in #3008 previously, linking for reference

[Dhghomon]

I was just about to ask about this and I see it's on the way! Will be a very nice addition