`UPDATE ... ORDER BY ... LIMIT` support in MySQL Dialect

[prydt]

let sql = "UPDATE job_queue SET status = 'processing' WHERE status = 'pending' ORDER BY created_at ASC LIMIT 10;";
let dialect = MySqlDialect {};
let ast = Parser::parse_sql(&dialect, sql).unwrap();

fails with called Result::unwrap()on anErr value: ParserError("Expected: end of statement, found: ORDER at Line: 1, Column: 69")

I have a fix for this in the works and will add testing for both MySQL and Generic dialects.

[tpyo]

I ran into this too and opened #2296

[prydt]

Oh perfect, thank you!