Another problem I face is that all the fields should be searchable, but as you can see, some fields come from different tables.
So what would you suggest?: add the table name to the select statement, then extend the select statement of a class to show this data?
even if I add the table name, I can't define a primary key. I think one of the key problems is not having a primary key.