Field Name Conflict in Query Builder With Joins

[AndrewRoz]

When I query data from multiple tables in Query Builder, any tables with duplicate field names only appear once. Am I missing something? I know I can use aliases in select() to give them unique field names, but is that really necessary?

For example, I have two tables venues and concerts.

• venues
  • name
  • short_name
  • id
  • created_at
  • updated_at
• concerts
  • name
  • date
  • comment
  • venue_id
  • id
  • created_at
  • updated_at

If I run this query:
$list = DB::table('venues')->leftJoin('concerts', 'venues.id', '=', 'concerts.venue_id')->get();
The result will only contain the following columns:

• name [from concerts]
• short_name
• id [from concerts]
• created_at [from concerts]
• updated_at [from concerts]
• date
• venue_id
• comment

It's a foregone conclusion that most tables will have created_at, updated_at and id fields. So when using joins I figured Laravel would have planned for duplicate field names between tables.