Is there a list of supported and unsupported queries?

Please see "SQL Syntax" under MySQL Compatibility.