Should DELETE + LIMIT be supported by the generic dialect ? #2615

Hello!

At apache/datafusion#24998 we were investigating a problem that DELETE FROM tableX LIMIT 10 was actually ignoring the limit and deleting all records.

It seems only MySQL/MariaDB supports LIMIT in DELETE clause. All other major DBs cannot parse it.
For example:

Postgres:

postgres=# DELETE FROM t3 LIMIT 2;
ERROR:  syntax error at or near "LIMIT"
LINE 1: DELETE FROM t3 LIMIT 2;
                       ^

DuckDB:

memory D DELETE FROM t3 LIMIT 2;
Parser Error:
syntax error at or near "LIMIT"

LINE 1: DELETE FROM t3 LIMIT 2;
                       ^

Should sqlparser-rs disable DELETE+LIMIT for all but the MySQL dialect ?