K
Kysely•8mo ago
bombillazo

Relational table join question

Hey, just out of curiosity, does Kysely have any helpers for joining tables across a relational table? For example, if I have tables user and account joined via the user_account relational tables, if I use jsonArrayFrom from a query on the user table to get accounts, do I always need to do a join with the intermediary table or does Kysely provide any type of shortcut for this?
3 Replies
Unknown User
Unknown User•8mo ago
Message Not Public
Sign In & Join Server To View
bombillazo
bombillazo•7mo ago
how would this help for joining 2 tables through the intermediary relation table ?
Igal
Igal•7mo ago
Hey 👋 No, Kysely doesn't have M:N helper.
Want results from more Discord servers?
Add your server
More Posts
Raw SQL in select type to numberHellow, I have the following sql expression in a select statement array: ```ts sql<number>`(${sql.rSelect by id?With this code: ``` export const getProductById: RequestHandler = async (req, res, next) => { conWhy has the json_agg and to_json call functions not been released?Hi Recently I have favored Kysely. I would like to implement a query that calls to_json using kyseWhy jsonArrayFrom converts a Generated<number> field into string | number?Look at this pickysely uses prepared statements like knex?im planning use rds proxy and prepared statements pin connectionHow to improve performance in large SELECT?I have a large query with >100 selections, this makes VS Code hangs for type checking every 30s. I Type inference of queries with expressions in WebstormWebstorm reports that the type of `const result = await selectable.select(({ eb }) => eb(eb.fn.counHow to compose functions?I have been unable to calculate `select count(id) > 0 from foo`. I tried this: `.select(({ eb }) =>How do I create a helper to be used on a select array of fields?I want to create a toBool helper to convert from tinyint, however I'm lost on the type I need to pasHow do I cast the type of a eb.fn('...') ?I tried with eb.fn<string>("CONCAT", [....]) but it didn't worked