I'm not entirely sure that all update + join situations can be handled with subqueries. I'd rather it not work than do the wrong thing sometimes. This feels similar to implementing `ALTER TABLE` workarounds for SQLite.