Query grammar#

queryDeclaration: unionStatement
                | saveStatement
                | insertStatement
                | updateStatement
                | deleteStatement
                | mergeStatement
                | cteStatement
                ;

enhancedSelectStatement
    : SELECT selectClause
      fromClause?
      whereClause?
      groupByClause?
      havingClause?
      orderByClause?
      limitClause?
      offsetClause?
      (limiterClause | controllerClause)?
      forUpdateClause?
      // @role(ambient_member_scope)
    ;

selectClause
    : selectVarClause
    | selectItemList
    ;

aggregateArgList, aggregateArgs, aggregateFunction, aggregateFunctionName, betweenExpression, controllerClause, coreTableExpression, cteBody
cteDefinition, cteDefinitionList, cteRecursive, cteStatement, cubeClause, deleteStatement, enhancedSelectStatement, errorCheckExpression
existsExpression, filterClause, forUpdateClause, fromClause, groupByClause, groupingElement, groupingSet, groupingSetsClause
guardedSelectExpression, havingClause, havingExpression, inExpression, insertSource, insertStatement, joinClause, joinCondition
joinedTableExpression, joinType, likeExpression, limitClause, limiterClause, literalList, mergeActions, mergeAlias
mergeCondition, mergeMatchedAction, mergeNotMatchedAction, mergeSource, mergeStatement, mergeTarget, nullCheckExpression, nullsOrdering
objectConstructionExpression, objectProperty, objectPropertyList, objectPropertySeparator, offsetClause, onConflictClause, orderByClause, orderByExpression
orderByItem, orderByItemList, orderByItemSuffix, orderByLimitOffset, orderDirection, overClause, partitionExpression, queryDeclaration
querySubquery, returningClause, returningItem, rollupClause, saveStatement, selectClause, selectExpression, selectItem
selectItemList, selectVarClause, tableAlias, tableExpression, tableParenBody, unionOperator, unionStatement, updateAssignment
updateAssignmentList, updateExpression, updateStatement, valueExpression, valuesClause, valuesList, whenMatchedClause, whenNotMatchedClause
whereAndExpression, whereClause, whereExpression, whereOrExpression, wherePrimaryExpression, windowArgs, windowFunction, windowFunctionName
windowSpecGroup, windowSpecification, windowSpecToken, withStatement

select var invoice: Invoice
  where Invoice.vendor_id = vendor_id
  order by Invoice.invoice_date desc;

let policy = require_posting_policy(company_code_param, document_type_param, today());

update Invoice
  set status = policy.posted_status
  where Invoice.invoice_id = invoice_id;

insert into VendorAudit (vendor_id, company_code, event_name)
values (vendor_id_param, company_code_param, "vendor.created")
returning vendor_id;

merge into VendorSearch
using Vendor on VendorSearch.vendor_id = Vendor.vendor_id
when matched then update set display_name = Vendor.vendor_name
when not matched then insert (vendor_id, display_name) values (Vendor.vendor_id, Vendor.vendor_name);