I think you should use the non-standard syntax unless you have a good reason to avoid it. newwb has the right idea, though Postgres does not support JOIN syntax in UPDATE statements.

With Neon now part of the Striim ecosystem, Postgres users can join this wave of modernization: streaming operational data to fuel AI and analytics without sacrificing performance or reliability.

Databricks acquires database startup Neon for $1 billion to boost serverless Postgres innovation, build AI agents, eliminate data silos and launch new products.

Striim’s unified platform further allows vector embeddings to be built within the data pipeline while delivering real-time data into Neon and into Databricks for building Agentic AI use cases.

Striim Announces Neon Serverless Postgres Support to Broaden Agentic AI Use Cases with Databricks Read Next DeFi Development Corp. to Host Twitter Spaces Explaining ELOCs, S-1s, and Capital Strategy ...