Function resolveColumnReference

src/postgres/resolve-references.ts:34–104

(
  path: QueryNodePath<QueryParser.ColumnRef>,
  relationRefs: Array<QueryNodePath<QueryParser.RelationRef>>
)

}

export function resolveColumnReference(
  path: QueryNodePath<QueryParser.ColumnRef>,
  relationRefs: Array<QueryNodePath<QueryParser.RelationRef>>
): ColumnReference | null {
  const { fields } = path.node.ColumnRef

  if (fields.length === 1) {
    const [columnNode] = fields
    if (isPgString(columnNode)) {
      const tableRefsInScope: TableReference[] = relationRefs.map(ref => ({
        as: ref.node.RangeVar.alias ? ref.node.RangeVar.alias.Alias.aliasname : undefined,
        tableName: ref.node.RangeVar.relname,
        path
      }))
      return {
        tableRefsInScope: filterDuplicateTableRefs(tableRefsInScope),
        columnName: columnNode.String.str,
        path
      }
    } else if (isStar(columnNode)) {
      if (relationRefs.length !== 1) {
        throw new Error(
          `Can only have unqualified * selector if only one table is referenced in the (sub-)query.\n` +
            `Tables in scope: ${
              relationRefs.length === 0
                ? "(none)"
                : relationRefs.map(ref => ref.node.RangeVar.relname)
            }`
        )
      }
      const tableRef = relationRefs[0]
      return {
        tableName: tableRef.node.RangeVar.alias
          ? tableRef.node.RangeVar.alias.Alias.aliasname
          : tableRef.node.RangeVar.relname,
        columnName: "*",
        path
      }
    }
  } else if (fields.length === 2) {
    const [tableNode, columnNode] = fields
    if (!isPgString(tableNode)) {
      throw new Error(
        `Expected first identifier in column reference to be a string. Got ${getNodeType(
          tableNode
        )}`
      )
    }
    if (isPgString(columnNode)) {
      return {
        tableName: resolveTableName(tableNode.String.str, relationRefs),
        columnName: columnNode.String.str,
        path
      }
    } else if (isStar(columnNode)) {
      return {
        tableName: resolveTableName(tableNode.String.str, relationRefs),
        columnName: "*",