Function ParseTableNameWithQualifiedNames

postgres/parser/parser/parse.go:329–341

ParseTableNameWithQualifiedNames can be used to parse an input table name that might be prefixed with an unquoted qualified name. The standard ParseTableName cannot do this due to limitations with our parser. In particular, the parser can't parse different productions individually -- it must parse t

(sql string)

// with a fake non-keyword prefix, and then shifting the result down into an
// UnresolvedObjectName.
func ParseTableNameWithQualifiedNames(sql string) (*tree.UnresolvedObjectName, error) {
	stmt, err := ParseOne(fmt.Sprintf("SELECT fakeprefix.%s", sql))
	if err != nil {
		return nil, err
	}
	un := stmt.AST.(*tree.Select).Select.(*tree.SelectClause).Exprs[0].Expr.(*tree.UnresolvedName)
	var nameParts [3]string
	numParts := un.NumParts - 1
	for i := 0; i < numParts; i++ {
		nameParts[i] = un.Parts[i]
	}
	return tree.NewUnresolvedObjectName(numParts, nameParts, 0 /* annotationIdx */)
}

// parseExprs parses one or more sql expressions.
func parseExprs(exprs []string) (tree.Exprs, error) {