Let's assume we want to insert the dataset as shown in the preceding snippet. Our insert query could look like the following:

insert into dataset Employee
(
{
  "id": 101,
  "username":"John",
  "name":"John Doe",
  "nickname":"John",
  "email":"[email protected]",
  "createdAt":datetime("2017-08-15T08:10:00"),
  "friendIds":{{ 2,3, 4, 10 }},
  "employment":
   [
    {
      "organizationName":"SAS WEB Tech",
      "startDate": date("2017-08-15")
    },
   {
     "organizationName":"Kirlokser Service Center",
     "startDate": date("2016-08-15")
   }
  ],
  "gender": "Male"
}
);