SqlColumn

class SqlColumn(name, alias=None)

A column reference with an optional alias. Created via SQL.column(name, alias). Inherits from SqlObj.

Parameters:

• name – Column expression — a string, SqlCat, or SqlQuery subquery. Subqueries are rendered in parentheses.

• alias – Optional alias string. Renders as name AS alias.

SQL.column('count(*)', 'total')
# count(*) AS total

SQL.column('name')
# name

SQL.column(SQL.cat('a + b'), 'sum')
# a + b AS sum