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?