I have a sqlite database connected via JDBC. Of all the tables, only one is read-only in Base. The only difference I see is that this read-only table wasn’t created with an explicit Primary key field, it just uses the implicit rowid created automatically for every table.
I can run Insert and Update SQL commands directly via Tools > SQL… But when I open the table the edit controls are disabled.
What could be the reasons for this? Is this indeed caused by the absence of an explicit Primary key field?