Turning a query result sideways? (printing-wise)

[Bob Seger]

Let's say I have a table with columns ID, first_name, last_name, street_address, city, state, zip, etc.

Is there a SQL query trick (in the command line client) that will print a query like "SELECT * FROM some_table WHERE ID = 12345" like this:

ID: 12345
first_name: Bob
last_name: Johnson
street_address: 123 Someplace Ave
City: Wyoming
State: MI
Zip: 49509

In other words, column headers on the left.