index - @kysely/kysely - JSR

A type-safe TypeScript SQL query builder
Thrown when the database rolls back a transaction instead of committing it.
Simply calls the provided function passing this as the only argument. $call returns what the provided function returns.
Casts the expression to the given type.
Omit null from the expression's type.
Returns an aliased version of the function.
Clears the order by clause from the query.
Adds a distinct clause inside the function.
Adds a filter clause with a nested where clause after the function.
Adds a filter clause with a nested where clause after the function, where both sides of the operator are references to columns.
Adds an order by clause inside the aggregate function.
Adds an over clause (window functions) after the function.
Creates the OperationNode that describes how to compile this expression into SQL.
Adds a withing group clause with a nested order by clause after the function.
AggregateFunctionBuilder with an alias. The result of calling AggregateFunctionBuilder.as.
Creates the OperationNode that describes how to compile this expression into SQL.
Creates the OperationNode that describes how to compile this expression into SQL.
Creates the OperationNode that describes how to compile this expression into SQL.
Simply calls the provided function passing this as the only argument. $call returns what the provided function returns.
Allows us to force consumers to do exactly one alteration to a column.
This builder can be used to create a alter table query.
Calls the given function passing this as the only argument.
See CreateTableBuilder.addCheckConstraint
See CreateTableBuilder.addColumn
See CreateTableBuilder.addForeignKeyConstraint
This can be used to add index to table.
See CreateTableBuilder.addPrimaryKeyConstraint
See CreateTableBuilder.addUniqueConstraint
This can be used to drop index from table.
Creates an alter table modify column query. The modify column statement is only implemeted by MySQL and oracle AFAIK. On other databases you should use the alterColumn method.
See CreateTableBuilder.addColumn
Creates an alter table modify column query. The modify column statement is only implemeted by MySQL and oracle AFAIK. On other databases you should use the alterColumn method.
Change the output type of the expression.
Combines this and another expression using AND.
Returns an aliased version of the expression.
Creates the OperationNode that describes how to compile this expression into SQL.
A plugin that converts snake_case identifiers in the database into camelCase in the JavaScript side.
This is called for each query before it is executed. You can modify the query by transforming its OperationNode tree provided in args.node and returning the transformed tree. You'd usually want to use an OperationNodeTransformer for this.
This method is called for each query after it has been executed. The result of the query can be accessed through args.result. You can modify the result and return the modifier result.
Adds a when clause to the case statement.