MySQL - Avoid duplicate column id issue

In our project, we needed to overcome this issue. It happens when MySQL is not able to distinguish columns with the same name, even if they belong to different database tables. Accordingly to Outsystems support team investigation, this issue might occur unexpectedly.

To overcome this, we needed to add a alias for each column that share the same name with different tables (column id). I suggest that the platform automatically does that generating for each column an alias (format e.g. tablename_columnname). This way, it would work just fine without developers need to worry about this