-- Here is the create_db.txt script (SQL++):
CREATE TYPE EsportsUserType AS {
    userId: uuid,
    name: string,
    totalPlayTimeMinutes: INT,
    dateJoined: datetime?,
    lastAccessed: datetime?
};

CREATE DATASET EsportsUserSet(EsportsUserType)
PRIMARY KEY userId AUTOGENERATED;


-- Here is the insert script (SQL++):
INSERT INTO EsportsUserSet
({
    "name": "Sandy",
    "totalPlayTimeMinutes": 3,
    "dateJoined": datetime("2019-09-04T13:44:22")
});


-- And here is the upsert script (AQL):
USE dataverse Esports;
upsert INTO dataset EsportsUserSet
(
{
"userId": uuid("d804097a-e458-345f-a470-c64246e28322"),
"name": "Sandy",
"totalPlayTimeMinutes": 5,
"dateJoined": datetime("2019-09-04T13:44:22")
}
);