kysely
kysely copied to clipboard
kysely-org
A type-safe typescript SQL query builder
Hey 👋 Bun tests are hanging in GitHub Actions. Durations going 3h and beyond for the bun related steps. I have disabled bun steps until fixed @ `test.yml`.
Hey :wave: `top` clause is supported in dialects such as [MS SQL Server (MSSQL)](https://learn.microsoft.com/en-us/sql/t-sql/queries/top-transact-sql?view=sql-server-ver16) and [Snowflake](https://docs.snowflake.com/en/sql-reference/constructs/top_n). It works just like `limit` in other dialects, but has some interesting modifiers like...
Good morning, I work with Sql server on several databases. When I do a select it is common for me to join tables between several databases. Is there a way...
Hey 👋 `fetch` clause is supported in dialects such as [PostgreSQL](https://www.postgresql.org/docs/current/sql-select.html), [MS SQL Server (MSSQL)](https://learn.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-ver16) and [OracleDB](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SELECT.html). It works just like `limit`, but sometimes `limit` is not supported, so here...
In Typescript 5.0.2, autocomplete is not working with certain form of selecting: ```ts db.selectFrom("table").select((e) => [ "", // HERE ]); ``` Type checking works well, only autocomplete(suggestion) is disabled. |...
Hey 👋 `output` clause is supported in dialects such as [MS SQL Server (MSSQL)](). It works just like `returning`, but: - forces columns to be prefixed with `inserted` for new...
- Similar to the existing [SelectQueryBuilder.isSelectQueryBuilder](https://kysely-org.github.io/kysely-apidoc/interfaces/SelectQueryBuilder.html#isSelectQueryBuilder) property, implemented: - `InsertQueryBuilder.isInsertQueryBuilder` - `UpdateQueryBuilder.isUpdateQueryBuilder` - `DeleteQueryBuilder.isDeleteQueryBuilder` - `MergeQueryBuilder.isMergeQueryBuilder` - Implemented type predicate methods for each query builder: - `isSelectQueryBuilder(qb)` - `isInsertQueryBuilder(qb)` -...
This PR adds more tuple overloads, increasing the length from five to eight. Relates to #611.
