Folks,
I noticed that the following simple *SqlQuery* doesn't not work:
SELECT * FROM Employee e
The reason is that it is incorrectly expanded to
SELECT *Employee*._KEY, *Employee*._VAL FROM Employee *e*
... while correct form should be:
SELECT *e*._KEY, *e*._VAL FROM Employee *e*
I understand
Sergi,
This problem is more about aliases, then about "SELECT *". The query
FROM Employee e
doesn't work either. And this is the problem, because as soon as JOINs
appear, aliases greatly help to reduce SQL boilerplate. And as I understand
it is hard to make this query work due to complex
Use SqlFieldsQuery, Luke! I tried, it works! :)
I was always against SELECT in SqlQuery, it was terrible design decision,
but for "historical reasons" it is supported in SqlQuery.
As for adding new parsing, the more fancier parsing we will introduce, the
worse performance we will have.
Sergi