var query = db.From<Table1>().Join<Table2>();
var results = db.Select<Dictionary<string, object>>(query);
If Table1 and Table2 both have a column named status, the resulting dictionary will only have one status key with the value from one of the tables. Is there a way to force the keys in the resulting dictionary to prefix the table name? So instead of having results["status"] I would have something like results["table1status"] and results["table2status"]?
I saw that I can do this before doing the select, which seemed quite promising at first: