Support INSERT statements in SQL

[MaxKsyunz]

As an SQL user I would like to create documents using INSERT statements.

Sample

INSERT INTO MV_A(FieldA, FieldB, FieldC) VALUES (1, "two", 3.0f)

References

• MySQL
• PostgreSQL
• Microsoft SQL Server

[MaxKsyunz]

In OpenSearch, 'insert' (a.k.a. indexing) is done like so:

PUT sample-index/_doc/1
{
  "Description": "To be or not to be, that is the question."
}

Response looks like this

{
  "_index": "sample-index",
  "_id": "1",
  "_version": 1,
  "result": "created",
  "_shards": {
    "total": 2,
    "successful": 1,
    "failed": 0
  },
  "_seq_no": 0,
  "_primary_term": 1
}

• Should any of this data be returned in SQL plugin response?

[MaxKsyunz]

When the user sets _id for the new document -- INSERT INTO table (_id, ...) VALUES (1, ...)
and the document already exists
then SQL plugin returns an error response.