I often find things like this to be workarounds for architectural flaws. For example, the 2rd part of the article looks like it would be better suited to a trad

I often find things like this to be workarounds for architectural flaws. For example, the 2rd part of the article looks like it would be better suited to a traditional ETL pipeline, with a staging table & upsert/merge in the database.