MySQL locks and transactions

Hello dear Wappler community superstars !

I was wondering if (My)SQL transactions and locks could be used within Wappler ?
I can see that the syntax exists in the custom query autocomplete helper.
But so far, my attempts to execute transactions failed.

For instance, this test transaction :

2019-11-24_1119_001.png943×336 17.3 KB

produces the following error :

Now if I place each transactions in a seperate query, I get the following error on the first one “START TRANSACTION;” :
SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet

Thank you very much for your help !