Delete from table1 where table1.id in (select table1.id from table1 limit yourlimitnumber)
The IN predicate is only efficient for a very small number of elements, supported by an index. People (including me) who would find DELETE FROM .. LIMIT TO ... useful want to delete a *lot* of rows (but not all in one giant statement).
Deleting large numbers of rows is a complex task with a lot of hidden issues (index management between other things). Adding a LIMIT paradigm will not simplify it in any way. I remember doing it on tables with over 50 millions rows and had my share of disaster recoveries. Partitions saved my life.
