kysely
kysely copied to clipboard
kysely-org
A type-safe typescript SQL query builder
# Introduction The goal of this proposal is to introduce a mechanism for defining type-safe code examples. # Problem Our code examples are not type safe. This means we can...
 Need to host the logos instead of using external URLs, other than that, pretty much done. Logos order: 1. core dialects. 2. by revenue / funds raised - as...
This PR makes `SchemaModule` optional and injectable when instantiating Kysely. If not injected and consumer tries accessing it, a runtime error is thrown. 99% of the time, DDL queries are...
as requested by @ethanresnick on discord. Real-world use case: knowing you're exposing a Kysely instance that's connecting to a read replica, or uses a user that only has read permissions,...
Hi, We are currently trying to have a custom migration that runs everytime `reagardless` the current migration step. This migration will hold the last version of some `stored procedure`. These...
In PostgreSQL and SQLite the `ORDER BY` clause accepts a sorting configuration to override default behaviour. Currently, only two arguments can be passed - the value on which to order...
Hey 👋 `within group` is a clause that allows ordering the aggregated data, usually found in concat-like functions. This clause is supported in: - PostgreSQL's [`rank`](https://www.postgresql.org/docs/current/functions-aggregate.html#FUNCTIONS-ORDEREDSET-TABLE). - MSSQL's [`string_agg`](https://learn.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-ver16#f-generate-a-sorted-list-of-emails-per-towns). -...
Hey 👋 Following #779, we might want to allow chaining `.orderBy` where `.distinct` is invocable in `eb.fn.agg`. Example aggregate functions where `order by` can be used inside the argument scope:...
Hey 👋 As pointed out by Alzoom [on discord](https://discord.com/channels/890118421587578920/1108502183982420028), alter index is a query that's supported in [postgres](https://www.postgresql.org/docs/current/sql-alterindex.html), [mssql](https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql?view=sql-server-ver16) and [oracle](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-INDEX.html). Dropping and recreating an index, if possible, should probably...
Currently executing raw queries has the following structure ```ts sql`SELECT 1 AS result`.execute(kysely) ``` It would be nice to have it the other way around as well as people naturally...
