MuthuLakshmi
Databricks Employee
Databricks Employee

@Dhruv-22 
Regarding your 1st question, I'm not sure
You can refer to https://docs.databricks.com/aws/en/sql/language-manual/parameters/ansi_mode#system-default to understand what happens when ansi mode is disabled