Support `FETCH {N} ROWS WITH TIES` for PostgreSQL

[mingxiang-colorkrew]

trafficstars

Is your feature request related to a problem? Please describe. I would like to be able to use the FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES } functionality in PostgreSQL 13+ onwards with Jet. Currently this keyword is not supported by Jet. https://www.postgresql.org/docs/16/sql-select.html

Describe the solution you'd like Ideally it would be an official supported extension to the SelectStatement so we can compose it in a similar manner to other statements. Alternatively, it would be nice to have an official way to append statements not yet supported by Jet, though I'm not sure what form this could take.

Currently I am working around it by exporting the current statement using stmt.Sql() and appending to the string directly, would like some guidance on what would be the preferred approach for this kind of thing.

[houtn11]

Currently I am working around it by exporting the current statement using stmt.Sql() and appending to the string directly, would like some guidance on what would be the preferred approach for this kind of thing.

I don't see the other way around, except writing the whole query as raw statement.

[go-jet]

FETCH_FIRST/FETCH_LAST WITH TIES support added in Release v2.11.0.