partiQL Support?

[mikewolfd]

Hello,

Does this package support running queries using the partiQL statement execution syntax? I'm trying to do it now but am running into UnknownOperationException errors.

[freshollie]

It could be that partiQL is generating a query which is not supported? For example transactions are not yet supported by dynalite, nor are streams.

[Jack-Barry]

@mikewolfd it's been a while since this was opened, but do you happen to remember if you were able to get around it?

I just hit this issue, not sure what would be incorrect about the PartiQL statement I'm trying to run as a dummy test...

const statement = {
  Statement: `SELECT * FROM "MyTableName" WHERE id='${someId}' AND typeId='${someTypeId}'`
};
await ddb.executeStatement(statement).promise();

The same type of select statement works just fine from the AWS console. I've tried every which way I can think of to change single vs. double quotes, no quotes, etc. but still get an UnknownOperationException when running the executeStatement in a test.

Just updated to latest [email protected] and [email protected]

[khoaleanhvn]

@Jack-Barry Did you find a way to work around? I'm at your situation now.

[Jack-Barry]

@khoaleanhvn I never did, ended up punting on using PartiQL, partly because of this issue

[ffleandro]

Same here, tested a very simple query directly using dynalite and seems like a problem in dynalite itself.