Generating dynamic raw query help

Hello, we are trying to create a function utility to call RPCs, we want to dynamically generate the following SQL query:

SELECT my_function(arg1 => 'some_value', arg2 => 123);

SELECT my_function(arg1 => 'some_value', arg2 => 123);

We are trying the following

input = Object.entries(payload).map(([key, value]) => {
  return sql`${sql.raw(key)} => ${sql.val(value)}`;
});

const x = sql`SELECT ${sql.raw(name)}(${sql.raw(input.join(','))})`;

input = Object.entries(payload).map(([key, value]) => {
  return sql`${sql.raw(key)} => ${sql.val(value)}`;
});

const x = sql`SELECT ${sql.raw(name)}(${sql.raw(input.join(','))})`;

But the outputs have been things like:

SELECT my_function($1, $2)

SELECT my_function($1, $2)

SELECT my_function([object Object],[object Object])

SELECT my_function([object Object],[object Object])

Is there a Kysely helper function to generate the

arg1 => 'some_value', arg2 => 123

arg1 => 'some_value', arg2 => 123

section of my query, or how should I go about it? Thanks for any help!

Kysely•13mo ago•

3 replies

bombillazo

Generating dynamic raw query help

Hello, we are trying to create a function utility to call RPCs, we want to dynamically generate the following SQL query:

SELECT my_function(arg1 => 'some_value', arg2 => 123);

SELECT my_function(arg1 => 'some_value', arg2 => 123);

We are trying the following

input = Object.entries(payload).map(([key, value]) => {
  return sql`${sql.raw(key)} => ${sql.val(value)}`;
});

const x = sql`SELECT ${sql.raw(name)}(${sql.raw(input.join(','))})`;

input = Object.entries(payload).map(([key, value]) => {
  return sql`${sql.raw(key)} => ${sql.val(value)}`;
});

const x = sql`SELECT ${sql.raw(name)}(${sql.raw(input.join(','))})`;

But the outputs have been things like:

SELECT my_function($1, $2)

SELECT my_function($1, $2)

SELECT my_function([object Object],[object Object])

SELECT my_function([object Object],[object Object])

Is there a Kysely helper function to generate the

arg1 => 'some_value', arg2 => 123

arg1 => 'some_value', arg2 => 123

section of my query, or how should I go about it? Thanks for any help!

Generating dynamic raw query help

Similar Threads

Generating dynamic raw query help

Similar Threads

Similar Threads

Similar Threads