1 reply

insert from select

I am trying to convert a SQL query like this to drizzle:

INSERT INTO table_name (name)
SELECT
    name || ' (Copy)',
FROM table_name
WHERE id = 123;

INSERT INTO table_name (name)
SELECT
    name || ' (Copy)',
FROM table_name
WHERE id = 123;

but I really don't see how to do it without going for raw SQL.

Any pointers?