Comments - SQL_MODE
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
SQL_MODE is not mainly "for getting MariaDB to emulate behavior from other SQL servers", it's for getting MariaDB to conform to the SQL standard by specifying SQL_MODE = ANSI .
A side effect is that complying with standards makes it easier to port one's work to a different database, in case that's ever needed - but is it really necessary to explain why conformance with standards is a good thing?