Urgent, scriptcase changes field names when we nest multiple SELECT

When in the SQL Select Statement, in the SELECT I write another SELECT, example:

SELECT p.Code, p.Description
, (SELECT SUM (g.Giacenza) FROM Giacenze g
WHERE g.CodProdotto = p.Codice) AS giacdepo
FROM Products AS p
LEFT JOIN FamPrd fp ON fp.Codice = p.CodFamiglia

scriptcase changes the name of the fields (Grid/Fields), transforming them from p.Code, p.Description TO Code, Description. This involves a big problem as it is necessary to modify the whole application and the formulas to adapt them to the new names.