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:
(right now there's no sql.fn forcing you to use a kysely instance or an expression builder to access the fn function module)Kristian Notari•73d ago
Also, I noticed there's no way to accomplish the following if I'm right:
cause the
orderBy bit is only available after applying a over partitioning. Is that correct?1.4KMembers
View on DiscordWant results from more Discord servers?
More PostsIs the Kysely main site down?I just want to confirm if Kysely's main site is downOn Conflict do update set ALL to be inserted columnsHere I am once again with a question for the on conflict bit in postgres. Would there be a way to auHow 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/dochow to write not (array1 && array2)Hi again,
how to write following code? I would love to use not(expression)
Expected result:
```
noPartial compileHello everyone, is it possible (somehow) to generate only part of the compiled query? I have an edgeQuerying on jsonArrayFromHi. So i need to fetch posts with comments from a database that are written by a set group of author