InsertQuery insOrder = OQL

  .InsertInto(NW.Order)

  .Fields(NW.Order.ShipCity, NW.Order.ShipVia)

  .Values("Macrobject City", 1);

The SQL statements generated as follows (taking SQL Server as an example)

INSERT INTO

  [Orders]

(

  [ShipCity] , [ShipVia]

)

VALUES

(

  'Macrobject City' , 1

)