sqlalchemy_core.py

from sqlalchemy import *

engine = \
  create_engine("postgresql://...@localhost:5432/nfldb")
metadata = MetaData(bind=engine)

teams = Table('team', metadata, autoload=True)
players = Table('player', metadata, autoload=True)

inputname = input('input a player name:')

conn = engine.connect()
s = select([players.c.player_id, players.c.first_name, players.c.last_name,
            players.c.full_name]).where(players.c.full_name.ilike(inputname))
result = conn.execute(s)

print(result.fetchone())
print(type(players.c.player_id))
print(str(players.c.player_id))