Method parseInsert

jOOQ/src/main/java/org/jooq/impl/ParserImpl.java:2440–2616

(WithImpl with, boolean parseResultQuery)

    }

    private final Query parseInsert(WithImpl with, boolean parseResultQuery) {
        scope.scopeStart();
        parseKeywordUndocumentedAlternatives("INSERT", "INS");
        parseKeywordIf("INTO");
        Table<?> table = parseTableNameIf();
        if (table == null)
            table = table(parseSelect());

        Name alias;
        if (parseKeywordIf("AS"))
            table = table.as(parseIdentifier());
        else if (!peekKeyword("DEFAULT VALUES", "SEL", "SELECT", "SET", "VALUES")
            && (alias = parseIdentifierIf()) != null)
            table = table.as(alias);

        scope.scope(table);

        InsertSetStep<?> s1 = (with == null ? dsl.insertInto(table) : with.insertInto(table));
        Field<?>[] fields = null;

        if (!peekSelectOrWith(true) && parseIf('(') && !parseIf(')')) {
            fields = parseList(',', c -> parseField()).toArray(EMPTY_FIELD);
            parse(')');
        }

        InsertOnDuplicateStep<?> onDuplicate;
        InsertReturningStep<?> returning;

        try {
            // [#11821] The Teradata INSERT INTO t (1, 2) syntax can be recognised:
            //          When there are non-references fields
            boolean hasExpressions = anyMatch(fields, f -> !(f instanceof TableField));

            if (hasExpressions || parseKeywordIf("VALUES")) {
                List<List<Field<?>>> allValues = new ArrayList<>();

                if (hasExpressions) {
                    allValues.add(asList(fields));
                    fields = null;
                }

                valuesLoop:
                do {
                    if (hasExpressions && !parseIf(','))
                        break valuesLoop;

                    parse('(');

                    // [#6936] MySQL treats an empty VALUES() clause as the same thing as the standard DEFAULT VALUES
                    if (fields == null && parseIf(')'))
                        break valuesLoop;

                    List<Field<?>> values = parseList(',', c -> c.parseKeywordIf("DEFAULT") ? default_() : c.parseField());

                    if (fields != null && fields.length != values.size())
                        throw exception("Insert field size (" + fields.length + ") must match values size (" + values.size() + ")");

                    allValues.add(values);