Uppercase characters in schemas, tables & columns in SQL

When creating SQL against schemas, tables and/or columns that contain uppercase characters you will need to enclose the value of the element in double quotes.  In the example schema:

{
    "hash_attribute": "ID",
    "name": "Person",
    "schema": "dev",
    "attributes": [{
        "attribute": "ID"
    },
    {
        "attribute": "FirstName"
    },
    {
        "attribute": "lastname"
    }]
}

You see that the table Person & attributes: ID & FirstName contain uppercase characters.

When you execute this SQL call to HarperDB:

{
  "operation": "sql",
  "sql":"SELECT ID, FirstName, lastname from dev.Person"
}

You will receive the response:

{"error": "Invalid table"}

This is due to the SQL parser putting all schema elements to lowercase. In order to avoid this the elements that contain uppercase character will need to be enclosed in double quotes. Note: your double quotes in JSON will need to be escaped. When you change your JSON to:

{
  "operation": "sql",
  "sql":"SELECT \"ID\", \"FirstName\", lastname from dev.\"Person\""
}

The result this time will be:

[
    {
        "ID": 1,
        "lastname": "Jerrorson",
        "FirstName": "Jerry"
    }
]