If you have a project that is so old and so broken but you have to maintain anyway, but you are developing locally using MySQL 5.7+, just run this on your MySQL console to remind yourself how poorly coded your codebase is everyday!
> set global SQL_MODE="NO_ENGINE_SUBSTITUTION";
The next day, run it again and again and again, until your team fixes the codebase.