I query data from multiple tables using JOIN statements like this :

```
SELECT u.id,u.name,d.id,d.name FROM user u RIGHT JOIN dog d ON... ;

```

When I get the answer, in psql for example, I've got this kind of rows title :

```
|  id   | name  |  id  |  name  |
+-------+-------+------+--------+

```

Instead, I'd like to get the original and precise notation :

```
|  u.id   | u.name  |  d.id  |  d.name  |
+---------+---------+--------+----------+

```

For now I have to use `AS` statements, but it's quite repetitive to re-write and it add length to the query and makes it less readable.

Is there a way to get this result with a SQL keyword or with a DBMS parameter?

I searched but wasn't able to find anything on this specific problem.