如何在SQLite中启用LIMIT for DELETE？

DELETE FROM table_name
WHERE rowid IN (
  SELECT rowid FROM table_name
  ORDER BY column_name
  LIMIT 10
);

WITH cte AS (
  SELECT rowid FROM table_name
  ORDER BY column_name
  LIMIT 10
)
DELETE FROM table_name
WHERE rowid IN (SELECT rowid FROM cte);