Here's your example with a few adaptations. Unfortunately I'm using SQLite3 inner API language for most of the time so if it can't be done it's because SQLite doesn't support it originally.
One way to do what you want is using the AS keyword when selecting columns (it's used in cases like this in most DBMSs).
This way even if the column names between two tables are identical you force SQLite to name it the way you want it thus it will show that alias when using the Get Column Name expression.
See if that works out for you.