If you tab complete in the where clause, we should be able in most cases to know which table(s) you are selecting from and can give you a list of only the columns from those table(s)
select * from accounts where \t gives you a list of only the columns in accounts
select * from accounts as a join orders as o on \t gives you a list of the columns in accounts, prefixed with a., and the columns in orders prefixed with o.
If you tab complete in the where clause, we should be able in most cases to know which table(s) you are selecting from and can give you a list of only the columns from those table(s)
select * from accounts where \t
gives you a list of only the columns inaccounts
select * from accounts as a join orders as o on \t
gives you a list of the columns inaccounts
, prefixed witha.
, and the columns inorders
prefixed witho.