Understanding the Problem with UPDATE OR INSERT in Firebird SQL: Alternatives to Unexpected Behavior

Retrieving the Maximum Value from Three Fields in Firebird 3 Using SQL Window Functions and ORDER BY Clause