On Friday, August 29, 2025, Joel Jacobson <[email protected]> wrote:
>
>
> These were just the two first ideas on the top of my head, please share
> yours if you see a better way.
>
I’d love to just add a new clause to select.
Select …
Require {exactly|{more|less}than} row_count
e.g., exactly 1; more than 0, less than 2
No reason to limit this capability to function call outputs especially
since we would like to retain inlining when possible.
For insert/delete/update either add it directly there too or at worse you
get it via returning into a CTE and attaching “require” to the parent query.
David J.
