K
Kysely•11mo ago
decho

Modifying the return type of a query

I have a question, hopefully it's not a silly one. So I have generated types for my DB (via kanel-kysely), one of which is for a materialized view, and as such all columns of that view are generated as nullable. (I think that's just some Postgres weirdness, not related to kysely or kanel). I also have a function that runs a query and selects all from that view, and I am wondering if there is any way to modify that in kysely land so that the returned type has all of these columns as non-nullable. Here is a super basic example: https://kyse.link/?p=s&i=EBBWymS9HA2FBdR6X73o Basically I'm asking if there is a way to change the query so that all nulls from the column types are excluded.
Solution:
Hey 👋 Not a silly one at all. 🙂 You could use .$narrowType to narrow the result type in a type-safe way....
Jump to solution
2 Replies
Solution
Igal
Igal•11mo ago
Hey 👋 Not a silly one at all. 🙂 You could use .$narrowType to narrow the result type in a type-safe way.
decho
decho•11mo ago
oh nice, i will give that a try scanned the docs but couldn't find anything ok yep, that totally worked, thank you very much! going to leave a playground link with 2 solutions in case someone stumbles upon this in the future: https://kyse.link/?p=s&i=GQiHk3ruwxIjsU9RYJfk
Want results from more Discord servers?
Add your server
More Posts
Access column type in custom pluginHey! We would like to access the column type in one of my custom Kysely plugins. The AST does not Unions in a loopI'm trying to do a UnionAll in a loop. My issue is I don't know how to initialise the query: ``` where array_field has enum valueHello there 👋 Today I'm experimenting with kysely, coming from prisma. I got stuck on rewriting tNOW() function in kyselyFor instance, this statement is valid on Postgres: `INSERT INTO films VALUES ('UA502', 'Bananas', 10issue with complied sql when doing + interval operationHey, I have a query that is generated using kysely where I select the following field sql that I getcamelCase plugin with a strangely named columnWe have a column named `cl_companyID` (I'm as confused as you) and I have issues with the camelCase Feature/Question: Would like to execute query with Prisma.$queryRaw or $executeRawI use prisma-kysely to generate my kysely types and i find this to be a great workflow. I still likeKysely not calling 'init' for Driver (?)Hi all, preface this by saying I am starting out with Kysely and I might be making a dumb mistake 😄Build a basic Kysely PluginHi, I need some help with a basic plugin I want to build. It's an encrypt/decrypt plugin. This is hDeleting multiple rows at onceI have a question, if I have like ```ts await db .deleteFrom('person') .where('groupId', '=', id