update doesn't work with Experimental syntax

[parsonsmatt]

update does not work with the new Experimental syntax, even though it probably should!

Unfortunately, support for fancier updates differs across backends. MySQL and Postgresql differ, and SQLite appears to mirror Postgres.

As an example, MySQL allows you to specify updates on a bunch of tables in the FROM clause, while the other two engines require a single table to be updated (but other tables can be mentioned in the FROM for filtering).

[belevy]

This is something I was playing around with at the end of last year. It honestly is probably best to just only support ANSI SQL updates in the main module and all the individual modules can support their own version of update that allows JOINs