I believe to remember there have been feature requests, about the
placement options for the * in the select
( http://bugs.mysql.com/bug.php?id=26066 )
currently the * must be the first in the list.
select *, field from table => ok
select field, * from table => not ok
This appears to be fixable in the parser with little effort.
So the questions are:
- Is it SQL standard conform?
- Is it a feature that would be wanted?
If it is "yes", I can supply a patch.
One more question, if "yes"
"select *, * from table" be allowed?
My first thought would be "no", but then you can already do:
"select table.*, table.* from table from table"