Single quote escape convention

[Eclesia]

In SQL to escape a single quote, a solution is to double the quote.

Currently in OrientDB we must use \'

Here are different cases where orientdb sql parser fails :

final OSchema schema = db.getMetadata().getSchema();
final OClass clazz = schema.createClass("test");
clazz.createProperty("strAtt", OType.STRING);

db.command(new OCommandSQL("INSERT INTO test(numericAtt) VALUES ('some escaped '' cote')")).execute();
// double single quote in the middle = fail -> will store the two quotes in the field value

db.command(new OCommandSQL("INSERT INTO test(numericAtt) VALUES ('some escaped cote''')")).execute();
// double single quote at the beginning = fail -> parsing error
db.command(new OCommandSQL("INSERT INTO test(numericAtt) VALUES ('''some escaped cote')")).execute();
// double single quote at the end =fail -> parsing error

I know orientdb sql is not a true sql, but preserving well knowned writings would be appreciated by users.

[luigidellaquila]

Sorry, this won't be implemented.

Thanks

Luigi