Slightly surprising behaviour here 
- My goal: query and be able to see "id" fields from both tables in a join
- Issue: last field with the name wins; only one "id" field is shown
- Steps I've taken to troubleshoot: I was able to work around this by explicitly aliasing one of the fields to have a unique name (
<tableX>.id AS <x_id>)
This might be expected behaviour, for the purposes of using the data later. It just threw me off during my first exploration 