'why is group a wrong alias in postgres + Django for auth_group table

Why is that the following simple query does not work (Using Django in the backend)

# select group.name from auth_group as group;
ERROR:  syntax error at or near "."
LINE 1: select group.name from auth_group as group;

while the following works

# select groupd.name from auth_group as groupd;
     name      
---------------
 FO Admin Role
 admin
 alice
 bob
(4 rows)

What is wrong with using group as an alias ?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source