K
Kysely•13mo ago
djMax

create role in migration

Is it possible to create a role in a migration? And to do the grants and things as part of that?
1 Reply
Igal
Igal•13mo ago
Hey 👋 There is no built-in support for such queries. You can execute raw SQL queries using the sql template tag: 
import { sql } from 'kysely'

await sql`MY QUERY`.execute(db)
import { sql } from 'kysely'

await sql`MY QUERY`.execute(db)
Want results from more Discord servers?
Add your server
More Posts
How to insert JSONB types in postgres?I've looked at https://kysely-org.github.io/kysely/classes/InsertQueryBuilder.html#values and it's nQuerying two different tables with subset of common columnsI have two tables that have an intersection of common columns that I'm looking to query. For each ofHow to select from a function with parameters?I understand that `kysely` will not natively support stored procedures / functions, and was wonderinIn a transaction, how do you ignore generated field requirements?``` export interface TextDocumentTable { id: Generated<number>; created_at: Generated<Date>; } Cross database joins in MySQLHi all, Is it possible to do joins across databases within the same MySQL instance? i.e ```sql SELEC.where('x', 'is not', null) and correspond type's nullabilityNot sure if this even possible in typescript (although all of the work Kysely already makes it seem What is the suggested way of adding/removing methods to expression builders?Context: I am building a custom dialect for YDB https://github.com/Gaspero/kysely-ydb YDB is slightlRunning database agnostic queries (MySQL)As part of my test suite, I drop/create databases programmatically. Is it possible to have a Kysely