No
SQL does not support lists:
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 |