Method delegate

jOOQ/src/main/java/org/jooq/impl/QuantifiedArray.java:110–169

(Context<?> ctx)

    }

    private final QueryPart delegate(Context<?> ctx) {
        if (array instanceof QOM.Array<T> a) {
            switch (ctx.family()) {

                // [#869] Postgres supports this syntax natively


                case POSTGRES:
                case YUGABYTEDB:
                    return array;

                default: {
                    Select<Record1<T>> select = null;

                    for (Field<T> value : a.$elements())
                        if (select == null)
                            select = select(value);
                        else
                            select = select.unionAll(select(value));

                    return select;
                }
            }
        }
        else {
            switch (ctx.family()) {

                // [#869] Postgres supports this syntax natively


                case POSTGRES:
                case YUGABYTEDB:
                    if (array instanceof Param && array.getDataType().getArrayBaseDataType().isEmbeddable())
                        return paramToSelect((Param<? extends Object[]>) array);
                    else
                        return array;

                // [#869] H2 and HSQLDB can emulate this syntax by unnesting
                // the array in a subselect
                case H2:
                case HSQLDB:
                    if (array instanceof Param && array.getDataType().getArrayBaseDataType().isEmbeddable())
                        return paramToSelect((Param<? extends Object[]>) array);
                    else
                        return select().from(table(array));

                // [#1048] All other dialects emulate unnesting of arrays using
                // UNION ALL-connected subselects
                default: {

                    // The Informix database has an interesting bug when quantified comparison predicates
                    // use nested derived tables with UNION ALL
                    if (array instanceof Param)
                        return paramToSelect((Param<? extends Object[]>) array);
                    else
                        return select().from(table(array));
                }
            }