SQLite.swift icon indicating copy to clipboard operation
SQLite.swift copied to clipboard

Add "columns" to insert(_ query: QueryType)

Open venkr opened this issue 2 years ago • 0 comments

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

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)

venkr avatar Mar 09 '23 14:03 venkr