SQLChat

Natural Language to SQL

Training Phrases

Parameters

Demos

User: can you tell me the employees that have a birthday in January

Fulfilment:

{
    Table: "employees",
    Filters: [
        {
            Filter: {
                "month": "January",
                "Comparator": "equal to"
            }
        }
    ]
}

User: search for employees first name and last name born between January and March

Fulfilment:

{
  "Filters": [
  {
    "Filter": {
      "date-period": {
        "endDate": "2020-03-31T23:59:59-07:00",
        "startDate": "2020-01-01T00:00:00-08:00"
      }
    },
    "Field": "employees-birth_date"
  }
],
  "Fields": [
    {
      "field": "employees-first_name"
    },
    {
      "field": "employees-last_name"
    }
  ]
}