Oracle query aggregation generates "AS" for alias table name

[mborgues]

"AS" for table name is not supported in Oracle, is it generated by nest-query or TypeORM?
Is there any solution for this?

Without "AS"

[TriPSs]

I think this is something TypeORM does but i'm not 100% sure. Looking at the outputted query I'm also wondering what version of the lib you are running? The __nestjsQuery__entityIndex__ should almost never be used anymore I think as it was removed for the majority of the queries because of performance drawbacks.

[TriPSs]

Could you test this comment?

[mborgues]

Doesn't worked:

[TriPSs]

Aah yea, just now I see that that flag only affects the group by of dates, sorry! Think for this to work a custom implementation for Oracle needs to be made in filter-query.builder.ts:242:

return aggregatedGroupBy.reduce((prevQb, aggregatedField) => {
      return prevQb.addGroupBy(prevQb.escape(AggregateBuilder.getGroupByAlias(aggregatedField.field)))
}, qb)

return aggregatedGroupBy.reduce((prevQb, aggregatedField) => {
      return prevQb.addGroupBy(prevQb.escape(aggregatedField.field)))
}, qb)

You could try something like this and if it works create a patch for it inside your repo.

[mborgues]

Thanks for the help, I will need to study your framework a little more to make the adjustment, because with the change in the way you mentioned it uses the name of the property and not the name of the column in the database, I still need to generate the field as in the select, for example group by "ModeloVeiculoTerceiroEntity"."CODIGOMODELOVEICTER" and not group by "codigoVeiculoTerceiro", but for now I have a working solution until I managed to do this.

[mborgues]

Sorry, now that I saw that the function parameters already have the necessary information, here is the function that adjusts without any problems:

applyAggregateGroupBy(qb, aggregatedGroupBy, alias) {
    if (!aggregatedGroupBy) {
        return qb;
    }
    return aggregatedGroupBy.reduce((prevQb, aggregatedField) => {
        const column = `${alias}.${aggregatedField.field}`;
        return prevQb.addGroupBy(column);
    }, qb);
}