Parser cannot parse undocumented reverse syntactic order of FOR UPDATE and LIMIT clauses from PostgreSQL

[lukaseder]

This is valid in e.g. PostgreSQL:

select *
from t_book
order by id 
for update skip locked
limit 1

But jOOQ cannot handle it, producing:

Unsupported query type: [5:1] ...rom t_book
order by id 
for update skip locked
[*]limit 1

The correct syntax (even in PostgreSQL) should be:

select *
from t_book
order by id 
limit 1
for update skip locked

According to the docs:

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

Though, we've supported parsing alternative orders of SELECT clauses before, e.g. Oracle's arbitrary ordering of CONNECT BY, START WITH, GROUP BY, HAVING.

[lukaseder]

This also parses in PostgreSQL:

select *
from t_book
order by id
for update skip locked
offset 1 
limit 1

But this doesn't:

select *
from t_book
order by id
offset 1 
for update skip locked
limit 1

[lukaseder]

Neither does this:

select *
from t_book
for update skip locked
order by id
offset 1 
limit 1