Support for InsertClause.set(path, value) in select-based inserts

[Samppa Saarela]

When using insert.columns(...).select(subquery.list(...)) we lose static typing and maintaining this index-based column-value mapping is error prone. Could InsertClause be given a (sub) query as a constructor parameter and then when setting column values projection and insert values -list would be populated under the hood?

[Timo Westkämper (timo-westkamper)]

Supported now via additional constructor in SQLInsertClause :

        SQLInsertClause insert = insert(survey, sq().from(survey2));
        insert.set(survey.id, survey2.id.add(20));
        insert.set(survey.name, survey2.name);

[Timo Westkämper (timo-westkamper)]

Released in 2.2.0-beta4