Investigating deeply, I've found that it depends by the existence of fkInternalCalc fields.
The same wrong behavior exists yet in Delphi 12.2, while in Delphi 10.2 Tokyio the same DOA 4.1.4 works good.
I also verified that if use the same query + fields in FireDac TFDQuery it works good.
To...