if only for ONE query for this display, 1 is A LITTLE better.

actually,2 needs DBMS to the execute the Select clause as 1.
But 1 does need to CREATE a view.

2(view) is better if considering the DB security, data independence, ETC.