sql

select * from (
select email,name from users
) test

expect to resolve as

select test.email,test.name from (
select email,name from users
) test