I'm trying to reproduce this query from the Postgres docs:
WITH moved_rows AS (
DELETE FROM products
WHERE
"date" >= '2010-10-01' AND
"date" < '2010-11-01'
RETURNING *
)
INSERT INTO products_log
SELECT * FROM moved_rows;
Can Korma actually do it (besides just writing raw SQL, of course)? I see no mention of it in the docs.
Thanks...