Hello @oneill 

There is currently no supported workaround to dynamically change system/session parameters such as ansi_mode within a BEGIN ... END block in Databricks SQL procedures or scripts. Can you set these parameters before executing any procedural logic.

For example:

SET ANSI_MODE = true;
BEGIN
  -- procedural code here
END;