Custom Plugin to transform Alias.* to "Alias.Column1", "Alias.Column2", etc.
Hi everyone, in the previous question, I asked how to transform the following syntax into a new one. I was adviced to create my own plugin serializer (example: https://github.com/subframe7536/kysely-sqlite-tools/tree/master/packages/plugin-serialize). However, I still struggle with how to do it. Can anybody please give me a hint? I'll do it later by myself but need a guide how to start.
Thank you very much!
input syntax:...
can kysely be extended with custom types within the database
hi. i would like to extend my database with custom types (a date type for sqlite) so that it is easier to work with. i would assume that conversion to sql would be easy since its just a stringify operation using sql template tags, but is there a way to automatically convert from the database results, i.e. parse a ISO string into a Date object?
newbie need help with json_build_object
Hi! Just starting with kysely and encountered problem I cant solve. I want to build raw query with kysely builder...
this part gives me trouble. I would be grateful for your help...
JSON_BUILD_OBJECT('id', unit.id, 'name', unit.name) AS unit
JSON_BUILD_OBJECT('id', unit.id, 'name', unit.name) AS unit
Solution:
Here you go https://kyse.link/DqXNv
Note that the properties are nullable in the selected
unit object because you're using left join. The types are correct. If you are sure there's a unit for each sku then use innerJoin instead....Solved: Exporting query builder classes
I saw this PR https://github.com/kysely-org/kysely/pull/763 where you guys have decided not to export classes as they are private.
Is there any specific reason for which you don't want to make these classes public? Because if you change the public API of these classes, then anyways the query builder will be impacted by the change....
building kysely makes the package size very large
hi. i'd be more than happy to figure this out because i like kysely a lot more than drizzle. the thing was that the package size was so much larger with drizzle. i made a repro here. when running
bun build --minify --outfile, i get kysely to be 340.40kB whilst drizzle is 55.35kB, meanwhile the functional code besides the database is identicalKysely setup in monolith API
Hello, we have a basic http server with a basic router and a PostgreSQL database. We're wondering what is the proper setup to use the Kysely client in our routes to make calls to the database. Should there be a singleton client that is used across routes, or do we need to instantiate a kysely client on every request ?
Is it possible to get the total count while fetching rows in a single query?
I have a query which looks like this:
```typescript
const { items, count } = await db
.selectFrom(eb => eb
.selectFrom("ads")...
Separating results of join into objects of each type
Hey guys, I'm curious if anyone knows a way to unmerge the results of a join into objects of both types. For example, if you have a table User and table Bio, and query a single row which joins those two, the result is an a flat object with keys from both tables. What I'd like to do is separate the result into a User object and Bio object.
Solutions that work but I don't love:
1. manually extracting values from the object based on the current schema. (future changes to schema will break this, so I'd like to avoid that)...
Snippet compilation
Hi, is it somehow possible to get only part of the compiled code to use it as snippet in ORM? Or vice-versa is it possible to build only part of the code with type helpers and compile them without the parent query?
For example I would like to get only the code for the header_index and header_order aliases:
```...
Solution:
There are many ways to do this, but here are couple of them: https://kyse.link/Ion4f
Creating an 'enum' type column
Hi all,
Trying to re-create this MySQL in Kysely
```
......
Solution:
Like this:
```ts
await trx.schema
.createTable("expected_available_songs")...
Error when destructuring QueryCreator in withRecursive
I'm new to Kysely and attempting to migrate a Next app from prisma to kysely. I've generated types, successfully run some simple queries, and now I'm experiencing an error (in the title) that I'm unsure how to debug with a more complex recursive query.
Here's a playground link to demonstrate: https://kyse.link/ZD1EV
Can anyone help point me in the right direction? I cobbled this query together based on other examples I found but I haven't found anyone else with this error....
Is `sql.join` the best way to concatenate sql templates?
I have some business logic that incrementally builds up a sql WHERE query as a string. It looks like I can't do the dumb thing and just string concat the pieces together like so:
...
let q = sql.raw` noteFtsFv.rowid ` + sql.raw` in `
let q = sql.raw` noteFtsFv.rowid ` + sql.raw` in `
Multiple calls to values in insert statement?
I just had a production bug where I was calling
.values multiple times on a query object. I've fixed it by passing an array to a single values call instead, but this seems like a bug no? Either the types should reflect that values can no longer be called after it has been, or it should collect the values calls into one array?using pgvector with Kysely
Following the example here: https://github.com/pgvector/pgvector-node?darkschemeovr=1#kysely
But I get the error
ERROR: column "embedding" is of type vector but expression is of type character varying
Happy to provide code if necessary but there aren’t any differences from the tutorial ...Solution:...
// Replace `string` with the type you have in the table interface.
sql<string>`${sql.ref(column)} <=> ${toSql(value)}::vector(3)`
// Replace `string` with the type you have in the table interface.
sql<string>`${sql.ref(column)} <=> ${toSql(value)}::vector(3)`
Static/reusable custom window functions
Hello, I'm trying to buld a properly typed
array_agg window function and would like to reuse the existing FunctionModule in a reusable way, so to have orderby, over, and so on.
Is there a way to get the function module you get from fn.agg outside of an expression builder and without creating a puppet kysely instance, so to create an array_agg function and return what fn.agg return but properly typed?
As an example:...
How to loop an array and based on this create a dynamic CTE but preserve type ?
``ts
for (const [references, columns] of referencesArray) {
const newQb = qb.with(cte_${references}`, (wb) => {
wb = wb.selectFrom(references).distinct().selectAll(references);
for (const column of columns) {...Solution:
It's impossible to do this while keeping the types. Not only because of Kysely but also because of typescript.
- You can't change the type of a variable in typescript.
- You can't turn a
string into a string literal.
- Even if your strings had string literal types, you couldn't loop over them...On Conflict do update set ALL to be inserted columns
Here I am once again with a question for the on conflict bit in postgres. Would there be a way to automatically compose an update set statement for the on conflict do update bit with the information about all the columns we're going to insert, and automatically do an update with the
excluded for those?
Example here...How to use kysely in edge runtime (like NextJS 14 middleware)?
Error: The edge runtime does not support Node.js 'crypto' module.
Learn More: https://nextjs.org/docs/messages/node-module-in-edge-runtime
Full log: https://pastebin.com/JSXBNRxv
...
how to write not (array1 && array2)
Hi again,
how to write following code? I would love to use not(expression)
Expected result:...