Open venkr opened 1 year ago
It's currently not possible to specify which columns to insert into, requiring some hacky manually crafted strings.
Specifically, I'm looking to execute queries of the form: INSERT INTO table_1(a,b,c) SELECT d, e, f from table_2
INSERT INTO table_1(a,b,c) SELECT d, e, f from table_2
Today it is only possible to run queries of form: INSERT INTO table_1 SELECT d, e, f from table_2 (or insert using literals)
INSERT INTO table_1 SELECT d, e, f from table_2
It's currently not possible to specify which columns to insert into, requiring some hacky manually crafted strings.
Specifically, I'm looking to execute queries of the form:
INSERT INTO table_1(a,b,c) SELECT d, e, f from table_2Today it is only possible to run queries of form:
INSERT INTO table_1 SELECT d, e, f from table_2(or insert using literals)