001package gudusoft.gsqlparser;
002
003/**
004 * Enum for various SQL clause such as where clause, having clause and etc.
005*/
006public enum ESqlClause {
007    unknown,
008    /**
009     * can be select list, insert into columns
010     */
011
012    /**
013     *
014     * @deprecated As of v1.8.8.9, use {@link #insertColumn}, {@link #mergeInsert}, {@link #selectList} instead
015     */
016    resultColumn,
017    where,
018    having,
019    groupby,
020    orderby,
021    joinCondition,
022    join,
023    hierarchical,
024    compute,
025    windowClause,
026    /**
027     * sql server top clause
028     */
029    top,
030    /**
031     * set clause in update
032     */
033    set,
034    /**
035     * values clause of insert
036     */
037    insertValues,
038    /**
039     * into clause in select
040     */
041    selectInto,
042    /**
043     * teradata qualify clause
044     */
045    qualify,
046    /**
047     * SQL Server sample clause
048     */
049    sample,
050    teradataWith,
051    /**
052     * teradata expand on clause
053     */
054    expandOn,
055    limit,
056    /**
057     * hive sort by clause
058     */
059    sortby,
060    /**
061     * value clause in select
062     */
063    selectValue,
064    /**
065     * view alias in create view statement
066     */
067    viewAlias,
068    cte,
069    forUpdate,
070    /**
071     * output clause in update statement
072     */
073    output,
074    /**
075     * returning clause in update statement
076     */
077    returning,
078    /**
079     * set variable
080     */
081    setVariable,
082    /**
083     * postgresql for update of,
084     */
085    lockingClause,
086    transformClause,     //hive
087    distributeBy,//hive
088    index,//teradata
089    tableHint,
090    elTable,
091    createTable,
092    constraintRef,
093    insertColumn,
094    setValue, // column in the right side of set clause
095    columnAlias,
096    unSet,//couchbase
097    tableFunction,// function as a table source
098    tableExpr,// expr as a table source
099    containsTable,
100    openrowset,
101    openxml,
102    opendatasource,
103    openquery,
104    datachangeTable,
105    rowList,
106    pivoted_table,
107    xmltable,
108    outerTable,// informix
109    mergeInsert,
110    selectList,//
111    spAssignValue,
112    tdUnPivot,
113    xmlElementName,
114    tableIndexOption,
115    jsonTable,//oracle
116    pivot_in,
117    cluster,//sparksql
118    valueClause,
119}