Method accept

jOOQ/src/main/java/org/jooq/impl/JSONBKeys.java:137–195

(Context<?> ctx)

    }

    @Override
    public final void accept(Context<?> ctx) {
        switch (ctx.family()) {








            case POSTGRES:
            case YUGABYTEDB: {
                if (NO_SUPPORT_PATH_QUERY.contains(ctx.dialect()))
                    ctx.visit(DSL.field(select(DSL.coalesce(jsonArrayAgg(DSL.field(unquotedName("j"))), jsonArray())).from("json_object_keys({0}) as j(j)", field)));
                else
                    ctx.visit(function(N_JSONB_PATH_QUERY_ARRAY, getDataType(), field, inline("$.keyvalue().key")));
                break;
            }













            case SQLITE:
                ctx.visit(DSL.field(select(jsonbArrayAgg(DSL.field(name("key")))).from("json_each({0})", field)));
                break;







            case DUCKDB:
                ctx.visit(function(N_TO_JSON, getDataType(), function(N_JSON_KEYS, VARCHAR.array(), field)));
                break;

            case CLICKHOUSE:
                ctx.visit(function(N_toJSONString, getDataType(), function(N_JSONExtractKeys, OTHER, field)));
                break;

            case TRINO:
                ctx.visit(DSL.cast(function(N_MAP_KEYS, OTHER, DSL.field("cast({0} as map(varchar, json))", OTHER, field)), JSON));
                break;

            default:
                ctx.visit(function(N_JSON_KEYS, JSONB, field));
                break;
        }