pd.read_sql(sql) If sql has two columns of the same field, the result is only one column of fields

Question

pd.read_sql(sql) If sql has two columns of the same field, the result is only one column of fields

pd.read_sql() dont work ?

import pandas as pd

sql = "select name, name, age from table;"
df = pd.read_sql(sql, con)

print(df.columns) 
# name, age

it work

with conn.cursor() as a:
    a.execute(sql)
    lines = a.fetchall()
df = pd.DataFrame(lines)