UPDATE ... FROM ( subquery ) only supported in PostgreSQL

[thomastyg]

Hi 👋

The UPDATE <table> FROM (SELECT ...) statement is only supported with PostgreSQL dialect.

It should be also supported for other technologies.
Here are a few examples:

• BigQuery
• Snowflake
• Redshift
• SQL Server

[alamb]

Thanks for the report. A contribution PR would be most welcome

[unvalley]

I'll take a look.