186 create_table ::= createkw temp(T) TABLE ifnotexists(E) nm(Y) dbnm(Z). {  in temp()
187    sqlite3StartTable(pParse,&Y,&Z,T,0,0,E);  in temp()
361 ccons ::= DEFAULT LP(A) expr(X) RP(Z).  in LP()
362                             {sqlite3AddDefaultValue(pParse,X,A.z+1,Z.z);}  in LP()
363 ccons ::= DEFAULT PLUS(A) scantok(Z) term(X).  in PLUS()
364                             {sqlite3AddDefaultValue(pParse,X,A.z,&Z.z[Z.n]);}  in PLUS()
365 ccons ::= DEFAULT MINUS(A) scantok(Z) term(X). {  in MINUS()
367   sqlite3AddDefaultValue(pParse,p,A.z,&Z.z[Z.n]);  in MINUS()
383 ccons ::= PRIMARY KEY sortorder(Z) onconf(R) autoinc(I).  in sortorder()  argument
384                                  {sqlite3AddPrimaryKey(pParse,0,R,I,Z);}  in sortorder()
478 cmd ::= createkw(X) temp(T) VIEW ifnotexists(E) nm(Y) dbnm(Z) eidlist_opt(C)
480   sqlite3CreateView(pParse, &X, &Y, &Z, C, S, T, E);
565 selectnowith(A) ::= selectnowith(A) multiselect_op(Y) oneselect(Z).  {
566   Select *pRhs = Z;
595                  orderby_opt(Z) limit_opt(L). {
596   A = sqlite3SelectNew(pParse,W,X,Y,P,Q,Z,D,L);
601                  orderby_opt(Z) limit_opt(L). {
602   A = sqlite3SelectNew(pParse,W,X,Y,P,Q,Z,D,L);
651 selcollist(A) ::= sclp(A) scanpt(B) expr(X) scanpt(Z) as(Y).     {
654    sqlite3ExprListSetSpan(pParse,A,B,Z);
698 seltablist(A) ::= stl_prefix(A) nm(Y) dbnm(D) as(Z) on_using(N). {
699   A = sqlite3SrcListAppendFromTerm(pParse,A,&Y,&D,&Z,0,&N);
701 seltablist(A) ::= stl_prefix(A) nm(Y) dbnm(D) as(Z) indexed_by(I) on_using(N). {
702   A = sqlite3SrcListAppendFromTerm(pParse,A,&Y,&D,&Z,0,&N);
705 seltablist(A) ::= stl_prefix(A) nm(Y) dbnm(D) LP exprlist(E) RP as(Z) on_using(N). {
706   A = sqlite3SrcListAppendFromTerm(pParse,A,&Y,&D,&Z,0,&N);
710   seltablist(A) ::= stl_prefix(A) LP select(S) RP as(Z) on_using(N). {
711     A = sqlite3SrcListAppendFromTerm(pParse,A,0,0,&Z,S,&N);
713   seltablist(A) ::= stl_prefix(A) LP seltablist(F) RP as(Z) on_using(N). {
714     if( A==0 && Z.n==0 && N.pOn==0 && N.pUsing==0 ){
717       A = sqlite3SrcListAppendFromTerm(pParse,A,0,0,&Z,0,&N);
741       A = sqlite3SrcListAppendFromTerm(pParse,A,0,0,&Z,pSubquery,&N);
767 xfullname(A) ::= nm(X) DOT nm(Y) AS nm(Z).  {
769    if( A ) A->a[0].zAlias = sqlite3NameFromToken(pParse->db, &Z);
771 xfullname(A) ::= nm(X) AS nm(Z). {  
773    if( A ) A->a[0].zAlias = sqlite3NameFromToken(pParse->db, &Z);
837 sortlist(A) ::= sortlist(A) COMMA expr(Y) sortorder(Z) nulls(X). {
839   sqlite3ExprListSetSortOrder(A,Z,X);
841 sortlist(A) ::= expr(Y) sortorder(Z) nulls(X). {
843   sqlite3ExprListSetSortOrder(A,Z,X);
1011               DO UPDATE SET setlist(Z) where_opt(W) upsert(N).
1012               { A = sqlite3UpsertNew(pParse->db,T,TW,Z,W,N);}
1017 upsert(A) ::= ON CONFLICT DO UPDATE SET setlist(Z) where_opt(W) returning.
1018               { A = sqlite3UpsertNew(pParse->db,0,0,Z,W,0);}
1094 expr(A) ::= nm(X) DOT nm(Y) DOT nm(Z). {
1097   Expr *temp3 = tokenExpr(pParse,TK_ID,Z);
1149 expr(A) ::= id(X) LP distinct(D) exprlist(Y) RP filter_over(Z). {
1151   sqlite3WindowAttach(pParse, A, Z);
1153 expr(A) ::= id(X) LP STAR RP filter_over(Z). {
1155   sqlite3WindowAttach(pParse, A, Z);
1333   expr(A) ::= expr(A) in_op(N) nm(Y) dbnm(Z) paren_exprlist(E). [IN] {
1334     SrcList *pSrc = sqlite3SrcListAppend(pParse, 0,&Y,&Z);
1349 expr(A) ::= CASE case_operand(X) case_exprlist(Y) case_else(Z) END. {
1352     A->x.pList = Z ? sqlite3ExprListAppend(pParse,Y,Z) : Y;
1356     sqlite3ExprDelete(pParse->db, Z);
1361 case_exprlist(A) ::= case_exprlist(A) WHEN expr(Y) THEN expr(Z). {
1363   A = sqlite3ExprListAppend(pParse,A, Z);
1365 case_exprlist(A) ::= WHEN expr(Y) THEN expr(Z). {
1367   A = sqlite3ExprListAppend(pParse,A, Z);
1403         ON nm(Y) LP sortlist(Z) RP where_opt(W). {
1405                      sqlite3SrcListAppend(pParse,0,&Y,0), Z, U,
1464 eidlist(A) ::= eidlist(A) COMMA nm(Y) collate(C) sortorder(Z).  {
1465   A = parserAddExprIdListTerm(pParse, A, &Y, C, Z);
1467 eidlist(A) ::= nm(Y) collate(C) sortorder(Z). {
1468   A = parserAddExprIdListTerm(pParse, 0, &Y, C, Z); /*A-overwrites-Y*/
1494 cmd ::= PRAGMA nm(X) dbnm(Z).                {sqlite3Pragma(pParse,&X,&Z,0,0);}
1495 cmd ::= PRAGMA nm(X) dbnm(Z) EQ nmnum(Y).    {sqlite3Pragma(pParse,&X,&Z,&Y,0);}
1496 cmd ::= PRAGMA nm(X) dbnm(Z) LP nmnum(Y) RP. {sqlite3Pragma(pParse,&X,&Z,&Y,0);}
1497 cmd ::= PRAGMA nm(X) dbnm(Z) EQ minus_num(Y). 
1498                                              {sqlite3Pragma(pParse,&X,&Z,&Y,1);}
1499 cmd ::= PRAGMA nm(X) dbnm(Z) LP minus_num(Y) RP.
1500                                              {sqlite3Pragma(pParse,&X,&Z,&Y,1);}
1516 cmd ::= createkw trigger_decl(A) BEGIN trigger_cmd_list(S) END(Z). {
1519   all.n = (int)(Z.z - A.z) + Z.n;
1523 trigger_decl(A) ::= temp(T) TRIGGER ifnotexists(NOERR) nm(B) dbnm(Z) 
1526   sqlite3BeginTrigger(pParse, &B, &Z, C, D.a, D.b, E, G, T, NOERR);
1527   A = (Z.n==0?B:Z); /*A-overwrites-T*/
1596    UPDATE(B) orconf(R) trnm(X) tridxby SET setlist(Y) from(F) where_opt(Z) scanpt(E).  
1597    {A = sqlite3TriggerUpdateStep(pParse, &X, F, Y, Z, R, B.z, E);}
1601                       trnm(X) idlist_opt(F) select(S) upsert(U) scanpt(Z). {
1602    A = sqlite3TriggerInsertStep(pParse,&X,F,S,R,U,B,Z);/*A-overwrites-R*/
1619 expr(A) ::= RAISE LP raisetype(T) COMMA nm(Z) RP.  {
1620   A = sqlite3ExprAlloc(pParse->db, TK_RAISE, &Z, 1);
1673 cmd ::= ALTER TABLE fullname(X) RENAME TO nm(Z). {
1674   sqlite3AlterRenameTable(pParse,X,&Z);
1689 cmd ::= ALTER TABLE fullname(X) RENAME kwcolumn_opt nm(Y) TO nm(Z). {
1690   sqlite3AlterRenameColumn(pParse, X, &Y, &Z);
1704                 nm(X) dbnm(Y) USING nm(Z). {
1705     sqlite3VtabBeginParse(pParse, &X, &Y, &Z, E);
1735 wqitem(A) ::= nm(X) eidlist_opt(Y) wqas(M) LP select(Z) RP. {
1736   A = sqlite3CteNew(pParse, &X, Y, Z, M); /*A-overwrites-X*/
1755 windowdefn_list(A) ::= windowdefn(Z). { A = Z; }
1756 windowdefn_list(A) ::= windowdefn_list(Y) COMMA windowdefn(Z). {
1757   assert( Z!=0 );
1758   sqlite3WindowChain(pParse, Z, Y);
1759   Z->pNextWin = Y;
1760   A = Z;
1799 window(A) ::= PARTITION BY nexprlist(X) orderby_opt(Y) frame_opt(Z). {
1800   A = sqlite3WindowAssemble(pParse, Z, X, Y, 0);
1802 window(A) ::= nm(W) PARTITION BY nexprlist(X) orderby_opt(Y) frame_opt(Z). {
1803   A = sqlite3WindowAssemble(pParse, Z, X, Y, &W);
1805 window(A) ::= ORDER BY sortlist(Y) frame_opt(Z). {
1806   A = sqlite3WindowAssemble(pParse, Z, 0, Y, 0);
1808 window(A) ::= nm(W) ORDER BY sortlist(Y) frame_opt(Z). {
1809   A = sqlite3WindowAssemble(pParse, Z, 0, Y, &W);
1811 window(A) ::= frame_opt(Z). {
1812   A = Z;
1814 window(A) ::= nm(W) frame_opt(Z). {
1815   A = sqlite3WindowAssemble(pParse, Z, 0, 0, &W);
1821 frame_opt(A) ::= range_or_rows(X) frame_bound_s(Y) frame_exclude_opt(Z). { 
1822   A = sqlite3WindowAlloc(pParse, X, Y.eType, Y.pExpr, TK_CURRENT, 0, Z);
1825                           frame_bound_e(Z) frame_exclude_opt(W). { 
1826   A = sqlite3WindowAlloc(pParse, X, Y.eType, Y.pExpr, Z.eType, Z.pExpr, W);
1875 over_clause(A) ::= OVER LP window(Z) RP. {
1876   A = Z;
1879 over_clause(A) ::= OVER nm(Z). {
1882     A->zName = sqlite3DbStrNDup(pParse->db, Z.z, Z.n);