from sqlalchemy import create_engine
from sqlalchemy import select
from sqlalchemy import text

# non-working MCVE edited by mike

engine = create_engine('sqlite://', echo=False)

one_col_sql = 'select 1 as col1'
multi_col_sql = 'select 1 as col1, 2 as col2'

def go(sql):
    table = text(sql).columns().alias()
    q = select(['*']).select_from(table)
    proxy = engine.execute(q)
    print(proxy.keys())

go(multi_col_sql)
go(one_col_sql)