sql - " insert into select " query in korma -

sql - " insert into select " query in korma -

insert customers (customername, country) select suppliername, country suppliers;

customer table has other columns except "customername" , "country"

this simple sql query.

please help me write in korma sql.

you can same sql:

; assuming define entities, customer, suppliers (insert customers (values (select suppliers (fields :suppliername :country))))

sql postgresql korma sqlkorma