Setting SET SESSION sql_mode = ''" on the connection file?


I need to work with a very tied down environment (cloud foundry) where I don’t have access to many server and environment variables and I need to set them at session level. In particular, I want to run something like the following on the connection file:

$conn->exec("set session sql_mode = ''");

What would be the best approach to achieve this? (the server side language is php).

For anyone in this predicament, line 76 of code in dmxConnectLib/lib/db/Connection.php can be appended with:

$this->pdo->exec("set session sql_mode = ''");