Generalize locking clause

[audunska]

Postgres supports more generalized locking clauses, for example: FOR UPDATE OF <table_name> SKIP LOCKED

also, multiple locking clauses. Generalize the parser to support these.

This might be a breaking change, since we're adding new keywords SKIP , LOCKED and NOWAIT. What's the policy on that?

[alamb]

Thank you for the contribution @audunska -- I looked at

https://www.postgresql.org/docs/current/sql-select.html

And this PR appears to implement that grammar 👍

This might be a breaking change, since we're adding new keywords SKIP , LOCKED and NOWAIT. What's the policy on that?

It is fine and expected -- we release new versions that do not get automatically semver updated.

[alamb]

For some reason the CI checks did not run on this PR . I took the liberty of merging up from main to see if I can get them to run

[coveralls]

Pull Request Test Coverage Report for Build 3689789223

• 119 of 119 (100.0%) changed or added relevant lines in 5 files are covered.
• No unchanged relevant lines lost coverage.
• Overall coverage increased (+0.1%) to 86.372%

---

Totals
Change from base Build 3689610291:	0.1%
Covered Lines:	12650
Relevant Lines:	14646

---

💛 - Coveralls