import { Prisma } from '@prisma/client"
const id = "test-id";
const columns = ['column1', 'column2'].join(', ');
const values = ['val1', 'val2'].join(', ');
const sqlColumns = Prisma.sql`${Prisma.join(
columns.map((col)) => Prisma.raw(col)),
', '
)};
const sqlValues = Prisma.sql`${Prisma.join(
values.map((val) => Prisma.sql`${val}`),
', '
)};
const result = await client.$queryRaw`
INSERT INTO "Table1" (
${ sqlColumns }
)
SELECT
${ sqlValues }
FROM "Table2"
WHERE "id" = ${id}
RETURNING *
`;
import { Prisma } from '@prisma/client"
const id = "test-id";
const columns = ['column1', 'column2'].join(', ');
const values = ['val1', 'val2'].join(', ');
const sqlColumns = Prisma.sql`${Prisma.join(
columns.map((col)) => Prisma.raw(col)),
', '
)};
const sqlValues = Prisma.sql`${Prisma.join(
values.map((val) => Prisma.sql`${val}`),
', '
)};
const result = await client.$queryRaw`
INSERT INTO "Table1" (
${ sqlColumns }
)
SELECT
${ sqlValues }
FROM "Table2"
WHERE "id" = ${id}
RETURNING *
`;