Kysely•2y ago

Error this query cannot be compiled to SQL

I am trying to do

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

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

anybody have an idea how to do this query?

Solution:

I the end I went with

``ts
 await sql
           .raw(

ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`) .execute(trx)...

Jump to solution

7 Replies

koskimas•2y ago

Subtitutions are by default treated as values and passed as parameters. You want identifiers here. You can use sql.id

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

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

another way is to just run a completely raw query

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

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

capajOP•2y ago

this still throws

this query cannot be compiled to SQL

this query cannot be compiled to SQL

capajOP•2y ago

also TS is not happy about this

Solution

capaj•2y ago

I the end I went with

 await sql
           .raw(`ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`)
            .execute(trx)

 await sql
           .raw(`ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`)
            .execute(trx)

koskimas•2y ago

Yeah, I'm not sure executeQuery should even work with raw SQL. Is it even public interface? It is It should probably work

capajOP•2y ago

no worries, DDL queries are quite an edgecase for most query builders

koskimas•2y ago

Hmm.. The function takes a CompiledQuery or a Compilable. RawBuilder (returned from sql) shouldn't be either. I'll take a look at this. Something funky here

Gaming

Programming

Error this query cannot be compiled to SQL

Did you find this page helpful?