What a dialect does to an unquoted identifier: 'upper' folds it to upper case (the SQL
standard, Oracle, Snowflake), 'lower' to lower case (PostgreSQL), and 'none' keeps it as
written and compares it according to the server's collation or settings (SQL Server, MySQL,
Databricks).
What a dialect does to an unquoted identifier:
'upper'folds it to upper case (the SQL standard, Oracle, Snowflake),'lower'to lower case (PostgreSQL), and'none'keeps it as written and compares it according to the server's collation or settings (SQL Server, MySQL, Databricks).