Primary key field hidden on attribute table added to QGIS

Question

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.

Answer 1

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:

Answer 2

I could analyze your problem a bit:

http://comments.gmane.org/gmane.comp.gis.qgis.user/18353

Adding the table to a sqlite database with already existing geometry tables solved the problem. And I used Add sqlite database (geometryless), not Add vector table.