_id column when working with external SQL DB has encoded id value

[poirazis]

When you query a table that is an external sql table, you always get back a column "_id" ammended, but the value in that column is not the value of the id, but rather a string encoded. So , if you attemp to update / delete record using that "_id" added column, the operation will fail as that column doesnt actually exist nor the value in it represents the actual id.

This ammended column, also appears in the "field" property types, to be selected.

Is this ammeded column necessary ? If it is, shouldnt it be holding the same value as the id column ?

[linear[bot]]

BUDI-8784 _id column when working with external SQL DB has encoded id value