Most opensource software that uses MySQL is riddled with MySQLisms.
The problem is that MySQL-based software doesn't do that and relies on the default "quirks" mode.