Method parseTableSchemaClause

parser/parser_table.go:513–586

(pos Pos)

}

func (p *Parser) parseTableSchemaClause(pos Pos) (*TableSchemaClause, error) {
	switch {
	case p.matchTokenKind(TokenKindLParen):
		// parse column definitions
		if err := p.expectTokenKind(TokenKindLParen); err != nil {
			return nil, err
		}

		columns, err := p.parseTableColumns()
		if err != nil {
			return nil, err
		}

		rightParenPos := p.Pos()
		if err := p.expectTokenKind(TokenKindRParen); err != nil {
			return nil, err
		}
		return &TableSchemaClause{
			SchemaPos: pos,
			SchemaEnd: rightParenPos,
			Columns:   columns,
		}, nil
	case p.matchKeyword(KeywordAs) && !p.peekKeyword(KeywordSelect) && !p.peekKeyword(KeywordWith) && !p.peekTokenKind(TokenKindLParen):
		// Handle AS only if followed by identifier (not SELECT/WITH/LPAREN)
		// This handles: AS ident, AS ident.ident, AS ident(...)
		// CREATE TABLE will handle: AS SELECT, AS WITH, AS (SELECT ...)
		p.tryConsumeKeywords(KeywordAs)

		ident, err := p.parseIdent()
		if err != nil {
			return nil, err
		}
		switch {
		case p.matchTokenKind(TokenKindDot):
			// it's a database.table
			dotIdent, err := p.tryParseDotIdent(p.Pos())
			if err != nil {
				return nil, err
			}
			return &TableSchemaClause{
				SchemaPos: pos,
				SchemaEnd: dotIdent.End(),
				AliasTable: &TableIdentifier{
					Database: ident,
					Table:    dotIdent,
				},
			}, nil
		case p.matchTokenKind(TokenKindLParen):
			// it's a table function
			argsExpr, err := p.parseTableArgList(pos)
			if err != nil {
				return nil, err
			}
			return &TableSchemaClause{
				SchemaPos: pos,
				SchemaEnd: p.End(),
				TableFunction: &TableFunctionExpr{
					Name: ident,