Feature Overview

Track the state of parameters/variables modified via SET statements during an active transaction. The main goal is to ensure that if the transaction is rolled back, any variables that were changed are restored to their original state from before the transaction began.

This feature also needs to handle more complex scenarios involving savepoints. When a savepoint is created, we will capture the current state of the variables. If the transaction is later rolled back to a specific savepoint, the variable state should be reset to match the state at the time that savepoint was created. Similarly, when a savepoint is released, we will discard the associated variable snapshot.

This will ensure that variable state remains consistent and predictable throughout the life of a transaction, including partial rollbacks via savepoints.