SQLITE_ERROR due to Element named "Group"

[gregorwolf]

Hello CAP Team,

in the Branch real-b1-metadata of sap-business-one-odata-cap I've adjusted the metadata to avoid the issue #59. But now a new error occurs:

[Error: SQLITE_ERROR: near "Group": syntax error] {
  errno: 1,
  code: 'SQLITE_ERROR',
  query: 'CREATE TABLE SAPB1_AssetDepreciationGroups (\n' +
    '  Code NCLOB NOT NULL,\n' +
    '  Description NCLOB,\n' +
    '  Group NCLOB,\n' +
    '  Items_ItemCode NCLOB,\n' +
    '  PRIMARY KEY(Code)\n' +
    ')',
  severity: 'Error'
}

this is the statement that cds watch tries to execute:

CREATE TABLE SAPB1_AssetDepreciationGroups (
  Code NCLOB NOT NULL,
  Description NCLOB,
  Group NCLOB,
  Items_ItemCode NCLOB,
  PRIMARY KEY(Code)
)

This issue is cased by the fact that Group is a SQLite Keyword. Is there any workaround planned for this issue? As I'm using an external service model I have no influence on the naming.

Best regards
Gregor

[gregorwolf]

Incident in the SAP Service Marketplace: 289321 / 2020