What types of SQL statements can be used with DoSQL ?

DoSQL uses the FileMaker built-in engine, and supports all SQL statements as documented in FileMaker's ODBC/JDBC developer manual, available here