Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction.
What is term used to call these Transaction?
Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset,
what will be the value of METADATA$ISUPDATE Columns in this scenario?