Hey 👋

I think this might fit

const { rows } = await db.executeQuery(sql<{ result: number }>`select 1 as result`)

rows[0].result

its also good

does this still work? I am trying to do

          await trx.executeQuery(
            sql<any>`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`
          )

and I keep getting this query cannot be compiled to SQL

ok this works ok

await sql`ALTER SCHEMA "test" RENAME TO "test23"`.execute(trx)

but when I try to use variables in the template it throws

sorry for spamming. This is most likely a problem in pgPool as it has the same problem with the parameter for this query. TIL you cannot rename a schema in a stored procedure

BTW on this note, is there a way to do raw query with plain old string literal in kysely?

@capaj

ok this works ok

await sql`ALTER SCHEMA "test" RENAME TO "test23"`.execute(trx)

but when I try to use variables in the template it throws

Some engines don't support any parameters in DDL, or in some queries. Try using sql.ref or sql.raw in those interpolated positions.

BTW on this note, is there a way to do raw query with plain old string literal in kysely?

Check sql's methods. e.g. sql.raw.