SQLite update queries do not allow table refs in SET and WHERE

[molcikas]

SQLite does not allow UPDATE queries to have table references in the SET and WHERE clauses. This causes photon to error when updating entities.

Not allowed:

UPDATE Tomato
SET Tomato.color = 'red'
WHERE Tomato.tomatoId = 9999

Allowed:

UPDATE Tomato
SET color = 'red'
WHERE tomatoId = 9999