No
Does not support DDL.
Does not support scope, group, subqueries such as BETWEEN, GROUP BY … HAVING, etc.
SQL support list
| SQL | support or not |
|---|---|
| INSERT INTO table (column,…) VALUES (value,…) | support |
| INSERT INTO table (column,…) VALUES (value,…),(value,…),… | support |
| INSERT INTO table (column,…) SELECT column1 from table1 where column1 = value1 | do not support |
| condition categories | SQL | support or not |
|---|---|---|
| = | SELECT/UPDATE/DELETE … WHERE column = value | support |
| LIKE/NOT LIKE | SELECT/UPDATE/DELETE … WHERE column LIKE/NOT LIKE value | support |
| IN/NOT IN | SELECT/UPDATE/DELETE … WHERE column IN/NOT IN (value1,value2,…) | support |
| BETWEEN | SELECT/UPDATE/DELETE … WHERE column BETWEEN value1 AND value2 | do not support |
| GROUP BY … HAVING… | SELECT/UPDATE/DELETE … WHERE … GROUP BY column HAVING column > value | do not support |
| Sub Query | SELECT/UPDATE/DELETE … WHERE column = (SELECT column FROM table WHERE column = value) | do not support |