The documentation states ANSI as being included in the default sql modes "The default SQL modes for MySQL on managed databases are as follows:". However, as of now on new MySQL 8 managed DB deployments, ANSI_QUOTES is the mode which is set, and not the ANSI shorthand mode. Also, some explanation as to why this mode is the default on DO managed databases when it's not one of the default MySQL 8 SQL modes would be appreciated. https://docs.digitalocean.com/products/databases/mysql/how-to/set-sql-mode/