SQL SYNTAX REFERENCE FOR ZOHO

I am trying to find a reference guide for Zoho SQL Syntax:

for example this function does not work but I do not have an sQL syntax reference to correct it:

void DEFAULT.DELACTS()

{

delete from acct [(CANADA_TRANSIT_BRANCH like "*editme" && flag_temp == "XIALEGOUYAN")];

}