Starting from MySQL 5.7 server returns errors when there's no value provided for NOT NULL field without defaultValue.
Big projects, that are upgrading source code to newer versions need to fix this errors, but if they're disabling Strict mode (temporally) they're not see this errors.
When NODE_ENV is not production we can use console.warn with message like:
[SQL Strict Mode Notice] This insert to ${tableName} can fail. Field ${fieldName} should have either value or have default value in field description or be nullable
Starting from MySQL 5.7 server returns errors when there's no value provided for NOT NULL field without defaultValue.
Big projects, that are upgrading source code to newer versions need to fix this errors, but if they're disabling Strict mode (temporally) they're not see this errors.
When NODE_ENV is not production we can use
console.warnwith message like:[SQL Strict Mode Notice] This insert to ${tableName} can fail. Field ${fieldName} should have either value or have default value in field description or be nullable