Support full `FOR UPDATE [ OF <update_column_name_list> ] [ { <wait_nowait> | IGNORE LOCKED } ]` syntax

[kulliax]

At the moment, CQ(L|N) (officially) only supports FOR UPDATE <wait_nowait>.

Also implemented is OF <update_column_name_list>, but this has not been implemented in cds-types, see cap-js/cds-types#336

However, IGNORE LOCKED is not implemented, which we really miss. Can this function also be implemented in CQ(L|N)?
With cds.db.run we can execute our own queries, it is more elegant and nicer if this DB native function is supported.

Docu:
hana: https://help.sap.com/docs/hana-cloud-data-lake/sql-reference-for-data-lake-relational-engine-sap-hana-db-managed/select-statement-for-sap-hana-database
pgsql: https://www.postgresql.org/docs/current/sql-select.html with better explanation

First request: cap-js/cds-types#331

[kulliax]

Hi @johannes-vogel , Is there any progress or are there still open issues?

[kulliax]

Hi @johannes-vogel,

in my conversation with @sjvans today i learned that it is already implemented (#1074). Is there a reason why it is not official? It is also not in the documentation (https://github.com/cap-js/docs/blob/main/node.js/cds-ql.md?plain=1#L686) or in cds-types (https://github.com/cap-js/cds-types/blob/main/apis/cqn.d.ts#L22).