add `FETCH` clause support.

[igalklebanov]

Hey 👋

fetch clause is supported in dialects such as PostgreSQL, MS SQL Server (MSSQL) and OracleDB.

It works just like limit, but sometimes limit is not supported, so here we are.

It is only supported in select queries, or when they're used as subqueries in top-level insert/delete/update queries.

This PR also:

• expands limit and offset by allowing bigints.
• fixes mssql offset compilation.

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
kysely	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Feb 24, 2024 11:49am