Kraken SQL Parser

Tested SQLs

CREATE TABLE test ( id INT NOT NULL PRIMARY KEY, name CHAR(20), created_at DATE, FOREIGN KEY (name) REFERENCES test2(name), PRIMARY KEY (id,name,qoo) )
ALTER TABLE test ADD name char(60);
ALTER TABLE test ADD created_at date;
ALTER TABLE test ADD name character varying(60);
ALTER TABLE test DROP COLUMN name;
DROP TABLE test;
DESC test;
SHOW TABLES;
INSERT INTO test DEFAULT VALUES;
INSERT INTO test VALUES (NULL, NULL);
INSERT INTO test (id, name) VALUES (NULL, NULL);
INSERT INTO test (id, name) VALUES (DEFAULT, DEFAULT);
INSERT INTO test (id, name) VALUES (-1, +2);
INSERT INTO test (id, name) VALUES (-1, 2 + 3 + 4);
INSERT INTO test (id, name) VALUES (-1, 2 * 3 + 4);
INSERT INTO test (id, name) VALUES (-1, 'hello ''xeraph''');
DELETE FROM test;
DELETE FROM test WHERE 1 = 1;
DELETE FROM test WHERE 1 = 'xeraph';
DELETE FROM test WHERE 1 = 1 OR 2 <> 3;
DELETE FROM test WHERE 1 = 1 AND 2 <> 3 AND id = 1;
DELETE FROM test WHERE id = 1;
DELETE FROM test WHERE id IS NULL;
DELETE FROM test WHERE id IS NOT NULL;
DELETE FROM test WHERE test.id IS NOT NULL;
DELETE FROM test WHERE test.\"number id\" IS NOT NULL;
SELECT * FROM test;
SELECT id, name FROM test;
SELECT * FROM test WHERE id = 1;
SELECT p.productid, p.name, s.inventory FROM products p INNER JOIN stock s ON p.productid = s.productid WHERE (p.productid = 1);
SELECT BridgeOrganizationStructure.ParentOrganizationCode, DimEmployeeOrganization.Emp_FName, DimEmployeeOrganization.Emp_LName, BridgeOrganizationStructure.SubsidiaryOrganizationCode, BridgeOrganizationStructure.LevelFromParent, FactAttempt.ActivityFK, FactAttempt.CurrentAttemptInd, FactAttempt.AttemptStartDt, DimActivity.Activity_PK FROM DimActivity INNER JOIN FactAttempt ON DimActivity.Activity_PK = FactAttempt.ActivityFK AND (DimActivity.Activity_PK = 55) AND (FactAttempt.CurrentAttemptInd = 1 ) RIGHT OUTER JOIN BridgeOrganizationStructure INNER JOIN DimEmployeeOrganization ON BridgeOrganizationStructure.SubsidiaryOrganizationID = DimEmployeeOrganization.EmpOrg_OrgFK ON FactAttempt.EmpJob_EmpFK = DimEmployeeOrganization.EmpOrg_EmpFK WHERE (BridgeOrganizationStructure.ParentOrganizationCode = '10525');
SELECT Merchandise.Description, Users.Name FROM Users INNER JOIN (Sales INNER JOIN (Merchandise INNER JOIN Types ON Merchandise.TypeID = Types.TypeID) ON Sales.MercID = Merchandise.MercID) ON Users.UserID = Sales.BuyerID WHERE Types.TypeID = 1;
SELECT Sales FROM Store_Information WHERE Store_name IN ('Seoul', 'Incheon');
SELECT Sales FROM Store_Information WHERE Store_name IN (SELECT store_name FROM Geography WHERE region_name = 'West');
UPDATE test SET id = 1;
UPDATE test SET name = '' WHERE name is null;