Sqlalchemy: Update... Limit 1, Not Possible?

In MySQL it is possible to limit the number of records affected by an update query. In an ideal world this should not be necessary, but having such a limit does in some cases help

Solution 1:

The Mysql dialect has this thrown in as update(..., mysql_limit=x)

https://docs.sqlalchemy.org/en/latest/dialects/mysql.html#mysql-sql-extensions