Query

var q = new Query();
q.Text = "SELECT Id, Description FROM Catalog_SKU"
return q.Execute(); 

var query = new Query("SELECT DISTINCT D.Id, D.Description "
	+ "FROM Catalog_Outlet_Prices O "
	+ "JOIN Document_PriceList D ON O.PriceList=D.Id "
	+ "WHERE O.Ref = @Ref ORDER BY O.LineNumber");
query.AddParameter("Ref", outlet);
return query.ExecuteCount();

function GetOrderList() {
	var q = new Query("SELECT " 
		+ "DO.Id, DO.Outlet, strftime('%d/%m/%Y', DO.Date) AS Date, "
		+ "DO.Number, CO.Description	AS OutletDescription, DO.Status "
		+ "FROM Document_Order DO "
		+ "JOIN Catalog_Outlet CO ON DO.Outlet=CO.Id ORDER BY DO.Date DESC LIMIT 100");
	return q.Execute();
}

var query = new Query("SELECT SUM(Qty*Total) FROM Document_Order_SKUs WHERE Ref = @Ref");
query.AddParameter("Ref", order);
var sum = query.ExecuteScalar();

var query = new Query("SELECT Id, Description FROM Catalog_SKU");
return query.ExecuteCount();

function LoadFiltered(text) {
	var q = new Query("SELECT Id " 
		+ "FROM Catalog_Outlet "
		+ "WHERE Contains(Name, @value)");
	q.AddParameter("value", text);
	q.ExecuteInto("Filtered_Outlets");
}