SQLglot automatically converts NVL and IFNULL to COALESCE, even when using dialect='hive' or dialect='spark2'. This is standard SQLglot behavior for function normalization. However, in some scenarios, ...