[FEATURE]: `from` clause on PgUpdateBuilder

[DanielBaulig]

Describe what you want

There doesn't seem to be a way to from / join to other tables when using the PgUpdateBuilder builder. Maybe I am missing something?

https://www.postgresql.org/docs/current/sql-update.html

[MorelSerge]

Same for deleting rows.

[MorelSerge]

This is actually quite a large missing feature IMO. Isn't this a default functionality in multiple SQL dialects?

I'm having a use case where I require updating tens of thousands of records at once, based on a joined table. This is currently not possible with Drizzle, apart from raw querying.

[eric-crowell]

I agree. This feature should be important enough to be added to the public roadmap. It's not limited to niche use cases. Anyone heard anything from the maintainers about their approval of this enhancement?