Igal

Explore posts from servers

CDCloudflare DevelopersKKysely

PostsComments

KKysely

•Created by Seifer on 12/29/2024 in #help

Pagination

Hey 👋 As @koskimas pointed out. One of Kysely's core design principles is What You See Is What You Get. What you invoke, is exactly what you should get in the compiled query. For MSSQL, you must, according to spec, use a combination of order by, offset and fetch. https://learn.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver16#syntax

7 replies

KKysely

•Created by fed on 12/26/2024 in #help

[Bug] innerJoinLateral selectAll prepends schema

Hey 👋🏻 withSchema is a plugin under the hood. We could possibly track aliases in plugin state and not add schema to them when we find them in other parts of the tree as standalone table names.

17 replies

KKysely

•Created by fed on 12/26/2024 in #help

[Bug] innerJoinLateral selectAll prepends schema

Hey 👋 Can you provide a kyse.link that reproduces this?

17 replies