Recently I was in the "My Virtual Assets" dashboard and I tried to add the "Type" field to the list of virtual assets I managed. As soon as I did this I could no longer see my list of virtual assets and instead started seeing this issue (Syntax Error or Access Rule Violation detected by database (unknown column)):

With the help of support, we were able to determine that the "Type" field was a reference field that pointed to no table at all. If you were to look at that field in the dictionary it would show this:

The fix was to assign some table (any table) to that reference field for this particular column. This can show up in a variety of cases, but the cause is the same. If you add a field to a list that is a reference make sure it actually references a table. Cheers.