[GIS] Primary key field hidden on attribute table added to QGIS

attribute-tableqgis

I'm having the following issue with QGIS. Adding a sqlite text table (Layer > Add Vector Table) QGIS hides the primary key field (having name id). I understand also QGIS uses this field as unique id, but I need to have it in the attribute view because all my links and joins use this field.
I'm not able actually to perform a join with my vector tables.
I can neither change the column names, nor create views.

Best Answer

Although your question has already been answered in the comments. Why don't just add a new field to the attribute-table with the same name and select $id (or $rownum) as input in the field-calculator?

Something like this: enter image description here

Related Question