I was testing this lately,Teradata, SQL server, Oracle and others just return ß for upper('ß'). Snowflake returns SS. There is btw an upper letter defined for ß

https://m.wikidata.org/wiki/Q9693