N1QL VS SQL

	N1QL	SQL
Data Model	Free-form documents, gathered into large collections called keyspaces	Uniform structure

N1QL extends SQL from traditionally operating on tables and rows (tuples) to operate on JSON (nested documents).

	N1QL	SQL
Data Projection	permits data reshaping, by embedding statement-attributes in the desired result-object shape Query: SELECT Name, History, {'FullTime': true} AS 'Status' FROM HRData	a set of rows is returned; each row consisting of one or more columns, and the columns being the same for each row Query: SELECT Name, Company FROM Employee, Employers WHERE Name_Key = Name