Group By On A Unique Column

Hello!

This is not really a question, maybe a start of discussion if this could be a feature in coming versions...

Let's say I have a table like this:
id text1 text2
int varchar varchar

1 abc ghi
2 abc ghi
3 def ghi

and I want to query using group by, I would write SELECT text1, text2 FROM table GROUP BY text1, text2

This is not too bad, but imagine I got several columns of text I need to query, then I need to put them in both places, SELECT and GROUP BY. If I do use functions like SUBSTRING or concatenation on the columns, I need to repeat these in the GROUP BY as well.

It would be nice if I could say "GROUP BY id", and since id is unique on the table it is obvious that all columns taken from this table are already grouped and can be queried without having to have them in group as well.
For functions this is of course only possible if all parts only refer to columns from this table, or absolute entries, like LEFT(varchar ,3) or int+1 or such.


With this example, the benefit is not visible: if I added the id to the GROUP BY, I get every single row of course. GROUP on unique is useless... It does make sense if you query another table and join in this one as a lookup, and the id gets "multiple" this way.

As I said, just an idea to make the GROUP BY section more transparent and avoid repeating sections!

I'd like to know what you think of that.
Ralf