SQL Statements

DataConnector supports multiple SQL queries for different database operations. The table below describes supported SQL statements.

Name	Clauses	Examples
SELECT	FROM	SELECT * FROM Account
	WHERE	SELECT * FROM Account WHERE FirstName <> 'John';
	JOIN	SELECT ID, NAME, AMOUNT, DATE FROM CUSTOMERS INNER JOIN ORDERS ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID; Similarly, Left Join, Left Outer Join, and Cross Join can be used.
	UNION/UNION ALL	SELECT FirstName FROM Account UNION SELECT CustomerID FROM Customer;
	GROUP BY	SELECT * FROM Account GROUP BY Country;
	Aggregate Functions	SELECT MIN(amount_paid) FROM Accounts; Similarly, Max, Sum, Avg, and Count fucntions can be used.
	LIMIT OFFSET	SELECT FullName FROM Account LIMIT 10
	ORDER BY	SELECT * FROM Account ORDER BY ASC;
UPDATE		Refer CRUD operations topic
INSERT		Refer CRUD operations topic
DELETE		Refer CRUD operations topic