Support SETTINGS in DELETE query

Why it matters

This feature allows users to specify query-level settings directly within DELETE statements, enabling more granular control over query execution behavior and performance tuning on delete operations.

How to use it

Add the SETTINGS clause at the end of a DELETE query to specify one or more settings. For example:

DELETE FROM table_name WHERE condition SETTINGS max_threads = 4, readonly = 0