title: Sqlalchemy select only one column (syntax > 1.4!)
body: <p>I have seen <a href="https://stackoverflow.com/q/11530196/14190526">this</a> and <a href="https://stackoverflow.com/q/37133774/14190526">this</a> questions but they both for old Sqlalchemy version. I'm using the next syntax in my queries:</p>
  <pre><code>get_user_st = users.select().where(users.c.login == user.phone_number)
  connection.execute(statement=get_user_st).fetchone()
  </code></pre>
  <p>Here are I selecting by <code>phone_number</code>. How I can select a whole column?</p>
  <p>Wrong syntax which I already tried:</p>
  <pre><code>str(users.select(users.c.login))
  'SELECT users.id, users.phone_number, users.email, users.login, users.full_name, users.position, users.hashed_password, users.role, users.created_datetime, users.last_update, users.owner_id \nFROM users \nWHERE users.login'
  
  str(users.c.login.select())
  Traceback (most recent call last):
    File &quot;/snap/pycharm-community/238/plugins/python-ce/helpers/pydev/_pydevd_bundle/pydevd_exec2.py&quot;, line 3, in Exec
      exec(exp, global_vars, local_vars)
    File &quot;&lt;input&gt;&quot;, line 1, in &lt;module&gt;
    File &quot;/home/david/PycharmProjects/na_svyazi/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py&quot;, line 818, in __getattr__
      util.raise_(
    File &quot;/home/david/PycharmProjects/na_svyazi/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py&quot;, line 211, in raise_
      raise exception
  AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'select'
  </code></pre>
  <p>I tried to find this case in Sqlalchemy docs but failed.</p>
  <p>Getting db:</p>
  <pre><code>from sqlalchemy.ext.asyncio import AsyncSession, create_async_engine
  from sqlalchemy.orm import sessionmaker
  from sqlalchemy.exc import SQLAlchemyError
  
  
  engine_async = create_async_engine(url=config.SQLALCHEMY_ASYNCPG_URL, echo=False, future=True)  # Future -use style 2.0
  session_async = sessionmaker(bind=engine_async, autoflush=True, class_=AsyncSession)
  
  async def get_db():
      session = session_async()
      try:
          yield session
          await session.commit()
      except SQLAlchemyError as ex:
          await session.rollback()
          raise ex
      finally:
          await session.close()
  </code></pre>
  <p>Type of my session is:</p>
  <pre><code>type(postgres_session)
  &lt;class 'sqlalchemy.orm.session.AsyncSession'&gt;
  </code></pre>
  <p>P.S. it preferable to not import <code>select</code> from <code>sqlalchemy</code> but use Table object (<code>users.c</code> or just <code>users</code>) if it's possible</p>