asterix-installer/src/main/resources/examples/mugshot/aql/insert.aql

/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */
use dataverse TinySocial;

insert into dataset MugshotUsers
(
  {
    "id":999,
    "alias":"John",
    "name":"JohnDoe",
    "address":{
      "street":"789 Jane St",
      "city":"San Harry",
      "zip":"98767",
      "state":"CA",
      "country":"USA"
    },
    "user-since":datetime("2010-08-15T08:10:00"),
    "friend-ids":{{ 5, 9, 11 }},
    "employment":[{
        "organization-name":"Kongreen",
        "start-date":date("2012-06-05")
    }]
  }
);