When creating a view, it would be easier if we could use the following syntax:
create view V_NAME as
create view V_NAME (FIELD1, COLUMN_ALIAS1, COLUMN_ALIAS2) as
Since a select command can't repeat a column alias, this field list could be optional.
And it will be much easier to store view definitions on some database modelling tools.