Support `DELETE` with `LIMIT` and `ORDER BY`

[MocioF]

LIMIT has been fixed for UPDATE with this PR #93 but DELETE LIMIT is still unsupported.

[adamziel]

CC @kozer

[JanJakes]

The new SQLite driver supports UPDATE with both ORDER BY and LIMIT, but for the DELETE statement it's not implemented yet. I updated the title to mention ORDER BY as well.

[MocioF]

Hi @JanJakes, it seems to me that the driver translates the MySql query as if the sqlite used is compiled with SQLITE_ENABLE_UPDATE_DELETE_LIMIT (https://sqlite.org/compile.html#enable_update_delete_limit), but it is not.
I am not sure if is it possible to add in playground a sqlite version built with this flag but as a workaround, the query DELETE ... LIMIT, could be translated in something as:

DELETE FROM table
WHERE someColumn in
(
  SELECT someColumn FROM table WHERE SomeCondition LIMIT 200
)

[JanJakes]

Hi @MocioF, as this issue states, this is not yet implemented for the DELETE statement.