in table I have a several columns which are related to address ( street, city, zip code etc.)

How define 'constant alias' in table when set a query like 

```
select adress from table  ;

```

?
which will replace by query:

```
select concat( zip_code, ' ', city, '; ', street ) adress from table   

```

I would like to prevent using concat statement in each query.