In Oracle SQL Developer proper and in a SQL Worksheet in VS Code, if you have the same column name in different tables in a query, it will provide an automatic alias and give the correct results from each table.
But in a SQL workbook, it gives the column in the spot expected, but provides the data from the first instance of that field instead of from the expected table.
This is a reproduction of the bug, but it definitely had me spooked earlier today when I didn't realize what was going on in the SQL Notebook.