This topic describes the SQL statements that are currently supported. The scope of support is continuously expanding.
The FMT pattern supports some features of Data Manipulation Language (DML) statements, such as SELECT, INSERT, UPDATE, and DELETE.
The FMT pattern does not support stored procedures or triggers.
The following tables show the current support status for SQL statements.
To use other SQL statements, submit a ticket in the console.
Basic SQL statements
Type | SQL instance | Supported |
INSERT | INSERT INTO tb1 (col_name,…) VALUES ({expr,value},…) | Yes |
INSERT IGNORE | INSERT IGNORE INTO tb1 (col_name,…) VALUES ({expr,value},…) | Yes |
INSERT … ON DUPLICATE KEY UPDATE | INSERT INTO tb1 (col_name,…) VALUES ({expr,value},…) ON DUPLICATE KEY UPDATE SET col1=expr1 [, col2=expr2 …] [WHERE where_definition] | Yes |
UPDATE | UPDATE tb1 SET col1=expr1 [, col2=expr2 …] [WHERE where_definition] | Yes |
DELETE | DELETE FROM tb1 [WHERE where_definition] | Yes |
SELECT | SELECT select_expr, … FROM tb1 [WHERE where_condition] [order by condition] [group by condition [having condition]] [for update] [limit statement] | Yes |
Update SQL statements
Type | SQL Instance | Supported |
AND & OR | UPDATE … WHERE col1 = expr1 AND col2 = expr2 | Yes |
LIKE | UPDATE … WHERE col1 LIKE ‘X%’ | Yes |
BETWEEN | UPDATE … WHERE col1 BETWEEN expr1 AND expr2 | Yes |
IN | DELETE … WHERE col1 in (expr1 ,…, exprN) | Yes |
IS NULL | DELETE … WHERE col1 IS NULL | Yes |
Nested statements | UPDATE tb1 … WHERE col1 in (select col2 from tb2) | No |
Stored procedures, triggers | No |
SELECT statements
Type | SQL Instance | Read uncommitted | Read committed |
AND & OR | SELECT * FROM tb1 WHERE col1 = expr1 AND col2= expr2 | Yes | Yes |
ORDER BY | SELECT col1, col2 FROM tb1 ORDER BY col1 | Yes | Yes |
GROUP BY | SELECT col1, col2 FROM tb1 GROUP BY col1 having col1 > 1 | Yes | Yes |
LIKE | SELECT col1, col2 FROM tb1 WHERE col1 LIKE ‘X%’ | Yes | Yes |
IN | SELECT col1, col2 FROM tb1 WHERE col1 IN (expr1, expr2,…) | Yes | Yes |
BETWEEN | SELECT col1, col2 FROM tb1 WHERE col1 BETWEEN expr1 AND expr2 | Yes | Yes |
LIMIT | SELECT col1, col2 FROM tb1 LIMIT x | Yes | Yes |
JOIN, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN | SELECT col1, col2 FROM tb1 JOIN tb2 ON tb1.col1= tb2.col2 | Yes | No |
UNION, UNION ALL | SELECT col1, col2 FROM tb1 UNION SELECT col1, col2 FROM tb2 | Yes | No |
Nested queries | SELECT col1, col2 FROM tb1 where col1 in (select col3 from tb2) | Yes | No |
Stored procedures, triggers | No | No |