K
Kysely•6mo ago
Robin

Arbitrary insert statement

I have a bit of an edge case where I want to build a query that is dynamic based on user input (it's part of an interactive tutorial). Is there a way to build an insert statement where the object name is an arbitrary string? Alternatively, is there some way to do this with sql framemgents, but still make the value a parameter? I'm imagining a sql.parameter function, but I don't see anything like that in the docs.
Solution:
Everything is a parameter by default when you use the sql tag. 
sql`insert into foo (id) values (${id})`.execute(db)
sql`insert into foo (id) values (${id})`.execute(db)
...
Jump to solution
3 Replies
Solution
koskimas
koskimas•6mo ago
Everything is a parameter by default when you use the sql tag. 
sql`insert into foo (id) values (${id})`.execute(db)
sql`insert into foo (id) values (${id})`.execute(db)
id in that example is sent as a parameter. It's not interpolated to the SQL.
koskimas
koskimas•6mo ago
Alternatively you can use Kysely<any> to build any insert query https://kyse.link/?p=s&i=DCFGKru80WvqqZ9KXBMd
Robin
Robin•6mo ago
Oh great! I don't know why I thought directly interpolating like that wouldn't work.
Want results from more Discord servers?
Add your server
More Posts
How to handle versioning of database objects.Hello, i want to add versioning for my QuizTemplates. I have an idea with revision field. I want toSqlite JSONHello, I'm a new user to Kysely and I'm having trouble using the JSON interface. I would normally jwhy does `fn.countAll` return `bigint` ?need it to return a numbercase() return boolean (castTo doesn't work?)Hiya! I'm trying to determine if what I'm doing is currently possible I have the following expressiTINYINT convert to boolhello, i am using kysely with a mysql dialect and i find myself in a situation where some fields in CASE with subquery clauseHow can I return the column value from the subquery in a CASE? With this example, Kysely thinks the Ad hoc custom column typeHello, we have a table that on the database level, the column is a string type, but on the typescripCreating a table within a schema using a column from a table in another schemaI'm using two schemas and I want to create a table in one of them with a column referencing a columnGuidance to create a generic wrapper over KyselyI am trying to create a generic authentication wrapper over Kysely. The idea is - You can pass someAny way to docutype a Column as `@deprecated`?Hello, We'd like to have columns we specify in out types with the `@deprecated` type identifier in t