Question
Is it possible to change the SQL mode of MySQL/MariaDB per cPanel account?
Answer
It is only possible to change the SQL mode server-wide. See the following article if you want to update the SQL mode for the whole server.
How to change the SQL mode in MySQL or MariaDB