Database - Update with join

[najdanovicivan]

I see in database classes that there's no support for update with joins.

More info here
MYSQL - https://www.mysqltutorial.org/mysql-update-join/
PostgreSQL - Does Not Support It
SQLite - Does Not Support It
MSSQL - https://www.sqlshack.com/an-overview-of-sql-server-update-join/

Additionally implementation using the WHERE method is also impossible as From section does not allow multiple tables to be used. There's also no support for $escape parameter in from method which makes even passing the formatted from string impossible.

[najdanovicivan]

I'll work on implementing join support for MySQL. I'll see what I can do about MSSQL since I don't use windows.