Dialect-neutral description of a row cap found on a SELECT statement.
There is deliberately no TOP/LIMIT naming — consumers don't need to know
which syntax form produced the cap. The explicit form discriminant keeps
narrowing robust: a future variant cannot silently break an in-based guard.
Type Declaration
{form:"numeric";offset:number|null;value:number}
Numeric cap — comparable against a requested row limit.
{form:"percent"}
Percentage cap (SQL Server TOP N PERCENT) — a fraction, not a row count.
{form:"opaque"}
Non-numeric expression (TOP (@var), LIMIT $1) — not statically known.
Dialect-neutral description of a row cap found on a SELECT statement.
There is deliberately no TOP/LIMIT naming — consumers don't need to know which syntax form produced the cap. The explicit
formdiscriminant keeps narrowing robust: a future variant cannot silently break anin-based guard.