On my local linux/mysql both single and double quotes work. This particular query does use double quotes to wrap the literal phpist, but I am not sure whether that is consistent throughout the code.
Try this query to see what mysql allows for quotes
SHOW SESSION VARIABLES LIKE 'sql_mode';