So I do a 'single' SQL query like select * from table a, table b where a.id = b.extid. When I try to edit the result I get "table is read-only. unresolved table reference'.
I understand the limitation is probably because I'm running a custom SQL but I'm wondering if there is a way to workaround this and make it editable? I tried adding PK and FKs to the resultset but with no luck.