API 4.9

    Base Package: net.sf.jsqlparser

    Base

    JSQLParserException

    extends: Exception

    JSQLParserException ()
    JSQLParserException (message, cause)
    String message
    Throwable cause
    JSQLParserException (message)
    String message
    JSQLParserException (cause)
    Throwable cause

    Model

    implements: Serializable provides: Expression, FromItem, Statement,


    A marker interface for jsqlparser-model-classes.
    The datastructure where the sql syntax is represented by a tree consists of Model’s

    expression

    AnalyticType

    [OVER, WITHIN_GROUP, WITHIN_GROUP_OVER, FILTER_ONLY]

    AnyType

    [ANY, SOME, ALL]

    DateTimeLiteralExpression.DateTime

    [DATE, TIME, TIMESTAMP, TIMESTAMPTZ]

    JsonAggregateOnNullType

    [NULL, ABSENT]

    JsonAggregateUniqueKeysType

    [WITH, WITHOUT]

    JsonFunctionType

    [OBJECT, ARRAY, POSTGRES_OBJECT, MYSQL_OBJECT]

    SpannerInterleaveIn.OnDelete

    [CASCADE, NO_ACTION]

    TrimFunction.TrimSpecification

    [LEADING, TRAILING, BOTH]

    WindowElement.Type

    [ROWS, RANGE]

    WindowOffset.Type

    [PRECEDING, FOLLOWING, CURRENT, EXPR]

    Alias

    extends: Object implements: Serializable

    Alias (name)
    String name
    Alias (name, useAs)
    String name
    boolean useAs
    getName () → String
    returns String
    setName (name)
    String name
    isUseAs () → boolean
    returns boolean
    setUseAs (useAs)
    boolean useAs
    getAliasColumns () → List
    returns List
    setAliasColumns (aliasColumns)
    List aliasColumns
    @Override
    toString () → String
    returns String
    withName (name) → Alias
    String name
    returns Alias
    withUseAs (useAs) → Alias
    boolean useAs
    returns Alias
    withAliasColumns (aliasColumns) → Alias
    List aliasColumns
    returns Alias
    addAliasColumns (aliasColumns) → Alias
    AliasColumn aliasColumns
    returns Alias
    addAliasColumns (aliasColumns) → Alias
    Collection aliasColumns
    returns Alias

    Alias.AliasColumn

    extends: Object implements: Serializable

    AliasColumn (name, colDataType)
    String name
    ColDataType colDataType
    AliasColumn (name)
    String name

    AllValue

    extends: ASTNodeAccessImpl implements: Expression

    AllValue ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String

    AnalyticExpression

    extends: ASTNodeAccessImpl implements: Expression

    Analytic function. The name of the function is variable but the parameters following the special analytic function path. e.g. row_number() over (order by test). Additional there can be an expression for an analytical aggregate like sum(col) or the “all collumns” wildcard like count(*).
    AnalyticExpression ()
    AnalyticExpression (function)
    Function function
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getKeep () → KeepExpression
    setKeep (keep)
    getPartitionExpressionList () → ExpressionList
    setPartitionExpressionList (partitionExpressionList)
    ExpressionList partitionExpressionList
    setPartitionExpressionList (partitionExpressionList, brackets)
    ExpressionList partitionExpressionList
    boolean brackets
    isPartitionByBrackets () → boolean
    returns boolean
    getName () → String
    returns String
    setName (name)
    String name
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    getOffset () → Expression
    returns Expression
    setOffset (offset)
    Expression offset
    getDefaultValue () → Expression
    returns Expression
    setDefaultValue (defaultValue)
    Expression defaultValue
    getWindowElement () → WindowElement
    setWindowElement (windowElement)
    WindowElement windowElement
    getType () → AnalyticType
    returns AnalyticType
    setType (part)
    AnalyticType part
    isDistinct () → boolean
    returns boolean
    setDistinct (distinct)
    boolean distinct
    isUnique () → boolean
    returns boolean
    setUnique (unique)
    boolean unique
    isIgnoreNulls () → boolean
    returns boolean
    setIgnoreNulls (ignoreNulls)
    boolean ignoreNulls
    isIgnoreNullsOutside () → boolean
    returns boolean
    setIgnoreNullsOutside (ignoreNullsOutside)
    boolean ignoreNullsOutside
    getWindowName () → String
    returns String
    setWindowName (windowName)
    String windowName
    getWindowDefinition () → WindowDefinition
    setWindowDefinition (windowDef)
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    isAllColumns () → boolean
    returns boolean
    setAllColumns (allColumns)
    boolean allColumns
    getFilterExpression () → Expression
    returns Expression
    setFilterExpression (filterExpression)
    Expression filterExpression
    withName (name) → AnalyticExpression
    String name
    withExpression (expression) → AnalyticExpression
    Expression expression
    withOffset (offset) → AnalyticExpression
    withDefaultValue (defaultValue) → AnalyticExpression
    Expression defaultValue
    withAllColumns (allColumns) → AnalyticExpression
    boolean allColumns
    withKeep (keep) → AnalyticExpression
    withType (part) → AnalyticExpression
    AnalyticType part
    withDistinct (distinct) → AnalyticExpression
    boolean distinct
    withUnique (unique) → AnalyticExpression
    boolean unique
    withIgnoreNulls (ignoreNulls) → AnalyticExpression
    boolean ignoreNulls
    withFilterExpression (filterExpression) → AnalyticExpression
    Expression filterExpression
    withWindowElement (windowElement) → AnalyticExpression
    WindowElement windowElement
    getExpression (part) → E
    Class part
    returns E
    getOffset (part) → E
    Class part
    returns E
    getDefaultValue (part) → E
    Class part
    returns E
    getFilterExpression (part) → E
    Class part
    returns E
    getFuncOrderBy () → List
    returns List
    setFuncOrderBy (funcOrderBy)
    List funcOrderBy

    AnyComparisonExpression

    extends: ASTNodeAccessImpl implements: Expression

    Combines ANY and SOME expressions.
    AnyComparisonExpression (anyType, select)
    AnyType anyType
    Select select
    getSelect () → Select
    returns Select
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getAnyType () → AnyType
    returns AnyType
    @Override
    toString () → String
    returns String

    ArrayConstructor

    extends: ASTNodeAccessImpl implements: Expression

    ArrayConstructor (expressions, arrayKeyword)
    ExpressionList expressions
    boolean arrayKeyword
    getExpressions () → ExpressionList
    setExpressions (expressions)
    ExpressionList expressions
    isArrayKeyword () → boolean
    returns boolean
    setArrayKeyword (arrayKeyword)
    boolean arrayKeyword
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String

    ArrayExpression

    extends: ASTNodeAccessImpl implements: Expression

    ArrayExpression ()
    ArrayExpression (objExpression, indexExpression, startIndexExpression, stopIndexExpression)
    Expression objExpression
    Expression indexExpression
    Expression startIndexExpression
    Expression stopIndexExpression
    getObjExpression () → Expression
    returns Expression
    setObjExpression (objExpression)
    Expression objExpression
    getIndexExpression () → Expression
    returns Expression
    setIndexExpression (indexExpression)
    Expression indexExpression
    getStartIndexExpression () → Expression
    returns Expression
    setStartIndexExpression (startIndexExpression)
    Expression startIndexExpression
    getStopIndexExpression () → Expression
    returns Expression
    setStopIndexExpression (stopIndexExpression)
    Expression stopIndexExpression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withObjExpression (objExpression) → ArrayExpression
    Expression objExpression
    withIndexExpression (indexExpression) → ArrayExpression
    Expression indexExpression
    withRangeExpression (startIndexExpression, stopIndexExpression) → ArrayExpression
    Expression startIndexExpression
    Expression stopIndexExpression
    getObjExpression (part) → E
    Class part
    returns E
    getIndexExpression (part) → E
    Class part
    returns E

    BinaryExpression

    extends: ASTNodeAccessImpl implements: Expression provides: Addition, AndExpression, BitwiseAnd, BitwiseLeftShift, BitwiseOr, BitwiseRightShift, BitwiseXor, Concat, Division, IntegerDivision, IsDistinctExpression, JsonOperator, LikeExpression, Modulo, Multiplication, OldOracleJoinBinaryExpression, OrExpression, RegExpMatchOperator, SimilarToExpression, Subtraction, XorExpression

    A basic class for binary expressions, that is expressions having a left member and a right member which are in turn expressions.
    BinaryExpression ()
    getLeftExpression () → Expression
    returns Expression
    getRightExpression () → Expression
    returns Expression
    withLeftExpression (expression) → BinaryExpression
    Expression expression
    setLeftExpression (expression)
    Expression expression
    withRightExpression (expression) → BinaryExpression
    Expression expression
    setRightExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    getStringExpression () → String
    returns String
    getLeftExpression (part) → E
    Class part
    returns E
    getRightExpression (part) → E
    Class part
    returns E

    CaseExpression

    extends: ASTNodeAccessImpl implements: Expression

    CASE/WHEN expression. Syntax: `CASE WHEN condition THEN expression [WHEN condition THEN expression]... [ELSE expression] END`
    or

    `CASE expression WHEN condition THEN expression [WHEN condition THEN expression]... [ELSE expression] END`
    CaseExpression ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getSwitchExpression () → Expression
    returns Expression
    setSwitchExpression (switchExpression)
    Expression switchExpression
    getElseExpression () → Expression
    returns Expression | Returns the elseExpression.
    setElseExpression (elseExpression)
    Expression elseExpression | elseExpression The elseExpression to set.
    getWhenClauses () → List
    returns List | Returns the whenClauses.
    setWhenClauses (whenClauses)
    List whenClauses | whenClauses The whenClauses to set.
    @Override
    toString () → String
    returns String
    withSwitchExpression (switchExpression) → CaseExpression
    Expression switchExpression
    withWhenClauses (whenClauses) → CaseExpression
    List whenClauses
    withElseExpression (elseExpression) → CaseExpression
    Expression elseExpression
    addWhenClauses (whenClauses) → CaseExpression
    WhenClause whenClauses
    addWhenClauses (whenClauses) → CaseExpression
    Collection whenClauses
    getSwitchExpression (part) → E
    Class part
    returns E
    getElseExpression (part) → E
    Class part
    returns E
    isUsingBrackets () → boolean
    returns boolean | the usingBrackets
    setUsingBrackets (usingBrackets)
    boolean usingBrackets | usingBrackets the usingBrackets to set
    withUsingBrackets (usingBrackets) → CaseExpression
    boolean usingBrackets | usingBrackets the usingBrackets to set

    CastExpression

    extends: ASTNodeAccessImpl implements: Expression

    CastExpression (keyword)
    String keyword
    CastExpression ()
    getColDataType () → ColDataType
    returns ColDataType
    getColumnDefinitions () → ArrayList
    returns ArrayList
    setColDataType (colDataType)
    ColDataType colDataType
    addColumnDefinition (columnDefinition)
    ColumnDefinition columnDefinition
    getLeftExpression () → Expression
    returns Expression
    setLeftExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    isUseCastKeyword () → boolean
    returns boolean
    setUseCastKeyword (useCastKeyword)
    boolean useCastKeyword
    @Override
    toString () → String
    returns String
    withType (part) → CastExpression
    withUseCastKeyword (useCastKeyword) → CastExpression
    boolean useCastKeyword
    withLeftExpression (leftExpression) → CastExpression
    Expression leftExpression
    getLeftExpression (part) → E
    Class part
    returns E

    CollateExpression

    extends: ASTNodeAccessImpl implements: Expression

    CollateExpression ()
    CollateExpression (leftExpression, collate)
    Expression leftExpression
    String collate
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getLeftExpression () → Expression
    returns Expression
    setLeftExpression (leftExpression)
    Expression leftExpression
    getCollate () → String
    returns String
    setCollate (collate)
    String collate
    @Override
    toString () → String
    returns String
    withLeftExpression (leftExpression) → CollateExpression
    Expression leftExpression
    withCollate (collate) → CollateExpression
    String collate
    getLeftExpression (part) → E
    Class part
    returns E

    ConnectByRootOperator

    extends: ASTNodeAccessImpl implements: Expression

    ConnectByRootOperator (column)
    Column column
    getColumn () → Column
    returns Column
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    DateTimeLiteralExpression

    extends: ASTNodeAccessImpl implements: Expression

    DateTimeLiteralExpression ()
    getValue () → String
    returns String
    setValue (value)
    String value
    getType () → DateTime
    returns DateTime
    setType (part)
    DateTime part
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withValue (value) → DateTimeLiteralExpression
    String value
    withType (part) → DateTimeLiteralExpression
    DateTime part

    DateValue

    extends: ASTNodeAccessImpl implements: Expression

    A Date in the form {d ‘yyyy-mm-dd’}
    DateValue ()
    DateValue (value)
    Date value
    DateValue (value)
    A Date in the form {d ‘yyyy-mm-dd’}
    String value | value The text presentation of the Date to be parsed.
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → Date
    returns Date
    setValue (d)
    Date d
    @Override
    toString () → String
    returns String
    withValue (value) → DateValue
    Date value
    returns DateValue

    DoubleValue

    extends: ASTNodeAccessImpl implements: Expression

    Every number with a point or a exponential format is a DoubleValue
    DoubleValue ()
    DoubleValue (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → double
    returns double
    setValue (d)
    double d
    @Override
    toString () → String
    returns String
    withValue (value) → DoubleValue
    double value
    returns DoubleValue

    ExpressionVisitorAdapter

    extends: Object implements: ExpressionVisitor, PivotVisitor, SelectItemVisitor

    ExpressionVisitorAdapter ()
    getSelectVisitor () → SelectVisitor
    setSelectVisitor (selectVisitor)
    SelectVisitor selectVisitor
    @Override
    visit (value)
    NullValue value
    @Override
    visit (function)
    Function function
    @Override
    visit (expr)
    @Override
    visit (parameter)
    JdbcParameter parameter
    @Override
    visit (parameter)
    @Override
    visit (value)
    @Override
    visit (value)
    LongValue value
    @Override
    visit (value)
    DateValue value
    @Override
    visit (value)
    TimeValue value
    @Override
    visit (value)
    @Override
    visit (parenthesis)
    Parenthesis parenthesis
    @Override
    visit (value)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    Between expr
    visit (overlapsCondition)
    OverlapsCondition overlapsCondition
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (column)
    Column column
    @Override
    visit (selectBody)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (memberOfExpression)
    MemberOfExpression memberOfExpression
    @Override
    visit (expr)
    @Override
    visit (expr)
    Concat expr
    @Override
    visit (expr)
    Matches expr
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    Modulo expr
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expressionList)
    ExpressionList expressionList
    @Override
    visit (rowConstructor)
    RowConstructor rowConstructor
    @Override
    visit (notExpr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    returns void
    @Override
    visit (jsonExpr)
    @Override
    visit (expr)
    @Override
    visit (var)
    @Override
    visit (bind)
    @Override
    visit (expr)
    @Override
    visit (groupConcat)
    MySQLGroupConcat groupConcat
    @Override
    visit (pivot)
    Pivot pivot
    @Override
    visit (pivot)
    PivotXml pivot
    @Override
    visit (unpivot)
    UnPivot unpivot
    @Override
    visit (allColumns)
    AllColumns allColumns
    @Override
    visit (allTableColumns)
    AllTableColumns allTableColumns
    @Override
    visit (allValue)
    AllValue allValue
    @Override
    visit (isDistinctExpression)
    IsDistinctExpression isDistinctExpression
    @Override
    visit (selectExpressionItem)
    SelectItem selectExpressionItem
    @Override
    visit (rowGetExpression)
    RowGetExpression rowGetExpression
    @Override
    visit (hexValue)
    HexValue hexValue
    @Override
    visit (hint)
    @Override
    visit (timeKeyExpression)
    TimeKeyExpression timeKeyExpression
    @Override
    visit (literal)
    @Override
    visit (nextVal)
    @Override
    visit (col)
    @Override
    visit (expr)
    @Override
    visit (array)
    @Override
    visit (aThis)
    @Override
    visit (var)
    @Override
    visit (expr)
    @Override
    visit (expr)
    @Override
    visit (expression)
    @Override
    visit (expression)
    JsonFunction expression
    @Override
    visit (connectByRootOperator)
    ConnectByRootOperator connectByRootOperator
    @Override
    visit (oracleNamedFunctionParameter)
    OracleNamedFunctionParameter oracleNamedFunctionParameter
    @Override
    visit (geometryDistance)
    GeometryDistance geometryDistance
    @Override
    visit (selectBody)
    Select selectBody
    @Override
    visit (transcodingFunction)
    TranscodingFunction transcodingFunction
    @Override
    visit (trimFunction)
    TrimFunction trimFunction
    @Override
    visit (rangeExpression)
    RangeExpression rangeExpression
    @Override
    visit (tsqlLeftJoin)
    TSQLLeftJoin tsqlLeftJoin
    @Override
    visit (tsqlRightJoin)
    TSQLRightJoin tsqlRightJoin

    ExtractExpression

    extends: ASTNodeAccessImpl implements: Expression

    Extract value from date/time expression. The name stores the part - name to get from the following date/time expression.
    ExtractExpression ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getName () → String
    returns String
    setName (name)
    String name
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    withName (name) → ExtractExpression
    String name
    withExpression (expression) → ExtractExpression
    Expression expression
    getExpression (part) → E
    Class part
    returns E

    FilterOverImpl

    extends: ASTNodeAccessImpl provides: JsonAggregateFunction

    FilterOverImpl ()
    getAnalyticType () → AnalyticType
    returns AnalyticType
    setAnalyticType (analyticType)
    AnalyticType analyticType
    withAnalyticType (analyticType) → FilterOverImpl
    AnalyticType analyticType
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    withOrderByElements (orderByElements) → FilterOverImpl
    List orderByElements
    getPartitionExpressionList () → ExpressionList
    setPartitionExpressionList (partitionExpressionList)
    ExpressionList partitionExpressionList
    setPartitionExpressionList (partitionExpressionList, brackets)
    ExpressionList partitionExpressionList
    boolean brackets
    isPartitionByBrackets () → boolean
    returns boolean
    getFilterExpression () → Expression
    returns Expression
    setFilterExpression (filterExpression)
    Expression filterExpression
    withFilterExpression (filterExpression) → FilterOverImpl
    Expression filterExpression
    getWindowElement () → WindowElement
    setWindowElement (windowElement)
    WindowElement windowElement
    withWindowElement (windowElement) → FilterOverImpl
    WindowElement windowElement
    @SuppressWarnings
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override,| @SuppressWarnings
    toString () → String
    returns String

    Function

    extends: ASTNodeAccessImpl implements: Expression provides: TableFunction

    A function as MAX,COUNT…
    Function ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getName () → String
    returns String
    getMultipartName () → List
    returns List
    setName (string)
    String string
    withName (name) → Function
    String name
    returns Function
    withName (nameparts) → Function
    List nameparts
    returns Function
    setName (string)
    List string
    isAllColumns () → boolean
    returns boolean
    setAllColumns (b)
    boolean b
    isIgnoreNulls () → boolean
    returns boolean
    setIgnoreNulls (ignoreNulls)
    This is at the moment only necessary for AnalyticExpression initialization and not for normal functions. Therefore there is no deparsing for it for normal functions.
    boolean ignoreNulls
    isDistinct () → boolean
    true if the function is “distinct”
    returns boolean | true if the function is “distinct”
    setDistinct (b)
    boolean b
    isUnique () → boolean
    true if the function is “unique”
    returns boolean | true if the function is “unique”
    setUnique (b)
    boolean b
    getParameters () → ExpressionList
    The list of parameters of the function (if any, else null) If the parameter is “*”, allColumns is set to true
    returns ExpressionList | the list of parameters of the function (if any, else null)
    setParameters (expressions)
    Expression expressions
    setParameters (list)
    getNamedParameters () → NamedExpressionList
    the parameters might be named parameters, e.g. substring(‘foobar’ from 2 for 3)
    returns NamedExpressionList | the list of named parameters of the function (if any, else null)
    setNamedParameters (list)
    isEscaped () → boolean
    Return true if it’s in the form “{fn function_body() }”
    returns boolean | true if it’s java-escaped
    setEscaped (isEscaped)
    boolean isEscaped
    getAttribute () → Object
    returns Object
    setAttribute (attributeExpression)
    Expression attributeExpression
    @Deprecated
    getAttributeName () → String
    returns String
    setAttributeName (attributeName)
    String attributeName
    getAttributeColumn () → Column
    returns Column
    setAttribute (attributeColumn)
    Column attributeColumn
    withAttribute (attributeColumn) → Function
    Column attributeColumn
    returns Function
    getKeep () → KeepExpression
    setKeep (keep)
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withAttribute (attribute) → Function
    Expression attribute
    returns Function
    @Deprecated
    withAttributeName (attributeName) → Function
    String attributeName
    returns Function
    withKeep (keep) → Function
    returns Function
    withIgnoreNulls (ignoreNulls) → Function
    boolean ignoreNulls
    returns Function
    withParameters (parameters) → Function
    ExpressionList parameters
    returns Function
    withParameters (parameters) → Function
    Expression parameters
    returns Function
    withNamedParameters (namedParameters) → Function
    NamedExpressionList namedParameters
    returns Function
    withAllColumns (allColumns) → Function
    boolean allColumns
    returns Function
    withDistinct (distinct) → Function
    boolean distinct
    returns Function
    withUnique (unique) → Function
    boolean unique
    returns Function
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getAttribute (part) → E
    Class part
    returns E

    HexValue

    extends: ASTNodeAccessImpl implements: Expression

    HexValue ()
    HexValue (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → String
    returns String
    setValue (value)
    String value
    withValue (value) → HexValue
    String value
    returns HexValue
    @Override
    toString () → String
    returns String

    IntervalExpression

    extends: ASTNodeAccessImpl implements: Expression

    IntervalExpression ()
    IntervalExpression (intervalKeyword)
    boolean intervalKeyword
    isUsingIntervalKeyword () → boolean
    returns boolean
    getParameter () → String
    returns String
    setParameter (parameter)
    String parameter
    getIntervalType () → String
    returns String
    setIntervalType (intervalType)
    String intervalType
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    withParameter (parameter) → IntervalExpression
    String parameter
    withIntervalType (intervalType) → IntervalExpression
    String intervalType
    withExpression (expression) → IntervalExpression
    Expression expression
    getExpression (part) → E
    Class part
    returns E

    JdbcNamedParameter

    extends: ASTNodeAccessImpl implements: Expression

    JdbcNamedParameter ()
    JdbcNamedParameter (name)
    String name
    getParameterCharacter () → String
    returns String
    setParameterCharacter (parameterCharacter) → JdbcNamedParameter
    String parameterCharacter
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withName (name) → JdbcNamedParameter
    String name

    JdbcParameter

    extends: ASTNodeAccessImpl implements: Expression

    A ‘?’ in a statement or a ?<number> e.g. ?4
    JdbcParameter ()
    JdbcParameter (index, useFixedIndex, parameterCharacter)
    Integer index
    boolean useFixedIndex
    String parameterCharacter
    getParameterCharacter () → String
    returns String
    setParameterCharacter (parameterCharacter) → JdbcParameter
    String parameterCharacter
    getIndex () → Integer
    returns Integer
    setIndex (index)
    Integer index
    isUseFixedIndex () → boolean
    returns boolean
    setUseFixedIndex (useFixedIndex)
    boolean useFixedIndex
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withIndex (index) → JdbcParameter
    Integer index
    withUseFixedIndex (useFixedIndex) → JdbcParameter
    boolean useFixedIndex

    JsonAggregateFunction

    extends: FilterOverImpl implements: Expression

    JsonAggregateFunction ()
    getOnNullType () → JsonAggregateOnNullType
    returns JsonAggregateOnNullType
    setOnNullType (onNullType)
    JsonAggregateOnNullType onNullType
    withOnNullType (onNullType) → JsonAggregateFunction
    JsonAggregateOnNullType onNullType
    getUniqueKeysType () → JsonAggregateUniqueKeysType
    returns JsonAggregateUniqueKeysType
    setUniqueKeysType (uniqueKeysType)
    JsonAggregateUniqueKeysType uniqueKeysType
    withUniqueKeysType (uniqueKeysType) → JsonAggregateFunction
    JsonAggregateUniqueKeysType uniqueKeysType
    getType () → JsonFunctionType
    returns JsonFunctionType
    setType (part)
    JsonFunctionType part
    withType (part) → JsonAggregateFunction
    JsonFunctionType part
    setType (typeName)
    String typeName
    withType (typeName) → JsonAggregateFunction
    String typeName
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    withExpression (expression) → JsonAggregateFunction
    Expression expression
    isUsingKeyKeyword () → boolean
    returns boolean
    setUsingKeyKeyword (usingKeyKeyword)
    boolean usingKeyKeyword
    withUsingKeyKeyword (usingKeyKeyword) → JsonAggregateFunction
    boolean usingKeyKeyword
    getKey () → String
    returns String
    setKey (key)
    String key
    withKey (key) → JsonAggregateFunction
    String key
    isUsingValueKeyword () → boolean
    returns boolean
    setUsingValueKeyword (usingValueKeyword)
    boolean usingValueKeyword
    withUsingValueKeyword (usingValueKeyword) → JsonAggregateFunction
    boolean usingValueKeyword
    getValue () → Object
    returns Object
    setValue (value)
    Object value
    withValue (value) → JsonAggregateFunction
    Object value
    isUsingFormatJson () → boolean
    returns boolean
    setUsingFormatJson (usingFormatJson)
    boolean usingFormatJson
    withUsingFormatJson (usingFormatJson) → JsonAggregateFunction
    boolean usingFormatJson
    getExpressionOrderByElements () → List
    returns List
    setExpressionOrderByElements (orderByElements)
    List orderByElements
    withExpressionOrderByElements (orderByElements) → JsonAggregateFunction
    List orderByElements
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendObject (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendArray (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    JsonExpression

    extends: ASTNodeAccessImpl implements: Expression

    JsonExpression ()
    JsonExpression (expr)
    JsonExpression (expr, idents)
    List idents
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getExpression () → Expression
    returns Expression
    setExpression (expr)
    addIdent (ident, operator)
    String ident
    String operator
    addAllIdents (idents)
    Collection idents
    getIdentList () → List
    returns List
    getIdent (index) → Entry
    int index
    returns Entry
    @Deprecated
    getIdents () → List
    returns List
    @Deprecated
    getOperators () → List
    returns List
    @Override
    toString () → String
    returns String
    withExpression (expr) → JsonExpression

    JsonFunction

    extends: ASTNodeAccessImpl implements: Expression

    JsonFunction ()
    getKeyValuePairs () → ArrayList
    returns ArrayList
    getExpressions () → ArrayList
    returns ArrayList
    getKeyValuePair (i) → JsonKeyValuePair
    int i
    getExpression (i) → JsonFunctionExpression
    int i
    add (keyValuePair) → boolean
    JsonKeyValuePair keyValuePair
    returns boolean
    add (i, keyValuePair)
    int i
    JsonKeyValuePair keyValuePair
    add (expression) → boolean
    returns boolean
    add (i, expression)
    int i
    isEmpty () → boolean
    returns boolean
    getOnNullType () → JsonAggregateOnNullType
    returns JsonAggregateOnNullType
    setOnNullType (onNullType)
    JsonAggregateOnNullType onNullType
    withOnNullType (onNullType) → JsonFunction
    JsonAggregateOnNullType onNullType
    returns JsonFunction
    getUniqueKeysType () → JsonAggregateUniqueKeysType
    returns JsonAggregateUniqueKeysType
    setUniqueKeysType (uniqueKeysType)
    JsonAggregateUniqueKeysType uniqueKeysType
    withUniqueKeysType (uniqueKeysType) → JsonFunction
    JsonAggregateUniqueKeysType uniqueKeysType
    returns JsonFunction
    getType () → JsonFunctionType
    returns JsonFunctionType
    setType (part)
    JsonFunctionType part
    withType (part) → JsonFunction
    JsonFunctionType part
    returns JsonFunction
    setType (typeName)
    String typeName
    withType (typeName) → JsonFunction
    String typeName
    returns JsonFunction
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendObject (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendPostgresObject (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    appendMySqlObject (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendArray (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    JsonFunctionExpression

    extends: Object implements: Serializable

    JsonFunctionExpression (expression)
    Expression expression
    getExpression () → Expression
    returns Expression
    isUsingFormatJson () → boolean
    returns boolean
    setUsingFormatJson (usingFormatJson)
    boolean usingFormatJson
    withUsingFormatJson (usingFormatJson) → JsonFunctionExpression
    boolean usingFormatJson
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    JsonKeyValuePair

    extends: Object implements: Serializable

    JsonKeyValuePair (key, value, usingKeyKeyword, usingValueKeyword)
    String key
    Object value
    boolean usingKeyKeyword
    boolean usingValueKeyword
    isUsingKeyKeyword () → boolean
    returns boolean
    setUsingKeyKeyword (usingKeyKeyword)
    boolean usingKeyKeyword
    withUsingKeyKeyword (usingKeyKeyword) → JsonKeyValuePair
    boolean usingKeyKeyword
    isUsingValueKeyword () → boolean
    returns boolean
    setUsingValueKeyword (usingValueKeyword)
    boolean usingValueKeyword
    withUsingValueKeyword (usingValueKeyword) → JsonKeyValuePair
    boolean usingValueKeyword
    isUsingFormatJson () → boolean
    returns boolean
    setUsingFormatJson (usingFormatJson)
    boolean usingFormatJson
    withUsingFormatJson (usingFormatJson) → JsonKeyValuePair
    boolean usingFormatJson
    @Override
    hashCode () → int
    returns int
    @Override
    equals (obj) → boolean
    Object obj
    returns boolean
    getKey () → String
    returns String
    getValue () → Object
    returns Object
    append (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    KeepExpression

    extends: ASTNodeAccessImpl implements: Expression

    KeepExpression ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getName () → String
    returns String
    setName (name)
    String name
    isFirst () → boolean
    returns boolean
    setFirst (first)
    boolean first
    @Override
    toString () → String
    returns String
    withName (name) → KeepExpression
    String name
    withOrderByElements (orderByElements) → KeepExpression
    List orderByElements
    withFirst (first) → KeepExpression
    boolean first
    addOrderByElements (orderByElements) → KeepExpression
    OrderByElement orderByElements
    addOrderByElements (orderByElements) → KeepExpression
    Collection orderByElements

    LongValue

    extends: ASTNodeAccessImpl implements: Expression

    Every number without a point or an exponential format is a LongValue.
    LongValue ()
    LongValue (value)
    String value
    LongValue (value)
    long value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → long
    returns long
    getBigIntegerValue () → BigInteger
    returns BigInteger
    setValue (d)
    long d
    withValue (d) → LongValue
    long d
    returns LongValue
    getStringValue () → String
    returns String
    setStringValue (string)
    String string
    @Override
    toString () → String
    returns String
    withStringValue (stringValue) → LongValue
    String stringValue
    returns LongValue
    @Override
    equals (o) → boolean
    Object o
    returns boolean
    @Override
    hashCode () → int
    returns int

    MySQLGroupConcat

    extends: ASTNodeAccessImpl implements: Expression

    MySQLGroupConcat ()
    getExpressionList () → ExpressionList
    setExpressionList (expressionList)
    ExpressionList expressionList
    isDistinct () → boolean
    returns boolean
    setDistinct (distinct)
    boolean distinct
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getSeparator () → String
    returns String
    setSeparator (separator)
    String separator
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withExpressionList (expressionList) → MySQLGroupConcat
    ExpressionList expressionList
    withDistinct (distinct) → MySQLGroupConcat
    boolean distinct
    withOrderByElements (orderByElements) → MySQLGroupConcat
    List orderByElements
    withSeparator (separator) → MySQLGroupConcat
    String separator
    addOrderByElements (orderByElements) → MySQLGroupConcat
    OrderByElement orderByElements
    addOrderByElements (orderByElements) → MySQLGroupConcat
    Collection orderByElements

    MySQLIndexHint

    extends: Object implements: Serializable

    MySQLIndexHint (action, indexQualifier, indexNames)
    String action
    String indexQualifier
    List indexNames
    getAction () → String
    returns String
    getIndexQualifier () → String
    returns String
    getIndexNames () → List
    returns List
    @Override
    toString () → String
    returns String

    NextValExpression

    extends: ASTNodeAccessImpl implements: Expression

    NextValExpression (nameList, image)
    List nameList
    String image
    isUsingNextValueFor () → boolean
    returns boolean
    setUsingNextValueFor (usingNextValueFor)
    boolean usingNextValueFor
    withNextValueFor (usingNextValueFor) → NextValExpression
    boolean usingNextValueFor
    getNameList () → List
    returns List
    getName () → String
    returns String
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    NotExpression

    extends: ASTNodeAccessImpl implements: Expression

    It represents a “not “ or “!” before an expression.
    NotExpression ()
    NotExpression (expression)
    Expression expression
    NotExpression (expression, useExclamationMark)
    Expression expression
    boolean useExclamationMark
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    isExclamationMark () → boolean
    returns boolean
    setExclamationMark (exclamationMark)
    boolean exclamationMark
    withExpression (expression) → NotExpression
    Expression expression
    withExclamationMark (exclamationMark) → NotExpression
    boolean exclamationMark
    getExpression (part) → E
    Class part
    returns E

    NullValue

    extends: ASTNodeAccessImpl implements: Expression

    NullValue ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String

    NumericBind

    extends: ASTNodeAccessImpl implements: Expression

    NumericBind ()
    getBindId () → int
    returns int
    setBindId (bindId)
    int bindId
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withBindId (bindId) → NumericBind
    int bindId
    returns NumericBind

    OracleHierarchicalExpression

    extends: ASTNodeAccessImpl implements: Expression

    OracleHierarchicalExpression ()
    getStartExpression () → Expression
    returns Expression
    setStartExpression (startExpression)
    Expression startExpression
    getConnectExpression () → Expression
    returns Expression
    setConnectExpression (connectExpression)
    Expression connectExpression
    isNoCycle () → boolean
    returns boolean
    setNoCycle (noCycle)
    boolean noCycle
    isConnectFirst () → boolean
    returns boolean
    setConnectFirst (connectFirst)
    boolean connectFirst
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withStartExpression (startExpression) → OracleHierarchicalExpression
    Expression startExpression
    withConnectExpression (connectExpression) → OracleHierarchicalExpression
    Expression connectExpression
    withNoCycle (noCycle) → OracleHierarchicalExpression
    boolean noCycle
    withConnectFirst (connectFirst) → OracleHierarchicalExpression
    boolean connectFirst
    getStartExpression (part) → E
    Class part
    returns E
    getConnectExpression (part) → E
    Class part
    returns E

    OracleHint

    extends: ASTNodeAccessImpl implements: Expression

    Oracle Hint Expression
    OracleHint ()
    isHintMatch (comment) → boolean
    String comment
    returns boolean
    setComment (comment)
    String comment
    getValue () → String
    returns String
    setValue (value)
    String value
    isSingleLine () → boolean
    returns boolean
    setSingleLine (singleLine)
    boolean singleLine
    @Override
    accept (visitor)
    @Override
    toString () → String
    returns String
    withValue (value) → OracleHint
    String value
    returns OracleHint
    withSingleLine (singleLine) → OracleHint
    boolean singleLine
    returns OracleHint
    getHintFromSelectBody (selectBody) → OracleHint
    Select selectBody
    returns OracleHint

    OracleNamedFunctionParameter

    extends: ASTNodeAccessImpl implements: Expression

    OracleNamedFunctionParameter (name, expression)
    String name
    Expression expression
    getName () → String
    returns String
    getExpression () → Expression
    returns Expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    OrderByClause

    extends: Object implements: Serializable

    OrderByClause ()
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    toStringOrderByElements (b)
    StringBuilder b
    withOrderByElements (orderByElements) → OrderByClause
    List orderByElements
    addOrderByElements (orderByElements) → OrderByClause
    OrderByElement orderByElements
    addOrderByElements (orderByElements) → OrderByClause
    Collection orderByElements

    OverlapsCondition

    extends: ASTNodeAccessImpl implements: Expression

    OverlapsCondition (left, right)
    getLeft () → ExpressionList
    getRight () → ExpressionList
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String

    Parenthesis

    extends: ASTNodeAccessImpl implements: Expression

    It represents an expression like “(” expression “)”
    Parenthesis ()
    Parenthesis (expression)
    Expression expression
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withExpression (expression) → Parenthesis
    Expression expression
    returns Parenthesis
    getExpression (part) → E
    Class part
    returns E

    PartitionByClause

    extends: Object implements: Serializable

    PartitionByClause ()
    getPartitionExpressionList () → ExpressionList
    setPartitionExpressionList (partitionExpressionList)
    ExpressionList partitionExpressionList
    setPartitionExpressionList (partitionExpressionList, brackets)
    ExpressionList partitionExpressionList
    boolean brackets
    toStringPartitionBy (b)
    StringBuilder b
    isBrackets () → boolean
    returns boolean
    withPartitionExpressionList (partitionExpressionList) → PartitionByClause
    ExpressionList partitionExpressionList

    RangeExpression

    extends: ASTNodeAccessImpl implements: Expression

    RangeExpression (startExpression, endExpression)
    Expression startExpression
    Expression endExpression
    getStartExpression () → Expression
    returns Expression
    setStartExpression (startExpression) → RangeExpression
    Expression startExpression
    getEndExpression () → Expression
    returns Expression
    setEndExpression (endExpression) → RangeExpression
    Expression endExpression
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    RowConstructor

    extends: ParenthesedExpressionList implements: Expression

    RowConstructor ()
    RowConstructor (name, expressionList)
    String name
    ExpressionList expressionList
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    toString () → String
    returns String
    withName (name) → RowConstructor
    String name

    RowGetExpression

    extends: ASTNodeAccessImpl implements: Expression

    RowGetExpression (expression, columnName)
    Expression expression
    String columnName
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    getColumnName () → String
    returns String
    setColumnName (columnName)
    String columnName

    SQLServerHints

    extends: Object implements: Serializable

    SQLServerHints ()
    withNoLock () → SQLServerHints
    getNoLock () → Boolean
    returns Boolean
    setNoLock (noLock)
    Boolean noLock
    getIndexName () → String
    returns String
    setIndexName (indexName)
    String indexName
    @Override
    toString () → String
    returns String
    withNoLock (noLock) → SQLServerHints
    Boolean noLock
    withIndexName (indexName) → SQLServerHints
    String indexName

    SignedExpression

    extends: ASTNodeAccessImpl implements: Expression

    It represents a “-” or “+” or “~” before an expression
    SignedExpression ()
    SignedExpression (sign, expression)
    char sign
    Expression expression
    getSign () → char
    returns char
    setSign (sign)
    char sign
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withSign (sign) → SignedExpression
    char sign
    withExpression (expression) → SignedExpression
    Expression expression
    getExpression (part) → E
    Class part
    returns E

    SpannerInterleaveIn

    extends: Object

    SpannerInterleaveIn ()
    SpannerInterleaveIn (table, action)
    Table table
    OnDelete action
    SpannerInterleaveIn (nameParts)
    List nameParts
    SpannerInterleaveIn (tableName)
    String tableName
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getOnDelete () → OnDelete
    returns OnDelete
    setOnDelete (action)
    OnDelete action
    @Override
    toString () → String
    returns String
    withTable (table) → SpannerInterleaveIn
    Table table
    withOnDelete (action) → SpannerInterleaveIn
    OnDelete action

    StringValue

    extends: ASTNodeAccessImpl implements: Expression

    A string as in ‘example_string’
    StringValue ()
    StringValue (escapedValue)
    String escapedValue
    getValue () → String
    returns String
    getPrefix () → String
    returns String
    getNotExcapedValue () → String
    returns String
    setValue (string)
    String string
    setPrefix (prefix)
    String prefix
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withPrefix (prefix) → StringValue
    String prefix
    returns StringValue
    withValue (value) → StringValue
    String value
    returns StringValue
    @Override
    equals (o) → boolean
    Object o
    returns boolean
    @Override
    hashCode () → int
    returns int

    TimeKeyExpression

    extends: ASTNodeAccessImpl implements: Expression

    TimeKeyExpression ()
    TimeKeyExpression (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getStringValue () → String
    returns String
    setStringValue (string)
    String string
    @Override
    toString () → String
    returns String
    withStringValue (stringValue) → TimeKeyExpression
    String stringValue

    TimeValue

    extends: ASTNodeAccessImpl implements: Expression

    A Time in the form {t ‘hh:mm:ss’}
    TimeValue ()
    TimeValue (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → Time
    returns Time
    setValue (d)
    Time d
    @Override
    toString () → String
    returns String
    withValue (value) → TimeValue
    Time value
    returns TimeValue

    TimestampValue

    extends: ASTNodeAccessImpl implements: Expression

    A Timestamp in the form {ts ‘yyyy-mm-dd hh:mm:ss.f …’}
    TimestampValue ()
    TimestampValue (value)
    String value
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getValue () → Timestamp
    returns Timestamp
    setValue (d)
    Timestamp d
    getRawValue () → String
    returns String
    setRawValue (rawValue)
    String rawValue
    @Override
    toString () → String
    returns String
    withValue (value) → TimestampValue
    Timestamp value

    TimezoneExpression

    extends: ASTNodeAccessImpl implements: Expression

    TimezoneExpression ()
    getLeftExpression () → Expression
    returns Expression
    setLeftExpression (expression)
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getTimezoneExpressions () → List
    returns List
    addTimezoneExpression (timezoneExpr)
    Expression timezoneExpr
    @Override
    toString () → String
    returns String

    TranscodingFunction

    extends: ASTNodeAccessImpl implements: Expression

    TranscodingFunction (expression, transcodingName)
    Expression expression
    String transcodingName
    TranscodingFunction ()
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    withExpression (expression) → TranscodingFunction
    Expression expression
    getTranscodingName () → String
    returns String
    setTranscodingName (transcodingName)
    String transcodingName
    withTranscodingName (transcodingName) → TranscodingFunction
    String transcodingName
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    TrimFunction

    extends: ASTNodeAccessImpl implements: Expression

    TrimFunction (trimSpecification, expression, fromExpression, isUsingFromKeyword)
    TrimSpecification trimSpecification
    Expression expression
    Expression fromExpression
    boolean isUsingFromKeyword
    TrimFunction ()
    getTrimSpecification () → TrimSpecification
    returns TrimSpecification
    setTrimSpecification (trimSpecification)
    TrimSpecification trimSpecification
    withTrimSpecification (trimSpecification) → TrimFunction
    TrimSpecification trimSpecification
    returns TrimFunction
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    withExpression (expression) → TrimFunction
    Expression expression
    returns TrimFunction
    getFromExpression () → Expression
    returns Expression
    setFromExpression (fromExpression)
    Expression fromExpression
    withFromExpression (fromExpression) → TrimFunction
    Expression fromExpression
    returns TrimFunction
    isUsingFromKeyword () → boolean
    returns boolean
    setUsingFromKeyword (useFromKeyword)
    boolean useFromKeyword
    withUsingFromKeyword (useFromKeyword) → TrimFunction
    boolean useFromKeyword
    returns TrimFunction
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    UserVariable

    extends: ASTNodeAccessImpl implements: Expression

    Simple uservariables like @test.
    UserVariable ()
    UserVariable (name)
    String name
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    isDoubleAdd () → boolean
    returns boolean
    setDoubleAdd (doubleAdd)
    boolean doubleAdd
    @Override
    toString () → String
    returns String
    withName (name) → UserVariable
    String name
    returns UserVariable
    withDoubleAdd (doubleAdd) → UserVariable
    boolean doubleAdd
    returns UserVariable

    VariableAssignment

    extends: ASTNodeAccessImpl implements: Expression

    Assignment to a user variable like in select @a = 5.
    VariableAssignment ()
    getVariable () → UserVariable
    returns UserVariable
    setVariable (variable)
    UserVariable variable
    getOperation () → String
    returns String
    setOperation (operation)
    String operation
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    WhenClause

    extends: ASTNodeAccessImpl implements: Expression

    A clause of following syntax: WHEN condition THEN expression. Which is part of a CaseExpression.
    WhenClause ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getThenExpression () → Expression
    returns Expression
    setThenExpression (thenExpression)
    Expression thenExpression
    getWhenExpression () → Expression
    returns Expression | Returns the whenExpression.
    setWhenExpression (whenExpression)
    Expression whenExpression | whenExpression The whenExpression to set.
    @Override
    toString () → String
    returns String
    withWhenExpression (whenExpression) → WhenClause
    Expression whenExpression
    returns WhenClause
    withThenExpression (thenExpression) → WhenClause
    Expression thenExpression
    returns WhenClause
    getThenExpression (part) → E
    Class part
    returns E
    getWhenExpression (part) → E
    Class part
    returns E

    WindowDefinition

    extends: Object implements: Serializable

    WindowDefinition ()
    getOrderBy () → OrderByClause
    getPartitionBy () → PartitionByClause
    getWindowElement () → WindowElement
    setWindowElement (windowElement)
    WindowElement windowElement
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getPartitionExpressionList () → ExpressionList
    setPartitionExpressionList (partitionExpressionList)
    ExpressionList partitionExpressionList
    setPartitionExpressionList (partitionExpressionList, brackets)
    ExpressionList partitionExpressionList
    boolean brackets
    getWindowName () → String
    returns String
    setWindowName (windowName)
    String windowName
    withWindowName (windowName) → WindowDefinition
    String windowName
    @Override
    toString () → String
    returns String

    WindowElement

    extends: Object implements: Serializable

    WindowElement ()
    getType () → Type
    returns Type
    setType (part)
    Type part
    getOffset () → WindowOffset
    returns WindowOffset
    setOffset (offset)
    getRange () → WindowRange
    returns WindowRange
    setRange (range)
    @Override
    toString () → String
    returns String
    withType (part) → WindowElement
    Type part
    withOffset (offset) → WindowElement
    withRange (range) → WindowElement

    WindowOffset

    extends: Object implements: Serializable

    WindowOffset ()
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    getType () → Type
    returns Type
    setType (part)
    Type part
    @Override
    toString () → String
    returns String
    withExpression (expression) → WindowOffset
    Expression expression
    returns WindowOffset
    withType (part) → WindowOffset
    Type part
    returns WindowOffset
    getExpression (part) → E
    Class part
    returns E

    WindowRange

    extends: Object implements: Serializable

    WindowRange ()
    getEnd () → WindowOffset
    returns WindowOffset
    setEnd (end)
    getStart () → WindowOffset
    returns WindowOffset
    setStart (start)
    @Override
    toString () → String
    returns String
    withStart (start) → WindowRange
    returns WindowRange
    withEnd (end) → WindowRange

    XMLSerializeExpr

    extends: ASTNodeAccessImpl implements: Expression

    XMLSerializeExpr ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    getDataType () → ColDataType
    returns ColDataType
    setDataType (dataType)
    ColDataType dataType
    @Override
    toString () → String
    returns String

    Expression

    implements: ASTNodeAccess, Model provides: AllColumns, AllValue, AnalyticExpression, AnyComparisonExpression, ArrayConstructor, ArrayExpression, Between, BinaryExpression, CaseExpression, CastExpression, CollateExpression, Column, ConnectByRootOperator, DateTimeLiteralExpression, DateValue, DoubleValue, ExistsExpression, ExpressionList, ExtractExpression, FullTextSearch, Function, HexValue, InExpression, IntervalExpression, IsBooleanExpression, IsNullExpression, JdbcNamedParameter, JdbcParameter, JsonAggregateFunction, JsonExpression, JsonFunction, KeepExpression, LongValue, MemberOfExpression, MultipleExpression, MySQLGroupConcat, NextValExpression, NotExpression, NullValue, NumericBind, OracleHierarchicalExpression, OracleHint, OracleNamedFunctionParameter, OverlapsCondition, Parenthesis, RangeExpression, RowConstructor, RowGetExpression, Select, SignedExpression, StringValue, TimeKeyExpression, TimeValue, TimestampValue, TimezoneExpression, TranscodingFunction, TrimFunction, UserVariable, VariableAssignment, WhenClause, XMLSerializeExpr,

    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    ExpressionVisitor

    provides: ExpressionDeParser, ExpressionValidator, ExpressionVisitorAdapter, TablesNamesFinder,

    visit (aThis)
    visit (aThis)
    visit (nullValue)
    NullValue nullValue
    visit (function)
    Function function
    visit (signedExpression)
    SignedExpression signedExpression
    visit (jdbcParameter)
    JdbcParameter jdbcParameter
    visit (jdbcNamedParameter)
    JdbcNamedParameter jdbcNamedParameter
    visit (doubleValue)
    DoubleValue doubleValue
    visit (longValue)
    LongValue longValue
    visit (hexValue)
    HexValue hexValue
    visit (dateValue)
    DateValue dateValue
    visit (timeValue)
    TimeValue timeValue
    visit (timestampValue)
    TimestampValue timestampValue
    visit (parenthesis)
    Parenthesis parenthesis
    visit (stringValue)
    StringValue stringValue
    visit (addition)
    Addition addition
    visit (division)
    Division division
    visit (division)
    visit (multiplication)
    Multiplication multiplication
    visit (subtraction)
    Subtraction subtraction
    visit (andExpression)
    AndExpression andExpression
    visit (orExpression)
    OrExpression orExpression
    visit (orExpression)
    XorExpression orExpression
    visit (between)
    Between between
    visit (overlapsCondition)
    OverlapsCondition overlapsCondition
    visit (equalsTo)
    EqualsTo equalsTo
    visit (greaterThan)
    GreaterThan greaterThan
    visit (greaterThanEquals)
    GreaterThanEquals greaterThanEquals
    visit (inExpression)
    InExpression inExpression
    visit (fullTextSearch)
    FullTextSearch fullTextSearch
    visit (isNullExpression)
    IsNullExpression isNullExpression
    visit (isBooleanExpression)
    IsBooleanExpression isBooleanExpression
    visit (likeExpression)
    LikeExpression likeExpression
    visit (minorThan)
    MinorThan minorThan
    visit (minorThanEquals)
    MinorThanEquals minorThanEquals
    visit (notEqualsTo)
    NotEqualsTo notEqualsTo
    visit (doubleAnd)
    DoubleAnd doubleAnd
    visit (contains)
    Contains contains
    visit (containedBy)
    ContainedBy containedBy
    visit (selectBody)
    visit (tableColumn)
    Column tableColumn
    visit (caseExpression)
    CaseExpression caseExpression
    visit (whenClause)
    WhenClause whenClause
    visit (existsExpression)
    ExistsExpression existsExpression
    visit (memberOfExpression)
    MemberOfExpression memberOfExpression
    visit (anyComparisonExpression)
    AnyComparisonExpression anyComparisonExpression
    visit (concat)
    Concat concat
    visit (matches)
    Matches matches
    visit (bitwiseAnd)
    BitwiseAnd bitwiseAnd
    visit (bitwiseOr)
    BitwiseOr bitwiseOr
    visit (bitwiseXor)
    BitwiseXor bitwiseXor
    visit (cast)
    visit (modulo)
    Modulo modulo
    visit (aexpr)
    visit (eexpr)
    visit (iexpr)
    visit (oexpr)
    visit (rexpr)
    visit (jsonExpr)
    visit (jsonExpr)
    JsonOperator jsonExpr
    visit (var)
    visit (bind)
    visit (aexpr)
    visit (groupConcat)
    MySQLGroupConcat groupConcat
    visit (expressionList)
    ExpressionList expressionList
    visit (rowConstructor)
    RowConstructor rowConstructor
    visit (rowGetExpression)
    RowGetExpression rowGetExpression
    visit (hint)
    visit (timeKeyExpression)
    TimeKeyExpression timeKeyExpression
    visit (literal)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (allColumns)
    AllColumns allColumns
    visit (allTableColumns)
    AllTableColumns allTableColumns
    visit (allValue)
    AllValue allValue
    visit (isDistinctExpression)
    IsDistinctExpression isDistinctExpression
    visit (geometryDistance)
    GeometryDistance geometryDistance
    visit (selectBody)
    Select selectBody
    visit (transcodingFunction)
    TranscodingFunction transcodingFunction
    visit (trimFunction)
    TrimFunction trimFunction
    visit (rangeExpression)
    RangeExpression rangeExpression
    visit (tsqlLeftJoin)
    TSQLLeftJoin tsqlLeftJoin
    visit (tsqlRightJoin)
    TSQLRightJoin tsqlRightJoin

    expression.operators.arithmetic

    Addition

    extends: BinaryExpression

    Addition ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Addition
    returns Addition
    @Override
    withRightExpression (arg0) → Addition
    returns Addition

    BitwiseAnd

    extends: BinaryExpression

    BitwiseAnd ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseAnd
    returns BitwiseAnd
    @Override
    withRightExpression (arg0) → BitwiseAnd
    returns BitwiseAnd

    BitwiseLeftShift

    extends: BinaryExpression

    BitwiseLeftShift ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseLeftShift
    @Override
    withRightExpression (arg0) → BitwiseLeftShift

    BitwiseOr

    extends: BinaryExpression

    BitwiseOr ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseOr
    returns BitwiseOr
    @Override
    withRightExpression (arg0) → BitwiseOr
    returns BitwiseOr

    BitwiseRightShift

    extends: BinaryExpression

    BitwiseRightShift ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseRightShift
    @Override
    withRightExpression (arg0) → BitwiseRightShift

    BitwiseXor

    extends: BinaryExpression

    BitwiseXor ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → BitwiseXor
    returns BitwiseXor
    @Override
    withRightExpression (arg0) → BitwiseXor
    returns BitwiseXor

    Concat

    extends: BinaryExpression

    Concat ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Concat
    returns Concat
    @Override
    withRightExpression (arg0) → Concat
    returns Concat

    Division

    extends: BinaryExpression

    Division ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Division
    returns Division
    @Override
    withRightExpression (arg0) → Division
    returns Division

    IntegerDivision

    extends: BinaryExpression

    IntegerDivision ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → IntegerDivision
    @Override
    withRightExpression (arg0) → IntegerDivision

    Modulo

    extends: BinaryExpression

    Modulo expression (a % b).
    Modulo ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Modulo
    returns Modulo
    @Override
    withRightExpression (arg0) → Modulo
    returns Modulo

    Multiplication

    extends: BinaryExpression

    Multiplication ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Multiplication
    @Override
    withRightExpression (arg0) → Multiplication

    Subtraction

    extends: BinaryExpression

    Subtraction ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Subtraction
    returns Subtraction
    @Override
    withRightExpression (arg0) → Subtraction
    returns Subtraction

    expression.operators.conditional

    AndExpression

    extends: BinaryExpression

    AndExpression ()
    AndExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    setUseOperator (useOperator)
    boolean useOperator
    isUseOperator () → boolean
    returns boolean
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    withUseOperator (useOperator) → AndExpression
    boolean useOperator
    @Override
    withLeftExpression (arg0) → AndExpression
    @Override
    withRightExpression (arg0) → AndExpression

    OrExpression

    extends: BinaryExpression

    OrExpression ()
    OrExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    @Override
    withLeftExpression (expression) → OrExpression
    Expression expression
    returns OrExpression
    @Override
    withRightExpression (expression) → OrExpression
    Expression expression
    returns OrExpression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String

    XorExpression

    extends: BinaryExpression

    XorExpression ()
    XorExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    @Override
    withLeftExpression (expression) → XorExpression
    Expression expression
    @Override
    withRightExpression (expression) → XorExpression
    Expression expression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String

    expression.operators.relational

    LikeExpression.KeyWord

    [LIKE, ILIKE, RLIKE, REGEXP]

    RegExpMatchOperatorType

    [MATCH_CASESENSITIVE, MATCH_CASEINSENSITIVE, NOT_MATCH_CASESENSITIVE, NOT_MATCH_CASEINSENSITIVE]

    PostgresSQL match operators.

    Between

    extends: ASTNodeAccessImpl implements: Expression

    A “BETWEEN” expr1 expr2 statement
    Between ()
    getBetweenExpressionEnd () → Expression
    returns Expression
    getBetweenExpressionStart () → Expression
    returns Expression
    getLeftExpression () → Expression
    returns Expression
    isNot () → boolean
    returns boolean
    setBetweenExpressionEnd (expression)
    Expression expression
    setBetweenExpressionStart (expression)
    Expression expression
    setLeftExpression (expression)
    Expression expression
    setNot (b)
    boolean b
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withLeftExpression (leftExpression) → Between
    Expression leftExpression
    returns Between
    withNot (not) → Between
    boolean not
    returns Between
    withBetweenExpressionStart (betweenExpressionStart) → Between
    Expression betweenExpressionStart
    returns Between
    withBetweenExpressionEnd (betweenExpressionEnd) → Between
    Expression betweenExpressionEnd
    returns Between
    getBetweenExpressionEnd (part) → E
    Class part
    returns E
    getBetweenExpressionStart (part) → E
    Class part
    returns E
    getLeftExpression (part) → E
    Class part
    returns E

    ComparisonOperator

    extends: OldOracleJoinBinaryExpression provides: ContainedBy, Contains, DoubleAnd, EqualsTo, GeometryDistance, GreaterThan, GreaterThanEquals, MinorThan, MinorThanEquals, NotEqualsTo, TSQLLeftJoin, TSQLRightJoin

    ComparisonOperator (operator)
    String operator
    ComparisonOperator (operator, left, right)
    String operator
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → ComparisonOperator
    @Override
    withRightExpression (arg0) → ComparisonOperator
    @Override
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → ComparisonOperator
    int oldOracleJoinSyntax
    @Override
    withOraclePriorPosition (oraclePriorPosition) → ComparisonOperator
    int oraclePriorPosition

    ContainedBy

    extends: ComparisonOperator

    ContainedBy ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    Contains

    extends: ComparisonOperator

    Contains ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    DoubleAnd

    extends: ComparisonOperator

    DoubleAnd ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    EqualsTo

    extends: ComparisonOperator

    EqualsTo ()
    EqualsTo (left, right)
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (expression) → EqualsTo
    Expression expression
    returns EqualsTo
    @Override
    withRightExpression (expression) → EqualsTo
    Expression expression
    returns EqualsTo
    @Override
    withOldOracleJoinSyntax (arg0) → EqualsTo
    int arg0
    returns EqualsTo
    @Override
    withOraclePriorPosition (arg0) → EqualsTo
    int arg0
    returns EqualsTo

    ExistsExpression

    extends: ASTNodeAccessImpl implements: Expression

    ExistsExpression ()
    getRightExpression () → Expression
    returns Expression
    setRightExpression (expression)
    Expression expression
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String
    withRightExpression (rightExpression) → ExistsExpression
    Expression rightExpression
    withNot (not) → ExistsExpression
    boolean not
    getRightExpression (part) → E
    Class part
    returns E

    ExpressionList

    extends: ArrayList implements: Expression, Serializable provides: NamedExpressionList, ParenthesedExpressionList

    A list of expressions, as in SELECT A FROM TAB WHERE B IN (expr1,expr2,expr3)
    ExpressionList (expressions)
    Collection expressions
    ExpressionList (expressions)
    List expressions
    ExpressionList (expressions)
    T expressions
    @Deprecated
    isUsingBrackets () → boolean
    returns boolean
    @Deprecated
    getExpressions () → List
    returns List
    @Deprecated
    setExpressions (expressions)
    List expressions
    addExpression (expression) → ExpressionList
    T expression
    addExpressions (expressions) → ExpressionList
    T expressions
    addExpressions (expressions) → ExpressionList
    Collection expressions
    withExpressions (expressions) → ExpressionList
    T expressions
    withExpressions (expressions) → ExpressionList
    Collection expressions
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getASTNode () → SimpleNode
    returns SimpleNode
    @Override
    setASTNode (node)
    SimpleNode node

    FullTextSearch

    extends: ASTNodeAccessImpl implements: Expression

    FullTextSearch ()
    setMatchColumns (columns)
    getMatchColumns () → ExpressionList
    setAgainstValue (val)
    setAgainstValue (val)
    setAgainstValue (val)
    getAgainstValue () → Expression
    returns Expression
    setSearchModifier (val)
    String val
    getSearchModifier () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withMatchColumns (matchColumns) → FullTextSearch
    ExpressionList matchColumns
    withAgainstValue (againstValue) → FullTextSearch
    StringValue againstValue
    withSearchModifier (searchModifier) → FullTextSearch
    String searchModifier
    addMatchColumns (matchColumns) → FullTextSearch
    Column matchColumns
    addMatchColumns (matchColumns) → FullTextSearch
    Collection matchColumns

    GeometryDistance

    extends: ComparisonOperator

    GeometryDistance ()
    GeometryDistance (operator)
    String operator
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    GreaterThan

    extends: ComparisonOperator

    GreaterThan ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (arg0) → GreaterThan
    returns GreaterThan
    @Override
    withRightExpression (arg0) → GreaterThan
    returns GreaterThan
    @Override
    withOldOracleJoinSyntax (arg0) → GreaterThan
    int arg0
    returns GreaterThan
    @Override
    withOraclePriorPosition (arg0) → GreaterThan
    int arg0
    returns GreaterThan

    GreaterThanEquals

    extends: ComparisonOperator

    GreaterThanEquals ()
    GreaterThanEquals (operator)
    String operator
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (arg0) → GreaterThanEquals
    @Override
    withRightExpression (arg0) → GreaterThanEquals
    @Override
    withOldOracleJoinSyntax (arg0) → GreaterThanEquals
    int arg0
    @Override
    withOraclePriorPosition (arg0) → GreaterThanEquals
    int arg0

    InExpression

    extends: ASTNodeAccessImpl implements: Expression, SupportsOldOracleJoinSyntax

    InExpression ()
    InExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    @Override
    setOldOracleJoinSyntax (oldOracleJoinSyntax)
    int oldOracleJoinSyntax
    @Override
    getOldOracleJoinSyntax () → int
    returns int
    getLeftExpression () → Expression
    returns Expression
    withLeftExpression (expression) → InExpression
    Expression expression
    returns InExpression
    setLeftExpression (expression)
    Expression expression
    isGlobal () → boolean
    returns boolean
    setGlobal (b) → InExpression
    boolean b
    returns InExpression
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    getRightExpression () → Expression
    returns Expression
    setRightExpression (rightExpression)
    Expression rightExpression
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    @Override
    getOraclePriorPosition () → int
    returns int
    @Override
    setOraclePriorPosition (priorPosition)
    int priorPosition
    withRightExpression (rightExpression) → InExpression
    Expression rightExpression
    returns InExpression
    @Override
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → InExpression
    int oldOracleJoinSyntax
    returns InExpression
    @Override
    withOraclePriorPosition (priorPosition) → InExpression
    int priorPosition
    returns InExpression
    withGlobal (global) → InExpression
    boolean global
    returns InExpression
    withNot (not) → InExpression
    boolean not
    returns InExpression
    getLeftExpression (part) → E
    Class part
    returns E
    getRightExpression (part) → E
    Class part
    returns E

    IsBooleanExpression

    extends: ASTNodeAccessImpl implements: Expression

    IsBooleanExpression ()
    getLeftExpression () → Expression
    returns Expression
    isNot () → boolean
    returns boolean
    setLeftExpression (expression)
    Expression expression
    setNot (b)
    boolean b
    isTrue () → boolean
    returns boolean
    setIsTrue (isTrue)
    boolean isTrue
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withIsTrue (isTrue) → IsBooleanExpression
    boolean isTrue
    withLeftExpression (leftExpression) → IsBooleanExpression
    Expression leftExpression
    withNot (not) → IsBooleanExpression
    boolean not
    getLeftExpression (part) → E
    Class part
    returns E

    IsDistinctExpression

    extends: BinaryExpression

    IsDistinctExpression ()
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String

    IsNullExpression

    extends: ASTNodeAccessImpl implements: Expression

    IsNullExpression ()
    getLeftExpression () → Expression
    returns Expression
    isNot () → boolean
    returns boolean
    setLeftExpression (expression)
    Expression expression
    setNot (b)
    boolean b
    isUseIsNull () → boolean
    returns boolean
    setUseIsNull (useIsNull)
    boolean useIsNull
    isUseNotNull () → boolean
    returns boolean
    setUseNotNull (useNotNull) → IsNullExpression
    boolean useNotNull
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withUseIsNull (useIsNull) → IsNullExpression
    boolean useIsNull
    withLeftExpression (leftExpression) → IsNullExpression
    Expression leftExpression
    withNot (not) → IsNullExpression
    boolean not
    getLeftExpression (part) → E
    Class part
    returns E

    JsonOperator

    extends: BinaryExpression

    JsonOperator (op)
    String op
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → JsonOperator
    returns JsonOperator
    @Override
    withRightExpression (arg0) → JsonOperator
    returns JsonOperator

    LikeExpression

    extends: BinaryExpression

    LikeExpression ()
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    isUseBinary () → boolean
    returns boolean
    setUseBinary (useBinary) → LikeExpression
    boolean useBinary
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Deprecated,| @Override
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String
    getEscape () → Expression
    returns Expression
    setEscape (escapeExpression)
    Expression escapeExpression
    @Deprecated
    isCaseInsensitive () → boolean
    returns boolean
    @Deprecated
    setCaseInsensitive (caseInsensitive)
    boolean caseInsensitive
    getLikeKeyWord () → KeyWord
    returns KeyWord
    setLikeKeyWord (likeKeyWord) → LikeExpression
    KeyWord likeKeyWord
    setLikeKeyWord (likeKeyWord) → LikeExpression
    String likeKeyWord
    withEscape (escape) → LikeExpression
    Expression escape
    @Deprecated
    withCaseInsensitive (caseInsensitive) → LikeExpression
    boolean caseInsensitive
    withNot (not) → LikeExpression
    boolean not
    @Override
    withLeftExpression (arg0) → LikeExpression
    @Override
    withRightExpression (arg0) → LikeExpression

    Matches

    extends: OldOracleJoinBinaryExpression

    Matches ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → Matches
    returns Matches
    @Override
    withRightExpression (arg0) → Matches
    returns Matches
    @Override
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → Matches
    int oldOracleJoinSyntax
    returns Matches
    @Override
    withOraclePriorPosition (oraclePriorPosition) → Matches
    int oraclePriorPosition
    returns Matches

    MemberOfExpression

    extends: ASTNodeAccessImpl implements: Expression

    MemberOfExpression (leftExpression, rightExpression)
    Expression leftExpression
    Expression rightExpression
    getLeftExpression () → Expression
    returns Expression
    setLeftExpression (leftExpression) → MemberOfExpression
    Expression leftExpression
    getRightExpression () → Expression
    returns Expression
    setRightExpression (rightExpression) → MemberOfExpression
    Expression rightExpression
    isNot () → boolean
    returns boolean
    setNot (not) → MemberOfExpression
    boolean not
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    MinorThan

    extends: ComparisonOperator

    MinorThan ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (arg0) → MinorThan
    returns MinorThan
    @Override
    withRightExpression (arg0) → MinorThan
    returns MinorThan
    @Override
    withOldOracleJoinSyntax (arg0) → MinorThan
    int arg0
    returns MinorThan
    @Override
    withOraclePriorPosition (arg0) → MinorThan
    int arg0
    returns MinorThan

    MinorThanEquals

    extends: ComparisonOperator

    MinorThanEquals ()
    MinorThanEquals (operator)
    String operator
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withLeftExpression (arg0) → MinorThanEquals
    @Override
    withRightExpression (arg0) → MinorThanEquals
    @Override
    withOldOracleJoinSyntax (arg0) → MinorThanEquals
    int arg0
    @Override
    withOraclePriorPosition (arg0) → MinorThanEquals
    int arg0

    NamedExpressionList

    extends: ExpressionList

    A list of named expressions, as in as in select substr(‘xyzzy’ from 2 for 3)
    NamedExpressionList ()
    getNames () → List
    returns List
    setNames (list)
    List list
    @Override
    toString () → String
    returns String
    withNames (names) → NamedExpressionList
    List names
    addNames (names) → NamedExpressionList
    String names
    addNames (names) → NamedExpressionList
    Collection names

    NotEqualsTo

    extends: ComparisonOperator

    NotEqualsTo ()
    NotEqualsTo (operator)
    String operator
    NotEqualsTo (left, right)
    @Override
    withLeftExpression (expression) → NotEqualsTo
    Expression expression
    returns NotEqualsTo
    @Override
    withRightExpression (expression) → NotEqualsTo
    Expression expression
    returns NotEqualsTo
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    withOldOracleJoinSyntax (arg0) → NotEqualsTo
    int arg0
    returns NotEqualsTo
    @Override
    withOraclePriorPosition (arg0) → NotEqualsTo
    int arg0
    returns NotEqualsTo

    OldOracleJoinBinaryExpression

    extends: BinaryExpression implements: SupportsOldOracleJoinSyntax provides: ComparisonOperator, Matches

    OldOracleJoinBinaryExpression ()
    @Override
    setOldOracleJoinSyntax (oldOracleJoinSyntax)
    int oldOracleJoinSyntax
    @Override
    toString () → String
    returns String
    @Override
    getOldOracleJoinSyntax () → int
    returns int
    @Override
    getOraclePriorPosition () → int
    returns int
    @Override
    setOraclePriorPosition (oraclePriorPosition)
    int oraclePriorPosition
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → OldOracleJoinBinaryExpression
    int oldOracleJoinSyntax
    withOraclePriorPosition (oraclePriorPosition) → OldOracleJoinBinaryExpression
    int oraclePriorPosition
    @Override
    withLeftExpression (arg0) → OldOracleJoinBinaryExpression
    @Override
    withRightExpression (arg0) → OldOracleJoinBinaryExpression

    ParenthesedExpressionList

    extends: ExpressionList provides: RowConstructor

    ParenthesedExpressionList ()
    ParenthesedExpressionList (expressions)
    ExpressionList expressions
    ParenthesedExpressionList (expressions)
    T expressions
    ParenthesedExpressionList (expressions)
    Collection expressions
    from (expressions) → ParenthesedExpressionList
    @Override
    toString () → String
    returns String

    RegExpMatchOperator

    extends: BinaryExpression

    RegExpMatchOperator (operatorType)
    RegExpMatchOperatorType operatorType
    getOperatorType () → RegExpMatchOperatorType
    returns RegExpMatchOperatorType
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    withLeftExpression (arg0) → RegExpMatchOperator
    @Override
    withRightExpression (arg0) → RegExpMatchOperator

    SimilarToExpression

    extends: BinaryExpression

    SimilarToExpression ()
    isNot () → boolean
    returns boolean
    setNot (b)
    boolean b
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String
    getEscape () → String
    returns String
    setEscape (escape)
    String escape
    withEscape (escape) → SimilarToExpression
    String escape
    withNot (not) → SimilarToExpression
    boolean not
    @Override
    withLeftExpression (arg0) → SimilarToExpression
    @Override
    withRightExpression (arg0) → SimilarToExpression

    TSQLLeftJoin

    extends: ComparisonOperator

    TSQLLeftJoin ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    TSQLRightJoin

    extends: ComparisonOperator

    TSQLRightJoin ()
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    SupportsOldOracleJoinSyntax

    provides: InExpression, OldOracleJoinBinaryExpression,

    getOldOracleJoinSyntax () → int
    returns int
    setOldOracleJoinSyntax (oldOracleJoinSyntax)
    int oldOracleJoinSyntax
    withOldOracleJoinSyntax (oldOracleJoinSyntax) → SupportsOldOracleJoinSyntax
    int oldOracleJoinSyntax
    getOraclePriorPosition () → int
    returns int
    setOraclePriorPosition (priorPosition)
    int priorPosition
    withOraclePriorPosition (priorPosition) → SupportsOldOracleJoinSyntax
    int priorPosition

    parser

    ASTNodeAccessImpl

    extends: Object implements: ASTNodeAccess provides: AllColumns, AllValue, AnalyticExpression, AnyComparisonExpression, ArrayConstructor, ArrayExpression, Between, BinaryExpression, CaseExpression, CastExpression, CollateExpression, Column, ConnectByRootOperator, DateTimeLiteralExpression, DateValue, DoubleValue, ExistsExpression, ExtractExpression, FilterOverImpl, ForClause, FullTextSearch, Function, HexValue, InExpression, IntervalExpression, IsBooleanExpression, IsNullExpression, JdbcNamedParameter, JdbcParameter, Join, JsonExpression, JsonFunction, KSQLJoinWindow, KSQLWindow, KeepExpression, Limit, LongValue, MemberOfExpression, MultipleExpression, MySQLGroupConcat, NextValExpression, NotExpression, NullValue, NumericBind, OracleHierarchicalExpression, OracleHint, OracleNamedFunctionParameter, OverlapsCondition, Parenthesis, RangeExpression, RowGetExpression, Select, SelectItem, Sequence, SetOperation, SignedExpression, StringValue, Synonym, Table, TimeKeyExpression, TimeValue, TimestampValue, TimezoneExpression, TranscodingFunction, TrimFunction, UserVariable, VariableAssignment, WhenClause, XMLSerializeExpr

    ASTNodeAccessImpl ()
    @Override
    getASTNode () → SimpleNode
    returns SimpleNode
    @Override
    setASTNode (node)
    SimpleNode node
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder

    AbstractJSqlParser

    extends: Object

    AbstractJSqlParser ()
    withSquareBracketQuotation (allowSquareBracketQuotation) → P
    boolean allowSquareBracketQuotation
    returns P
    withAllowComplexParsing (allowComplexParsing) → P
    boolean allowComplexParsing
    returns P
    withUnsupportedStatements (allowUnsupportedStatements) → P
    boolean allowUnsupportedStatements
    returns P
    withTimeOut (timeOutMillSeconds) → P
    long timeOutMillSeconds
    returns P
    withBackslashEscapeCharacter (allowBackslashEscapeCharacter) → P
    boolean allowBackslashEscapeCharacter
    returns P
    withFeature (f, enabled) → P
    Feature f
    boolean enabled
    returns P
    withFeature (f, value) → P
    Feature f
    long value
    returns P
    getConfiguration () → FeatureConfiguration
    me () → P
    returns P
    getAsBoolean (f) → boolean
    Feature f
    returns boolean
    getAsLong (f) → Long
    Feature f
    returns Long
    setErrorRecovery (errorRecovery)
    boolean errorRecovery
    getParseErrors () → List
    returns List

    BaseToken

    extends: Object

    BaseToken ()

    CCJSqlParserManager

    extends: Object implements: JSqlParser

    CCJSqlParserManager ()
    @Override
    parse (statementReader) → Statement
    Reader statementReader
    returns Statement

    CCJSqlParserUtil

    extends: Object

    Toolfunctions to start and use JSqlParser.
    parse (statementReader) → Statement
    Reader statementReader
    returns Statement
    parse (sql) → Statement
    String sql
    returns Statement
    parse (sql, consumer) → Statement
    Parses an sql statement while allowing via consumer to configure the used parser before. For instance to activate SQLServer bracket quotation on could use: {@code CCJSqlParserUtil.parse(“select * from [mytable]”, parser -> parser.withSquareBracketQuotation(true)); }
    String sql
    Consumer consumer
    returns Statement |
    parse (sql, executorService, consumer) → Statement
    String sql
    ExecutorService executorService
    Consumer consumer
    returns Statement
    newParser (sql) → CCJSqlParser
    String sql
    returns CCJSqlParser
    newParser (is) → CCJSqlParser
    InputStream is
    returns CCJSqlParser
    newParser (is, encoding) → CCJSqlParser
    InputStream is
    String encoding
    returns CCJSqlParser
    parseAST (sql) → Node
    String sql
    returns Node
    parse (is) → Statement
    InputStream is
    returns Statement
    parse (is, encoding) → Statement
    InputStream is
    String encoding
    returns Statement
    parseExpression (expression) → Expression
    String expression
    returns Expression
    parseExpression (expression, allowPartialParse) → Expression
    String expression
    boolean allowPartialParse
    returns Expression
    @SuppressWarnings
    parseExpression (expressionStr, allowPartialParse, consumer) → Expression
    String expressionStr
    boolean allowPartialParse
    Consumer consumer
    returns Expression
    parseCondExpression (condExpr) → Expression
    Parse an conditional expression. This is the expression after a where clause. Partial parsing is enabled.
    String condExpr
    returns Expression | the expression parsed
    parseCondExpression (condExpr, allowPartialParse) → Expression
    Parse an conditional expression. This is the expression after a where clause.
    String condExpr
    boolean allowPartialParse | allowPartialParse false: needs the whole string to be processed.
    returns Expression | the expression parsed
    @SuppressWarnings
    parseCondExpression (conditionalExpressionStr, allowPartialParse, consumer) → Expression
    String conditionalExpressionStr
    boolean allowPartialParse
    Consumer consumer
    returns Expression
    parseStatement (parser, executorService) → Statement
    CCJSqlParser parser | parser the Parser armed with a Statement text
    ExecutorService executorService | executorService the Executor Service for parsing within a Thread
    returns Statement | the parsed Statement
    parseStatements (sqls) → Statements
    Parse a statement list.
    String sqls
    returns Statements | the statements parsed
    parseStatements (sqls, consumer) → Statements
    String sqls
    Consumer consumer
    returns Statements
    parseStatements (sqls, executorService, consumer) → Statements
    Parse a statement list.
    String sqls
    ExecutorService executorService
    Consumer consumer
    returns Statements | the statements parsed
    parseStatements (parser, executorService) → Statements
    CCJSqlParser parser | parser the Parser armed with a Statement text
    ExecutorService executorService | executorService the Executor Service for parsing within a Thread
    returns Statements | the Statements (representing a List of single statements)
    streamStatements (listener, is, encoding)
    InputStream is
    String encoding
    getNestingDepth (sql) → int
    String sql
    returns int
    getUnbalancedPosition (text) → int
    String text
    returns int

    ParserKeywordsUtils

    extends: Object

    ParserKeywordsUtils ()
    @SuppressWarnings
    getReservedKeywords (restriction) → List
    int restriction
    returns List
    main (args)
    String args | args with: Grammar File, Keyword Documentation File
    getAllKeywordsUsingRegex (file) → TreeSet
    File file
    returns TreeSet
    buildGrammarForRelObjectNameWithoutValue (file)
    File file
    buildGrammarForRelObjectName (file)
    File file
    getAllKeywords (file) → TreeSet
    File file
    returns TreeSet
    rightPadding (input, ch, length) → String
    String input
    char ch
    int length
    returns String
    writeKeywordsDocumentationFile (file)
    File file

    SimpleCharStream

    extends: Object

    SimpleCharStream (dstream, startline, startcolumn, buffersize)
    Constructor
    Provider dstream
    int startline
    int startcolumn
    int buffersize
    SimpleCharStream (dstream, startline, startcolumn)
    Constructor
    Provider dstream
    int startline
    int startcolumn
    SimpleCharStream (dstream)
    Constructor
    Provider dstream
    setTabSize (i)
    int i
    getTabSize () → int
    returns int
    getAbsoluteTokenBegin () → int
    returns int
    boolean wrapAround
    returns void
    returns void
    BeginToken () → char
    Start.
    returns char | the character read
    char c
    returns void
    readChar () → char
    Read a character.
    returns char | the character read
    @Deprecated
    getColumn () → int
    returns int | the column
    @Deprecated
    getLine () → int
    returns int | the line
    getEndColumn () → int
    returns int | get token end column number.
    getEndLine () → int
    returns int | get token end line number.
    getBeginColumn () → int
    returns int | get token beginning column number.
    getBeginLine () → int
    returns int | get token beginning line number.
    backup (amount)
    Backup a number of characters.
    int amount
    ReInit (dstream, startline, startcolumn, buffersize)
    Reinitialise.
    Provider dstream
    int startline
    int startcolumn
    int buffersize
    ReInit (dstream, startline, startcolumn)
    Reinitialise.
    Provider dstream
    int startline
    int startcolumn
    ReInit (dstream)
    Reinitialise.
    Provider dstream
    GetImage () → String
    returns String | get token literal value.
    GetSuffix (len) → char
    int len
    returns char | get the suffix.
    Done ()
    Reset buffer when finished.
    adjustBeginLineColumn (newLine, newCol)
    Method to adjust line and column numbers for the start of a token.
    int newLine
    int newCol

    ASTNodeAccess

    implements: Serializable provides: ASTNodeAccessImpl, Expression,

    getASTNode () → SimpleNode
    returns SimpleNode
    setASTNode (node)
    SimpleNode node

    JSqlParser

    provides: CCJSqlParserManager,

    parse (statementReader) → Statement
    Reader statementReader
    returns Statement

    StatementListener

    provides:

    accept (statement)
    Statement statement

    parser.feature

    Feature

    [select, selectGroupBy, selectGroupByGroupingSets, selectHaving, selectInto, limit, limitNull, limitAll, limitOffset, offset, offsetParam, fetch, fetchFirst, fetchNext, join, joinOuterSimple, joinSimple, joinRight, joinNatural, joinFull, joinLeft, joinCross, joinOuter, joinSemi, joinInner, joinStraight, joinApply, joinWindow, joinUsingColumns, skip, first, top, optimizeFor, selectUnique, distinct, distinctOn, orderBy, orderByNullOrdering, selectForUpdate, selectForShare, selectForKeyShare, selectForNoKeyUpdate, selectForUpdateOfTable, selectForUpdateWait, selectForUpdateNoWait, selectForUpdateSkipLocked, insert, insertFromSelect, insertModifierPriority, insertModifierIgnore, insertUseSet, insertUseDuplicateKeyUpdate, insertReturningAll, insertReturningExpressionList, insertValues, values, tableStatement, update, updateFrom, updateJoins, updateUseSelect, updateOrderBy, updateLimit, updateReturning, delete, deleteJoin, deleteTables, deleteLimit, deleteOrderBy, deleteReturningExpressionList, upsert, merge, alterTable, alterSequence, alterView, refreshMaterializedView, refreshMaterializedWithDataView, refreshMaterializedWithNoDataView, alterViewReplace, alterIndex, analyze, truncate, execute, executeExec, executeCall, executeExecute, executeStatement, executeStatementImmediate, executeUsing, replace, drop, dropTable, dropIndex, dropView, dropSchema, dropSequence, dropTableIfExists, dropIndexIfExists, dropViewIfExists, dropSchemaIfExists, dropSequenceIfExists, createSchema, createView, createViewForce, createViewTemporary, createOrReplaceView, createViewMaterialized, createViewWithComment, createTable, createTableUnlogged, createTableCreateOptionStrings, createTableTableOptionStrings, createTableIfNotExists, createTableRowMovement, createTableFromSelect, createIndex, createSequence, createSynonym, createTrigger, commit, comment, commentOnTable, commentOnColumn, commentOnView, describe, desc, explain, show, showTables, showColumns, showIndex, use, grant, function, createFunction, createProcedure, functionalStatement, block, declare, set, reset, pivot, unpivot, pivotXml, setOperation, setOperationUnion, setOperationIntersect, setOperationExcept, setOperationMinus, withItem, withItemRecursive, lateralSubSelect, valuesList, tableFunction, jdbcParameter, jdbcNamedParameter, exprLike, exprSimilarTo, kSqlWindow, oracleOldJoinSyntax, oraclePriorPosition, oracleHint, oracleHierarchicalExpression, oracleOrderBySiblings, mySqlHintStraightJoin, mysqlSqlCacheFlag, mysqlCalcFoundRows, selectForXmlPath, allowSquareBracketQuotation, allowPostgresSpecificSyntax, allowComplexParsing, allowUnsupportedStatements, timeOut, allowBackslashEscapeCharacter]

    FeatureConfiguration

    extends: Object

    FeatureConfiguration ()
    setValue (feature, value) → FeatureConfiguration
    Feature feature
    Object value
    returns FeatureConfiguration | this
    getValue (feature) → Object
    Feature feature
    returns Object | the configured feature value - can be null
    getAsBoolean (f) → boolean
    Feature f
    returns boolean
    getAsLong (f) → Long
    Feature f
    returns Long
    getAsString (f) → String
    Feature f
    returns String

    FeatureSet

    provides: FeatureSetValidation, ModifyableFeatureSet,

    getFeatures () → Set
    returns Set
    contains (feature) → boolean
    Feature feature
    returns boolean | true if the feature is identical to one of the features contained in this set, false otherwise
    getFeaturesClone () → Set
    returns Set | a new HashSet with a copy of supported features
    getNotContained (features) → Set
    Collection features
    returns Set | all features within this feature set which are not contained in given set
    retainAll (features) → Set
    Collection features
    returns Set | all features within this feature set which are contained in given set too.

    ModifyableFeatureSet

    implements: FeatureSet provides: FeaturesAllowed,

    add (featureSets) → ModifyableFeatureSet
    FeatureSet featureSets
    returns ModifyableFeatureSet | this
    add (features) → ModifyableFeatureSet
    Feature features
    returns ModifyableFeatureSet | this
    add (features) → ModifyableFeatureSet
    Collection features
    returns ModifyableFeatureSet | this
    remove (featureSets) → ModifyableFeatureSet
    FeatureSet featureSets
    returns ModifyableFeatureSet | this
    remove (features) → ModifyableFeatureSet
    Feature features
    returns ModifyableFeatureSet | this
    remove (features) → ModifyableFeatureSet
    Collection features
    returns ModifyableFeatureSet | this
    unmodifyable () → FeatureSet
    makes the inner Feature-set unmodifiable
    returns FeatureSet | this

    schema

    Sequence.ParameterType

    [INCREMENT_BY, START_WITH, RESTART_WITH, MAXVALUE, NOMAXVALUE, MINVALUE, NOMINVALUE, CYCLE, NOCYCLE, CACHE, NOCACHE, ORDER, NOORDER, KEEP, NOKEEP, SESSION, GLOBAL]

    The available parameters to a sequence

    Column

    extends: ASTNodeAccessImpl implements: Expression, MultiPartName

    A column. It can have the table name it belongs to.
    Column ()
    Column (table, columnName)
    Table table
    String columnName
    Column (nameParts)
    List nameParts
    Column (columnName)
    String columnName
    getArrayConstructor () → ArrayConstructor
    setArrayConstructor (arrayConstructor) → Column
    ArrayConstructor arrayConstructor
    returns Column
    getTable () → Table
    Retrieve the information regarding the Table this Column does belong to, if any can be inferred.
    The inference is based only on local information, and not on the whole SQL command. For example, consider the following query:
    SELECT x FROM Foo
    Given the Column called x, this method would return null, and not the info about the table Foo. On the other hand, consider:
    SELECT t.x FROM Foo t
    Here, we will get a Table object for a table called t. But because the inference is local, such object will not know that t is just an alias for Foo.
    returns Table | an instance of net.sf.jsqlparser.schema.Table representing the table this column does belong to, if it can be inferred. Can be null.
    setTable (table)
    Table table
    getColumnName () → String
    returns String
    setColumnName (string)
    String string
    @Override
    getFullyQualifiedName () → String
    returns String
    getFullyQualifiedName (aliases) → String
    boolean aliases
    returns String
    @Deprecated
    getName (aliases) → String
    boolean aliases
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Override
    toString () → String
    returns String
    withTable (table) → Column
    Table table
    returns Column
    withColumnName (columnName) → Column
    String columnName
    returns Column
    withCommentText (commentText) → Column
    String commentText
    returns Column
    setCommentText (commentText)
    String commentText
    getCommentText () → String
    returns String

    Database

    extends: Object implements: MultiPartName

    Database (databaseName)
    String databaseName
    Database (server, databaseName)
    Server server
    String databaseName
    getServer () → Server
    returns Server
    setServer (server)
    Server server
    getDatabaseName () → String
    returns String
    setDatabaseName (databaseName)
    String databaseName
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    toString () → String
    returns String
    withServer (server) → Database
    Server server
    returns Database
    withDatabaseName (databaseName) → Database
    String databaseName
    returns Database

    Sequence

    extends: ASTNodeAccessImpl implements: MultiPartName

    Represents the database part for a SEQUENCE
    Sequence ()
    Sequence (partItems)
    List partItems
    setParameters (parameters)
    List parameters
    getParameters () → List
    returns List
    getDatabase () → Database
    returns Database
    setDatabase (database)
    Database database
    withDatabase (database) → Sequence
    Database database
    returns Sequence
    getSchemaName () → String
    returns String
    setSchemaName (string)
    String string
    withSchemaName (string) → Sequence
    String string
    returns Sequence
    getName () → String
    returns String
    setName (string)
    String string
    withName (string) → Sequence
    String string
    returns Sequence
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    toString () → String
    returns String
    withParameters (parameters) → Sequence
    List parameters
    returns Sequence
    addParameters (parameters) → Sequence
    Parameter parameters
    returns Sequence
    addParameters (parameters) → Sequence
    Collection parameters
    returns Sequence

    Sequence.Parameter

    extends: Object

    Represents a parameter when declaring a sequence
    Parameter (option)
    ParameterType option
    getValue () → Long
    returns Long
    setValue (value)
    Long value
    formatParameter () → String
    returns String
    withValue (value) → Parameter
    Long value
    returns Parameter

    Server

    extends: Object implements: MultiPartName

    Server (serverAndInstanceName)
    String serverAndInstanceName
    Server (serverName, instanceName)
    String serverName
    String instanceName
    getServerName () → String
    returns String
    setServerName (serverName)
    String serverName
    getInstanceName () → String
    returns String
    setInstanceName (instanceName)
    String instanceName
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    toString () → String
    returns String
    withServerName (serverName) → Server
    String serverName
    returns Server
    withInstanceName (instanceName) → Server
    String instanceName
    returns Server

    Synonym

    extends: ASTNodeAccessImpl implements: MultiPartName

    Synonym ()
    Synonym (partItems)
    List partItems
    getDatabase () → Database
    returns Database
    setDatabase (database)
    Database database
    withDatabase (database) → Synonym
    Database database
    returns Synonym
    getSchemaName () → String
    returns String
    setSchemaName (string)
    String string
    withSchemaName (string) → Synonym
    String string
    returns Synonym
    getName () → String
    returns String
    setName (string)
    String string
    withName (string) → Synonym
    String string
    returns Synonym
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    toString () → String
    returns String

    Table

    extends: ASTNodeAccessImpl implements: FromItem, MultiPartName

    A table. It can have an alias and the schema name it belongs to.
    Table ()
    Table (name)
    String name
    Table (schemaName, name)
    String schemaName
    String name
    Table (database, schemaName, name)
    Database database
    String schemaName
    String name
    Table (partItems)
    List partItems
    getDatabase () → Database
    returns Database
    withDatabase (database) → Table
    Database database
    returns Table
    setDatabase (database)
    Database database
    getSchemaName () → String
    returns String
    withSchemaName (schemaName) → Table
    String schemaName
    returns Table
    setSchemaName (schemaName)
    String schemaName
    getName () → String
    returns String
    getDBLinkName () → String
    returns String
    withName (name) → Table
    String name
    returns Table
    setName (name)
    String name
    @Override
    getAlias () → Alias
    returns Alias
    @Override
    setAlias (alias)
    Alias alias
    @Override
    getFullyQualifiedName () → String
    returns String
    @Override
    accept (fromItemVisitor)
    FromItemVisitor fromItemVisitor
    accept (intoTableVisitor)
    IntoTableVisitor intoTableVisitor
    @Override
    getPivot () → Pivot
    returns Pivot
    @Override
    setPivot (pivot)
    Pivot pivot
    @Override
    getUnPivot () → UnPivot
    returns UnPivot
    @Override
    setUnPivot (unpivot)
    UnPivot unpivot
    getIndexHint () → MySQLIndexHint
    withHint (hint) → Table
    returns Table
    setHint (hint)
    getSqlServerHints () → SQLServerHints
    setSqlServerHints (sqlServerHints)
    SQLServerHints sqlServerHints
    getSampleClause () → SampleClause
    returns SampleClause
    setSampleClause (sampleClause) → Table
    SampleClause sampleClause
    returns Table
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Override
    withUnPivot (unpivot) → Table
    UnPivot unpivot
    returns Table
    @Override
    withAlias (alias) → Table
    Alias alias
    returns Table
    @Override
    withPivot (pivot) → Table
    Pivot pivot
    returns Table
    withSqlServerHints (sqlServerHints) → Table
    SQLServerHints sqlServerHints
    returns Table
    getNameParts () → List
    returns List

    MultiPartName

    provides: Column, Database, Sequence, Server, Synonym, Table,

    getFullyQualifiedName () → String
    returns String

    statement

    DeclareType

    [TABLE, AS, TYPE]

    ExplainStatement.OptionType

    [ANALYZE, VERBOSE, COSTS, BUFFERS, FORMAT]

    PurgeObjectType

    [TABLE, INDEX, RECYCLEBIN, DBA_RECYCLEBIN, TABLESPACE]

    ReferentialAction.Action

    [CASCADE, RESTRICT, NO_ACTION, SET_DEFAULT, SET_NULL]

    ReferentialAction.Type

    [DELETE, UPDATE]

    Block

    extends: Object implements: Statement

    Block ()
    getStatements () → Statements
    returns Statements
    setStatements (statements)
    Statements statements
    hasSemicolonAfterEnd () → boolean
    returns boolean
    setSemicolonAfterEnd (hasSemicolonAfterEnd)
    boolean hasSemicolonAfterEnd
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    withStatements (statements) → Block
    Statements statements
    returns Block

    Commit

    extends: Object implements: Statement

    Commit ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String

    CreateFunctionalStatement

    extends: Object implements: Statement provides: CreateFunction, CreateProcedure

    A base for the declaration of function like statements
    String kind
    String kind
    List functionDeclarationParts
    boolean orReplace
    String kind
    List functionDeclarationParts
    setFunctionDeclarationParts (functionDeclarationParts)
    List functionDeclarationParts
    getFunctionDeclarationParts () → List
    returns List | the declaration parts after CREATE FUNCTION|PROCEDURE
    getKind () → String
    returns String | the kind of functional statement
    setOrReplace (orReplace)
    boolean orReplace
    formatDeclaration () → String
    returns String | a whitespace appended String with the declaration parts with some minimal formatting.
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withFunctionDeclarationParts (functionDeclarationParts) → CreateFunctionalStatement
    List functionDeclarationParts
    addFunctionDeclarationParts (functionDeclarationParts) → CreateFunctionalStatement
    String functionDeclarationParts
    addFunctionDeclarationParts (functionDeclarationParts) → CreateFunctionalStatement
    Collection functionDeclarationParts

    DeclareStatement

    extends: Object implements: Statement

    DeclareStatement ()
    setUserVariable (userVariable)
    UserVariable userVariable
    getUserVariable () → UserVariable
    returns UserVariable
    @Deprecated
    getType () → DeclareType
    returns DeclareType | the DeclareType
    getDeclareType () → DeclareType
    returns DeclareType | the DeclareType
    getTypeName () → String
    returns String
    setDeclareType (declareType)
    DeclareType declareType
    addType (colDataType, defaultExpr)
    ColDataType colDataType
    Expression defaultExpr
    addType (userVariable, colDataType, defaultExpr)
    UserVariable userVariable
    ColDataType colDataType
    Expression defaultExpr
    addTypeDefExprList (typeDefExpressions) → DeclareStatement
    TypeDefExpr typeDefExpressions
    addTypeDefExprList (typeDefExpressions) → DeclareStatement
    Collection typeDefExpressions
    withTypeDefExprList (typeDefExpressions) → DeclareStatement
    List typeDefExpressions
    setTypeDefExprList (expr)
    List expr
    getTypeDefExprList () → List
    returns List
    addColumnDefinition (colDef)
    setColumnDefinitions (columnDefinitions)
    List columnDefinitions
    getColumnDefinitions () → List
    returns List
    getTypeDefinitions () → List
    returns List
    setTypeName (typeName)
    String typeName
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withUserVariable (userVariable) → DeclareStatement
    UserVariable userVariable
    withTypeName (typeName) → DeclareStatement
    String typeName
    withDeclareType (declareType) → DeclareStatement
    DeclareType declareType
    withColumnDefinitions (columnDefinitions) → DeclareStatement
    List columnDefinitions
    addColumnDefinitions (statements) → DeclareStatement
    ColumnDefinition statements
    addColumnDefinitions (columnDefinitions) → DeclareStatement
    Collection columnDefinitions

    DeclareStatement.TypeDefExpr

    extends: Object implements: Serializable

    TypeDefExpr (colDataType, defaultExpr)
    ColDataType colDataType
    Expression defaultExpr
    TypeDefExpr (userVariable, colDataType, defaultExpr)
    UserVariable userVariable
    ColDataType colDataType
    Expression defaultExpr

    DescribeStatement

    extends: Object implements: Statement

    DescribeStatement ()
    DescribeStatement (table)
    Table table
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withTable (table) → DescribeStatement
    Table table
    getDescribeType () → String
    returns String
    setDescribeType (describeType) → DescribeStatement
    String describeType

    ExplainStatement

    extends: Object implements: Statement

    An EXPLAIN statement
    ExplainStatement ()
    ExplainStatement (select)
    Select select
    getTable () → Table
    returns Table
    setTable (table) → ExplainStatement
    Table table
    getStatement () → Select
    returns Select
    setStatement (select)
    Select select
    getOptions () → LinkedHashMap
    returns LinkedHashMap
    addOption (option)
    Option option
    getOption (optionType) → Option
    Returns the first option that matches this optionType
    OptionType optionType | optionType the option part to retrieve an Option for
    returns Option | an option of that part, or null. In case of duplicate options, the first found option will be returned.
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    ExplainStatement.Option

    extends: Object implements: Serializable

    Option (part)
    OptionType part
    getType () → OptionType
    returns OptionType
    getValue () → String
    returns String
    setValue (value)
    String value
    formatOption () → String
    returns String
    withValue (value) → Option
    String value
    returns Option

    IfElseStatement

    extends: Object implements: Statement

    IfElseStatement (condition, ifStatement)
    Expression condition
    Statement ifStatement
    getCondition () → Expression
    returns Expression
    getIfStatement () → Statement
    returns Statement
    setElseStatement (elseStatement)
    Statement elseStatement
    getElseStatement () → Statement
    returns Statement
    setUsingSemicolonForElseStatement (usingSemicolonForElseStatement)
    boolean usingSemicolonForElseStatement
    isUsingSemicolonForElseStatement () → boolean
    returns boolean
    setUsingSemicolonForIfStatement (usingSemicolonForIfStatement)
    boolean usingSemicolonForIfStatement
    isUsingSemicolonForIfStatement () → boolean
    returns boolean
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    OutputClause

    extends: Object implements: Serializable

    T-SQL Output Clause
    OutputClause (selectItemList, tableVariable, outputTable, columnList)
    List selectItemList
    UserVariable tableVariable
    Table outputTable
    List columnList
    getSelectItemList () → List
    returns List
    setSelectItemList (selectItemList)
    List selectItemList
    getTableVariable () → UserVariable
    returns UserVariable
    setTableVariable (tableVariable)
    UserVariable tableVariable
    getOutputTable () → Table
    returns Table
    setOutputTable (outputTable)
    Table outputTable
    getColumnList () → List
    returns List
    setColumnList (columnList)
    List columnList
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    PurgeStatement

    extends: Object implements: Statement

    PurgeStatement (table)
    Table table
    PurgeStatement (index)
    Index index
    PurgeStatement (purgeObjectType)
    PurgeObjectType purgeObjectType
    PurgeStatement (purgeObjectType, tableSpaceName, userName)
    PurgeObjectType purgeObjectType
    String tableSpaceName
    String userName
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @SuppressWarnings
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    getUserName () → String
    returns String
    setUserName (userName)
    String userName
    getPurgeObjectType () → PurgeObjectType
    returns PurgeObjectType
    getObject () → Object
    returns Object

    ReferentialAction

    extends: Object implements: Serializable

    ReferentialAction ()
    ReferentialAction (part, action)
    Type part
    Action action
    getType () → Type
    returns Type
    setType (part)
    Type part
    withType (part) → ReferentialAction
    Type part
    getAction () → Action
    returns Action
    setAction (action)
    Action action
    withAction (action) → ReferentialAction
    Action action
    @Override
    hashCode () → int
    returns int
    @Override
    toString () → String
    returns String
    @Override
    equals (obj) → boolean
    Object obj
    returns boolean

    ResetStatement

    extends: Object implements: Statement

    ResetStatement ()
    ResetStatement (name)
    String name
    add (name)
    String name
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    ReturningClause

    extends: ArrayList

    RETURNING clause according to a href= "https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DELETE.html#GUID-156845A5-B626-412B-9F95-8869B988ABD7" Part of UPDATE, INSERT, DELETE statements
    ReturningClause (keyword, selectItems, dataItems)
    Keyword keyword
    List selectItems
    List dataItems
    ReturningClause (keyword, selectItems, dataItems)
    String keyword
    List selectItems
    List dataItems
    ReturningClause (keyword, selectItems)
    Keyword keyword
    List selectItems
    ReturningClause (keyword, selectItems)
    String keyword
    List selectItems
    getKeyword () → Keyword
    returns Keyword
    setKeyword (keyword) → ReturningClause
    Keyword keyword
    getDataItems () → List
    returns List
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    RollbackStatement

    extends: Object implements: Statement

    RollbackStatement ()
    isUsingWorkKeyword () → boolean
    returns boolean
    withUsingWorkKeyword (usingWorkKeyword) → RollbackStatement
    boolean usingWorkKeyword
    setUsingWorkKeyword (usingWorkKeyword)
    boolean usingWorkKeyword
    isUsingSavepointKeyword () → boolean
    returns boolean
    withUsingSavepointKeyword (usingSavepointKeyword) → RollbackStatement
    boolean usingSavepointKeyword
    setUsingSavepointKeyword (usingSavepointKeyword)
    boolean usingSavepointKeyword
    getSavepointName () → String
    returns String
    withSavepointName (savepointName) → RollbackStatement
    String savepointName
    setSavepointName (savepointName)
    String savepointName
    getForceDistributedTransactionIdentifier () → String
    returns String
    withForceDistributedTransactionIdentifier (forceDistributedTransactionIdentifier) → RollbackStatement
    String forceDistributedTransactionIdentifier
    setForceDistributedTransactionIdentifier (forceDistributedTransactionIdentifier)
    String forceDistributedTransactionIdentifier
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    SavepointStatement

    extends: Object implements: Statement

    SavepointStatement (savepointName)
    String savepointName
    getSavepointName () → String
    returns String
    setSavepointName (savepointName)
    String savepointName
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    SetStatement

    extends: Object implements: Statement

    SetStatement ()
    SetStatement (name, value)
    Object name
    add (name, value, useEqual)
    Object name
    boolean useEqual
    remove (idx)
    int idx
    getCount () → int
    returns int
    isUseEqual (idx) → boolean
    int idx
    returns boolean
    isUseEqual () → boolean
    returns boolean
    withUseEqual (idx, useEqual) → SetStatement
    int idx
    boolean useEqual
    returns SetStatement
    setUseEqual (idx, useEqual) → SetStatement
    int idx
    boolean useEqual
    returns SetStatement
    withUseEqual (useEqual) → SetStatement
    boolean useEqual
    returns SetStatement
    setUseEqual (useEqual) → SetStatement
    boolean useEqual
    returns SetStatement
    getName () → Object
    returns Object
    getName (idx) → Object
    int idx
    returns Object
    setName (name)
    String name
    setName (idx, name)
    int idx
    String name
    getExpressions (idx) → List
    int idx
    returns List
    getExpressions () → List
    returns List
    setExpressions (idx, expressions)
    int idx
    ExpressionList expressions
    setExpressions (expressions)
    ExpressionList expressions
    @Override
    toString () → String
    returns String
    getKeyValuePairs () → List
    returns List
    addKeyValuePairs (keyValuePairs)
    Collection keyValuePairs
    addKeyValuePairs (keyValuePairs)
    NameExpr keyValuePairs
    clear ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getEffectParameter () → String
    returns String
    setEffectParameter (effectParameter)
    String effectParameter
    withEffectParameter (effectParameter) → SetStatement
    String effectParameter
    returns SetStatement

    ShowColumnsStatement

    extends: Object implements: Statement

    ShowColumnsStatement ()
    ShowColumnsStatement (tableName)
    String tableName
    getTableName () → String
    returns String
    setTableName (tableName)
    String tableName
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withTableName (tableName) → ShowColumnsStatement
    String tableName

    ShowStatement

    extends: Object implements: Statement

    ShowStatement ()
    ShowStatement (name)
    String name
    getName () → String
    returns String
    setName (name)
    String name
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withName (name) → ShowStatement
    String name

    StatementVisitorAdapter

    extends: Object implements: StatementVisitor

    StatementVisitorAdapter ()
    @Override
    visit (comment)
    Comment comment
    @Override
    visit (commit)
    Commit commit
    @Override
    visit (select)
    Select select
    @Override
    visit (delete)
    Delete delete
    @Override
    visit (update)
    Update update
    @Override
    visit (insert)
    Insert insert
    @Override
    visit (drop)
    Drop drop
    @Override
    visit (truncate)
    Truncate truncate
    @Override
    visit (createIndex)
    CreateIndex createIndex
    @Override
    visit (aThis)
    @Override
    visit (createTable)
    CreateTable createTable
    @Override
    visit (createView)
    CreateView createView
    @Override
    visit (alter)
    Alter alter
    @Override
    visit (stmts)
    @Override
    visit (execute)
    Execute execute
    @Override
    visit (set)
    @Override
    visit (reset)
    @Override
    visit (merge)
    Merge merge
    @Override
    visit (alterView)
    AlterView alterView
    @Override
    visit (upsert)
    Upsert upsert
    @Override
    visit (use)
    @Override
    visit (block)
    Block block
    @Override
    visit (describe)
    @Override
    visit (aThis)
    @Override
    visit (aThis)
    @Override
    visit (set)
    @Override
    visit (set)
    @Override
    visit (showTables)
    @Override
    visit (aThis)
    @Override
    visit (grant)
    Grant grant
    @Override
    visit (createSequence)
    CreateSequence createSequence
    @Override
    visit (alterSequence)
    AlterSequence alterSequence
    @Override
    visit (createFunctionalStatement)
    CreateFunctionalStatement createFunctionalStatement
    @Override
    visit (createSynonym)
    CreateSynonym createSynonym
    @Override
    visit (analyze)
    Analyze analyze
    @Override
    visit (savepointStatement)
    SavepointStatement savepointStatement
    @Override
    visit (rollbackStatement)
    RollbackStatement rollbackStatement
    @Override
    visit (alterSession)
    AlterSession alterSession
    @Override
    visit (ifElseStatement)
    IfElseStatement ifElseStatement
    @Override
    visit (renameTableStatement)
    RenameTableStatement renameTableStatement
    @Override
    visit (purgeStatement)
    PurgeStatement purgeStatement
    @Override
    visit (alterSystemStatement)
    AlterSystemStatement alterSystemStatement
    @Override
    visit (unsupportedStatement)
    UnsupportedStatement unsupportedStatement
    @Override
    visit (materializedView)

    Statements

    extends: ArrayList implements: Serializable

    Statements ()
    @Deprecated
    getStatements () → List
    returns List
    @Deprecated
    setStatements (statements)
    List statements
    accept (statementVisitor)
    StatementVisitor statementVisitor
    get (part, index) → E
    Class part
    int index
    returns E
    @Override
    toString () → String
    returns String

    UnsupportedStatement

    extends: Object implements: Statement

    UnsupportedStatement (declarations)
    List declarations
    UnsupportedStatement (upfront, declarations)
    String upfront
    List declarations
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @SuppressWarnings
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    isEmpty () → boolean
    returns boolean

    UseStatement

    extends: Object implements: Statement

    UseStatement ()
    UseStatement (name)
    String name
    UseStatement (name, hasSchemaKeyword)
    String name
    boolean hasSchemaKeyword
    getName () → String
    returns String
    setName (name)
    String name
    hasSchemaKeyword () → boolean
    returns boolean
    setSchemaKeyword (schemaKeyword)
    boolean schemaKeyword
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withName (name) → UseStatement
    String name
    returns UseStatement

    Statement

    implements: Model provides: Alter, AlterSequence, AlterSession, AlterSystemStatement, AlterView, Analyze, Block, Comment, Commit, CreateFunctionalStatement, CreateIndex, CreateSchema, CreateSequence, CreateSynonym, CreateTable, CreateView, DeclareStatement, Delete, DescribeStatement, Drop, Execute, ExplainStatement, Grant, IfElseStatement, Insert, Merge, PurgeStatement, RefreshMaterializedViewStatement, RenameTableStatement, ResetStatement, RollbackStatement, SavepointStatement, Select, SetStatement, ShowColumnsStatement, ShowIndexStatement, ShowStatement, ShowTablesStatement, Truncate, UnsupportedStatement, Update, Upsert, UseStatement,

    accept (statementVisitor)
    StatementVisitor statementVisitor

    StatementVisitor

    provides: StatementDeParser, StatementValidator, StatementVisitorAdapter, TablesNamesFinder,

    visit (analyze)
    Analyze analyze
    visit (savepointStatement)
    SavepointStatement savepointStatement
    visit (rollbackStatement)
    RollbackStatement rollbackStatement
    visit (comment)
    Comment comment
    visit (commit)
    Commit commit
    visit (delete)
    Delete delete
    visit (update)
    Update update
    visit (insert)
    Insert insert
    visit (drop)
    Drop drop
    visit (truncate)
    Truncate truncate
    visit (createIndex)
    CreateIndex createIndex
    visit (aThis)
    visit (createTable)
    CreateTable createTable
    visit (createView)
    CreateView createView
    visit (alterView)
    AlterView alterView
    visit (materializedView)
    visit (alter)
    Alter alter
    visit (stmts)
    visit (execute)
    Execute execute
    visit (set)
    visit (reset)
    visit (set)
    visit (showIndex)
    visit (showTables)
    visit (merge)
    Merge merge
    visit (select)
    Select select
    visit (upsert)
    Upsert upsert
    visit (use)
    visit (block)
    Block block
    visit (describe)
    visit (aThis)
    visit (aThis)
    visit (aThis)
    visit (grant)
    Grant grant
    visit (createSequence)
    CreateSequence createSequence
    visit (alterSequence)
    AlterSequence alterSequence
    visit (createFunctionalStatement)
    CreateFunctionalStatement createFunctionalStatement
    visit (createSynonym)
    CreateSynonym createSynonym
    visit (alterSession)
    AlterSession alterSession
    visit (aThis)
    visit (renameTableStatement)
    RenameTableStatement renameTableStatement
    visit (purgeStatement)
    PurgeStatement purgeStatement
    visit (alterSystemStatement)
    AlterSystemStatement alterSystemStatement
    visit (unsupportedStatement)
    UnsupportedStatement unsupportedStatement

    statement.alter

    AlterOperation

    [ADD, ALTER, DROP, DROP_PRIMARY_KEY, DROP_UNIQUE, DROP_FOREIGN_KEY, MODIFY, CHANGE, ALGORITHM, RENAME, RENAME_TABLE, RENAME_INDEX, RENAME_KEY, RENAME_CONSTRAINT, COMMENT, COMMENT_WITH_EQUAL_SIGN, UNSPECIFIC, TRUNCATE_PARTITION]

    AlterSessionOperation

    [ADVISE_COMMIT, ADVISE_ROLLBACK, ADVISE_NOTHING, CLOSE_DATABASE_LINK, ENABLE_COMMIT_IN_PROCEDURE, DISABLE_COMMIT_IN_PROCEDURE, ENABLE_GUARD, DISABLE_GUARD, ENABLE_PARALLEL_DML, DISABLE_PARALLEL_DML, FORCE_PARALLEL_DML, ENABLE_PARALLEL_DDL, DISABLE_PARALLEL_DDL, FORCE_PARALLEL_DDL, ENABLE_PARALLEL_QUERY, DISABLE_PARALLEL_QUERY, FORCE_PARALLEL_QUERY, ENABLE_RESUMABLE, DISABLE_RESUMABLE, SET]

    AlterSystemOperation

    [ARCHIVE_LOG, CHECKPOINT, CHECK_DATAFILES, DUMP_ACTIVE_SESSION_HISTORY, ENABLE_DISTRIBUTED_RECOVERY, DISABLE_DISTRIBUTED_RECOVERY, ENABLE_RESTRICTED_SESSION, DISABLE_RESTRICTED_SESSION, FLUSH, DISCONNECT_SESSION, KILL_SESSION, SWITCH, SUSPEND, RESUME, QUIESCE, UNQUIESCE, SHUTDOWN, REGISTER, SET, RESET]

    Alter

    extends: Object implements: Statement

    Alter ()
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    isUseOnly () → boolean
    returns boolean
    setUseOnly (useOnly)
    boolean useOnly
    isUseTableIfExists () → boolean
    returns boolean
    setUseTableIfExists (useTableIfExists)
    boolean useTableIfExists
    withUseTableIfExists (useTableIfExists) → Alter
    boolean useTableIfExists
    returns Alter
    addAlterExpression (alterExpression)
    AlterExpression alterExpression
    getAlterExpressions () → List
    returns List
    setAlterExpressions (alterExpressions)
    List alterExpressions
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withTable (table) → Alter
    Table table
    returns Alter
    withUseOnly (useOnly) → Alter
    boolean useOnly
    returns Alter
    withAlterExpressions (alterExpressions) → Alter
    List alterExpressions
    returns Alter
    addAlterExpressions (alterExpressions) → Alter
    AlterExpression alterExpressions
    returns Alter
    addAlterExpressions (alterExpressions) → Alter
    Collection alterExpressions
    returns Alter

    AlterExpression

    extends: Object implements: Serializable

    AlterExpression ()
    getOldIndex () → Index
    returns Index
    setOldIndex (oldIndex)
    Index oldIndex
    hasColumn () → boolean
    returns boolean
    useBrackets () → boolean
    returns boolean
    useBrackets (useBrackets)
    boolean useBrackets
    hasColumn (hasColumn)
    boolean hasColumn
    getFkSourceSchema () → String
    returns String
    setFkSourceSchema (fkSourceSchema)
    String fkSourceSchema
    getCommentText () → String
    returns String
    setCommentText (commentText)
    String commentText
    getOperation () → AlterOperation
    returns AlterOperation
    setOperation (operation)
    AlterOperation operation
    getOptionalSpecifier () → String
    returns String
    setOptionalSpecifier (optionalSpecifier)
    String optionalSpecifier
    setReferentialAction (part, action)
    Type part
    Action action
    withReferentialAction (part, action) → AlterExpression
    Type part
    Action action
    removeReferentialAction (part)
    Type part
    getReferentialAction (part) → ReferentialAction
    Type part
    @Deprecated
    isOnDeleteCascade () → boolean
    returns boolean |
    @Deprecated
    setOnDeleteCascade (onDeleteCascade)
    boolean onDeleteCascade
    @Deprecated
    isOnDeleteRestrict () → boolean
    returns boolean |
    @Deprecated
    setOnDeleteRestrict (onDeleteRestrict)
    boolean onDeleteRestrict
    @Deprecated
    isOnDeleteSetNull () → boolean
    returns boolean |
    @Deprecated
    setOnDeleteSetNull (onDeleteSetNull)
    boolean onDeleteSetNull
    getFkColumns () → List
    returns List
    setFkColumns (fkColumns)
    List fkColumns
    getFkSourceTable () → String
    returns String
    setFkSourceTable (fkSourceTable)
    String fkSourceTable
    getColDataTypeList () → List
    returns List
    addColDataType (columnName, colDataType)
    String columnName
    ColDataType colDataType
    addColDataType (columnDataType)
    ColumnDataType columnDataType
    addColDropNotNull (columnDropNotNull)
    ColumnDropNotNull columnDropNotNull
    addColDropDefault (columnDropDefault)
    ColumnDropDefault columnDropDefault
    getFkSourceColumns () → List
    returns List
    setFkSourceColumns (fkSourceColumns)
    List fkSourceColumns
    getNewTableName () → String
    returns String
    setNewTableName (newTableName)
    String newTableName
    getColumnName () → String
    returns String
    setColumnName (columnName)
    String columnName
    @Deprecated
    getColOldName () → String
    returns String
    @Deprecated
    setColOldName (columnOldName)
    String columnOldName
    getColumnOldName () → String
    returns String
    setColumnOldName (columnOldName)
    String columnOldName
    getConstraintName () → String
    returns String
    setConstraintName (constraintName)
    String constraintName
    isUsingIfExists () → boolean
    returns boolean
    setUsingIfExists (usingIfExists)
    boolean usingIfExists
    getPkColumns () → List
    returns List
    setPkColumns (pkColumns)
    List pkColumns
    getUkColumns () → List
    returns List
    setUkColumns (ukColumns)
    List ukColumns
    getUkName () → String
    returns String
    setUkName (ukName)
    String ukName
    getIndex () → Index
    returns Index
    setIndex (index)
    Index index
    getConstraints () → List
    returns List
    setConstraints (constraints)
    List constraints
    getColumnDropNotNullList () → List
    returns List
    addParameters (params)
    String params
    getParameters () → List
    returns List
    getUseEqual () → boolean
    returns boolean
    setUseEqual (useEqual)
    boolean useEqual
    getUk () → boolean
    returns boolean
    setUk (uk)
    boolean uk
    getTruncatePartitionName () → String
    returns String
    setTruncatePartitionName (truncatePartitionName)
    String truncatePartitionName
    withTruncatePartitionName (truncatePartitionName) → AlterExpression
    String truncatePartitionName
    isUseIfNotExists () → boolean
    returns boolean
    setUseIfNotExists (useIfNotExists)
    boolean useIfNotExists
    withUserIfNotExists (userIfNotExists) → AlterExpression
    boolean userIfNotExists
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withOperation (operation) → AlterExpression
    AlterOperation operation
    withOptionalSpecifier (optionalSpecifier) → AlterExpression
    String optionalSpecifier
    withColumnName (columnName) → AlterExpression
    String columnName
    withPkColumns (pkColumns) → AlterExpression
    List pkColumns
    withUkColumns (ukColumns) → AlterExpression
    List ukColumns
    withUkName (ukName) → AlterExpression
    String ukName
    withIndex (index) → AlterExpression
    Index index
    withConstraintName (constraintName) → AlterExpression
    String constraintName
    withUsingIfExists (usingIfExists) → AlterExpression
    boolean usingIfExists
    withOnDeleteRestrict (onDeleteRestrict) → AlterExpression
    boolean onDeleteRestrict
    withOnDeleteSetNull (onDeleteSetNull) → AlterExpression
    boolean onDeleteSetNull
    withOnDeleteCascade (onDeleteCascade) → AlterExpression
    boolean onDeleteCascade
    withFkColumns (fkColumns) → AlterExpression
    List fkColumns
    withFkSourceSchema (fkSourceSchema) → AlterExpression
    String fkSourceSchema
    withFkSourceTable (fkSourceTable) → AlterExpression
    String fkSourceTable
    withFkSourceColumns (fkSourceColumns) → AlterExpression
    List fkSourceColumns
    withUk (uk) → AlterExpression
    boolean uk
    withUseEqual (useEqual) → AlterExpression
    boolean useEqual
    withConstraints (constraints) → AlterExpression
    List constraints
    withCommentText (commentText) → AlterExpression
    String commentText
    withColumnOldName (columnOldName) → AlterExpression
    String columnOldName
    addPkColumns (pkColumns) → AlterExpression
    String pkColumns
    addPkColumns (pkColumns) → AlterExpression
    Collection pkColumns
    addUkColumns (ukColumns) → AlterExpression
    String ukColumns
    addUkColumns (ukColumns) → AlterExpression
    Collection ukColumns
    addFkColumns (fkColumns) → AlterExpression
    String fkColumns
    addFkColumns (fkColumns) → AlterExpression
    Collection fkColumns
    addFkSourceColumns (fkSourceColumns) → AlterExpression
    String fkSourceColumns
    addFkSourceColumns (fkSourceColumns) → AlterExpression
    Collection fkSourceColumns
    addConstraints (constraints) → AlterExpression
    ConstraintState constraints
    addConstraints (constraints) → AlterExpression
    Collection constraints

    AlterExpression.ColumnDataType

    extends: ColumnDefinition

    ColumnDataType (withType)
    boolean withType
    ColumnDataType (columnName, withType, colDataType, columnSpecs)
    String columnName
    boolean withType
    ColDataType colDataType
    List columnSpecs
    @Override
    toString () → String
    returns String
    @Override
    withColDataType (colDataType) → ColumnDataType
    ColDataType colDataType
    @Override
    withColumnName (columnName) → ColumnDataType
    String columnName
    @Override
    addColumnSpecs (columnSpecs) → ColumnDataType
    String columnSpecs
    @Override
    addColumnSpecs (columnSpecs) → ColumnDataType
    Collection columnSpecs
    @Override
    withColumnSpecs (columnSpecs) → ColumnDataType
    List columnSpecs

    AlterExpression.ColumnDropDefault

    extends: Object implements: Serializable

    ColumnDropDefault (columnName)
    String columnName
    getColumnName () → String
    returns String
    @Override
    toString () → String
    returns String

    AlterExpression.ColumnDropNotNull

    extends: Object implements: Serializable

    ColumnDropNotNull (columnName)
    String columnName
    ColumnDropNotNull (columnName, withNot)
    String columnName
    boolean withNot
    getColumnName () → String
    returns String
    isWithNot () → boolean
    returns boolean
    @Override
    toString () → String
    returns String

    AlterSession

    extends: Object implements: Statement

    AlterSession (operation, parameters)
    AlterSessionOperation operation
    List parameters
    getOperation () → AlterSessionOperation
    returns AlterSessionOperation
    setOperation (operation)
    AlterSessionOperation operation
    getParameters () → List
    returns List
    setParameters (parameters)
    List parameters
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    AlterSystemStatement

    extends: Object implements: Statement

    AlterSystemStatement (operation, parameters)
    AlterSystemOperation operation
    List parameters
    getOperation () → AlterSystemOperation
    returns AlterSystemOperation
    getParameters () → List
    returns List
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    DeferrableConstraint

    extends: Object implements: ConstraintState

    DeferrableConstraint ()
    DeferrableConstraint (not)
    boolean not
    isNot () → boolean
    returns boolean
    setNot (not)
    boolean not
    @Override
    toString () → String
    returns String
    withNot (not) → DeferrableConstraint
    boolean not

    EnableConstraint

    extends: Object implements: ConstraintState

    EnableConstraint ()
    EnableConstraint (disable)
    boolean disable
    isDisable () → boolean
    returns boolean
    setDisable (disable)
    boolean disable
    @Override
    toString () → String
    returns String
    withDisable (disable) → EnableConstraint
    boolean disable

    RenameTableStatement

    extends: Object implements: Statement

    RenameTableStatement (oldName, newName)
    Table oldName
    Table newName
    RenameTableStatement (oldName, newName, usingTableKeyword, usingIfExistsKeyword, waitDirective)
    Table oldName
    Table newName
    boolean usingTableKeyword
    boolean usingIfExistsKeyword
    String waitDirective
    addTableNames (oldName, newName)
    Table oldName
    Table newName
    isUsingTableKeyword () → boolean
    returns boolean
    setUsingTableKeyword (usingTableKeyword)
    boolean usingTableKeyword
    withUsingTableKeyword (usingTableKeyword) → RenameTableStatement
    boolean usingTableKeyword
    isUsingIfExistsKeyword () → boolean
    returns boolean
    setUsingIfExistsKeyword (usingIfExistsKeyword)
    boolean usingIfExistsKeyword
    withUsingIfExistsKeyword (usingIfExistsKeyword) → RenameTableStatement
    boolean usingIfExistsKeyword
    getWaitDirective () → String
    returns String
    setWaitDirective (waitDirective)
    String waitDirective
    withWaitDirective (waitDirective) → RenameTableStatement
    String waitDirective
    getTableNamesSize () → int
    returns int
    isTableNamesEmpty () → boolean
    returns boolean
    getTableNames () → Set
    returns Set
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    ValidateConstraint

    extends: Object implements: ConstraintState

    ValidateConstraint ()
    ValidateConstraint (not)
    boolean not
    isNot () → boolean
    returns boolean
    setNot (not)
    boolean not
    @Override
    toString () → String
    returns String
    withNot (not) → ValidateConstraint
    boolean not

    ConstraintState

    provides: DeferrableConstraint, EnableConstraint, ValidateConstraint,

    statement.alter.sequence

    AlterSequence

    extends: Object implements: Statement

    An ALTER SEQUENCE statement
    AlterSequence ()
    setSequence (sequence)
    Sequence sequence
    getSequence () → Sequence
    returns Sequence
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withSequence (sequence) → AlterSequence
    Sequence sequence

    statement.analyze

    Analyze

    extends: Object implements: Statement

    Analyze ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    @Override
    toString () → String
    returns String
    withTable (table) → Analyze
    Table table
    returns Analyze

    statement.comment

    Comment

    extends: Object implements: Statement

    Comment ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getColumn () → Column
    returns Column
    setColumn (column)
    Column column
    getView () → Table
    returns Table
    setView (view)
    Table view
    getComment () → StringValue
    returns StringValue
    setComment (comment)
    StringValue comment
    @Override
    toString () → String
    returns String
    withTable (table) → Comment
    Table table
    returns Comment
    withColumn (column) → Comment
    Column column
    returns Comment
    withComment (comment) → Comment
    StringValue comment
    returns Comment

    statement.create.function

    CreateFunction

    extends: CreateFunctionalStatement

    A CREATE PROCEDURE statement
    CreateFunction ()
    CreateFunction (functionDeclarationParts)
    List functionDeclarationParts
    CreateFunction (orReplace, functionDeclarationParts)
    boolean orReplace
    List functionDeclarationParts
    @Override
    withFunctionDeclarationParts (functionDeclarationParts) → CreateFunction
    List functionDeclarationParts
    @Override
    addFunctionDeclarationParts (functionDeclarationParts) → CreateFunction
    String functionDeclarationParts
    @Override
    addFunctionDeclarationParts (functionDeclarationParts) → CreateFunction
    Collection functionDeclarationParts

    statement.create.index

    CreateIndex

    extends: Object implements: Statement

    CreateIndex ()
    isIndexTypeBeforeOn () → boolean
    returns boolean
    setIndexTypeBeforeOn (indexTypeBeforeOn)
    boolean indexTypeBeforeOn
    isUsingIfNotExists () → boolean
    returns boolean
    setUsingIfNotExists (usingIfNotExists) → CreateIndex
    boolean usingIfNotExists
    returns CreateIndex
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getIndex () → Index
    returns Index
    setIndex (index)
    Index index
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getTailParameters () → List
    returns List
    setTailParameters (tailParameters)
    List tailParameters
    @Override
    toString () → String
    returns String
    withTable (table) → CreateIndex
    Table table
    returns CreateIndex
    withIndex (index) → CreateIndex
    Index index
    returns CreateIndex
    withTailParameters (tailParameters) → CreateIndex
    List tailParameters
    returns CreateIndex

    statement.create.procedure

    CreateProcedure

    extends: CreateFunctionalStatement

    A CREATE PROCEDURE statement
    CreateProcedure ()
    CreateProcedure (functionDeclarationParts)
    List functionDeclarationParts
    CreateProcedure (orReplace, functionDeclarationParts)
    boolean orReplace
    List functionDeclarationParts
    @Override
    withFunctionDeclarationParts (functionDeclarationParts) → CreateProcedure
    List functionDeclarationParts
    @Override
    addFunctionDeclarationParts (functionDeclarationParts) → CreateProcedure
    String functionDeclarationParts
    @Override
    addFunctionDeclarationParts (functionDeclarationParts) → CreateProcedure
    Collection functionDeclarationParts

    statement.create.schema

    CreateSchema

    extends: Object implements: Statement

    CreateSchema ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    addStatement (statement) → boolean
    Add a statement to the schema definition
    Statement statement | statement The statement to be added
    returns boolean | true if the operation was successful
    getAuthorization () → String
    The owner of the schema.
    returns String | Owner name
    getSchemaName () → String
    The name of the schema
    returns String | Schema name
    getSchemaPath () → List
    The path of the schema
    returns List | Schema path
    getStatements () → List
    The statements executed as part of the schema creation
    returns List | the statements
    setAuthorization (authorization)
    The owner of the schems.
    String authorization | authorization Owner name
    setSchemaName (schemaName)
    Set the name of the schema
    String schemaName | schemaName Schema name
    setSchemaPath (schemaPath)
    Set the path of the schema
    List schemaPath | schemaPath Schema path
    toString () → String
    returns String
    withAuthorization (authorization) → CreateSchema
    String authorization
    returns CreateSchema
    withSchemaName (schemaName) → CreateSchema
    String schemaName
    returns CreateSchema
    withSchemaPath (schemaPath) → CreateSchema
    List schemaPath
    returns CreateSchema
    addSchemaPath (schemaPath) → CreateSchema
    String schemaPath
    returns CreateSchema
    addSchemaPath (schemaPath) → CreateSchema
    Collection schemaPath
    returns CreateSchema

    statement.create.sequence

    CreateSequence

    extends: Object implements: Statement

    A CREATE SEQUENCE statement
    CreateSequence ()
    setSequence (sequence)
    Sequence sequence
    getSequence () → Sequence
    returns Sequence
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withSequence (sequence) → CreateSequence
    Sequence sequence

    statement.create.synonym

    CreateSynonym

    extends: Object implements: Statement

    CreateSynonym ()
    setSynonym (synonym)
    Synonym synonym
    getSynonym () → Synonym
    returns Synonym
    isOrReplace () → boolean
    returns boolean
    setOrReplace (orReplace)
    boolean orReplace
    isPublicSynonym () → boolean
    returns boolean
    setPublicSynonym (publicSynonym)
    boolean publicSynonym
    setForList (forList)
    List forList
    getForList () → List
    returns List
    getFor () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withSynonym (synonym) → CreateSynonym
    Synonym synonym

    statement.create.table

    RowMovementMode

    [ENABLE, DISABLE]

    CheckConstraint

    extends: NamedConstraint

    CheckConstraint ()
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    withTable (table) → CheckConstraint
    Table table
    withExpression (expression) → CheckConstraint
    Expression expression
    getExpression (part) → E
    Class part
    returns E
    @Override
    withType (part) → CheckConstraint
    String part
    @Override
    withUsing (using) → CheckConstraint
    String using
    @Override
    withName (name) → CheckConstraint
    List name
    @Override
    withName (name) → CheckConstraint
    String name
    @Override
    withColumnsNames (list) → CheckConstraint
    List list
    @Override
    withColumns (columns) → CheckConstraint
    List columns
    @Override
    addColumns (functionDeclarationParts) → CheckConstraint
    ColumnParams functionDeclarationParts
    @Override
    addColumns (functionDeclarationParts) → CheckConstraint
    Collection functionDeclarationParts
    @Override
    withIndexSpec (idxSpec) → CheckConstraint
    List idxSpec

    ColDataType

    extends: Object implements: Serializable

    ColDataType ()
    ColDataType (dataType)
    String dataType
    getArgumentsStringList () → List
    returns List
    getDataType () → String
    returns String
    setArgumentsStringList (list)
    List list
    setDataType (string)
    String string
    setDataType (list)
    List list
    getCharacterSet () → String
    returns String
    setCharacterSet (characterSet)
    String characterSet
    getArrayData () → List
    returns List
    setArrayData (arrayData)
    List arrayData
    @Override
    toString () → String
    returns String
    withDataType (dataType) → ColDataType
    String dataType
    returns ColDataType
    withArgumentsStringList (argumentsStringList) → ColDataType
    List argumentsStringList
    returns ColDataType
    withCharacterSet (characterSet) → ColDataType
    String characterSet
    returns ColDataType
    withArrayData (arrayData) → ColDataType
    List arrayData
    returns ColDataType
    addArgumentsStringList (argumentsStringList) → ColDataType
    String argumentsStringList
    returns ColDataType
    addArgumentsStringList (argumentsStringList) → ColDataType
    Collection argumentsStringList
    returns ColDataType
    addArrayData (arrayData) → ColDataType
    Integer arrayData
    returns ColDataType
    addArrayData (arrayData) → ColDataType
    Collection arrayData
    returns ColDataType

    ColumnDefinition

    extends: Object implements: Serializable provides: ColumnDataType

    Globally used definition class for columns.
    ColumnDefinition ()
    ColumnDefinition (columnName, colDataType)
    String columnName
    ColDataType colDataType
    ColumnDefinition (columnName, colDataType, columnSpecs)
    String columnName
    ColDataType colDataType
    List columnSpecs
    getColumnSpecs () → List
    returns List
    setColumnSpecs (list)
    List list
    getColDataType () → ColDataType
    returns ColDataType
    setColDataType (part)
    getColumnName () → String
    returns String
    setColumnName (string)
    String string
    @Override
    toString () → String
    returns String
    toStringDataTypeAndSpec () → String
    returns String
    withColumnName (columnName) → ColumnDefinition
    String columnName
    withColDataType (colDataType) → ColumnDefinition
    ColDataType colDataType
    withColumnSpecs (columnSpecs) → ColumnDefinition
    List columnSpecs
    addColumnSpecs (columnSpecs) → ColumnDefinition
    String columnSpecs
    addColumnSpecs (columnSpecs) → ColumnDefinition
    Collection columnSpecs

    CreateTable

    extends: Object implements: Statement

    CreateTable ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    isUnlogged () → boolean
    returns boolean
    setUnlogged (unlogged)
    boolean unlogged
    getColumnDefinitions () → List
    returns List | a list of `ColumnDefinition`s of this table.
    setColumnDefinitions (list)
    List list
    getColumns () → List
    returns List
    setColumns (columns)
    List columns
    getTableOptionsStrings () → List
    returns List | a list of options (as simple strings) of this table definition, as (“TYPE”, “=”, “MYISAM”)
    setTableOptionsStrings (tableOptionsStrings)
    List tableOptionsStrings
    getCreateOptionsStrings () → List
    returns List
    setCreateOptionsStrings (createOptionsStrings)
    List createOptionsStrings
    getIndexes () → List
    returns List | a list of `Index`es (for example “PRIMARY KEY”) of this table.
    Indexes created with column definitions (as in mycol INT PRIMARY KEY) are not inserted into this list.
    setIndexes (list)
    List list
    getSelect () → Select
    returns Select
    setSelect (select, parenthesis)
    Select select
    boolean parenthesis
    getLikeTable () → Table
    returns Table
    setLikeTable (likeTable, parenthesis)
    Table likeTable
    boolean parenthesis
    isIfNotExists () → boolean
    returns boolean
    setIfNotExists (ifNotExists)
    boolean ifNotExists
    isOrReplace () → boolean
    returns boolean
    setOrReplace (orReplace)
    boolean orReplace
    isSelectParenthesis () → boolean
    returns boolean
    setSelectParenthesis (selectParenthesis)
    boolean selectParenthesis
    getRowMovement () → RowMovement
    returns RowMovement
    setRowMovement (rowMovement)
    RowMovement rowMovement
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withTable (table) → CreateTable
    Table table
    returns CreateTable
    withUnlogged (unlogged) → CreateTable
    boolean unlogged
    returns CreateTable
    withCreateOptionsStrings (createOptionsStrings) → CreateTable
    List createOptionsStrings
    returns CreateTable
    withSelectParenthesis (selectParenthesis) → CreateTable
    boolean selectParenthesis
    returns CreateTable
    withIfNotExists (ifNotExists) → CreateTable
    boolean ifNotExists
    returns CreateTable
    withRowMovement (rowMovement) → CreateTable
    RowMovement rowMovement
    returns CreateTable
    withTableOptionsStrings (tableOptionsStrings) → CreateTable
    List tableOptionsStrings
    returns CreateTable
    withColumnDefinitions (columnDefinitions) → CreateTable
    List columnDefinitions
    returns CreateTable
    withColumns (columns) → CreateTable
    List columns
    returns CreateTable
    withIndexes (indexes) → CreateTable
    List indexes
    returns CreateTable
    addCreateOptionsStrings (createOptionsStrings) → CreateTable
    String createOptionsStrings
    returns CreateTable
    addCreateOptionsStrings (createOptionsStrings) → CreateTable
    Collection createOptionsStrings
    returns CreateTable
    addColumnDefinitions (columnDefinitions) → CreateTable
    ColumnDefinition columnDefinitions
    returns CreateTable
    addColumnDefinitions (columnDefinitions) → CreateTable
    Collection columnDefinitions
    returns CreateTable
    addColumns (columns) → CreateTable
    String columns
    returns CreateTable
    addColumns (columns) → CreateTable
    Collection columns
    returns CreateTable
    addIndexes (indexes) → CreateTable
    Index indexes
    returns CreateTable
    addIndexes (indexes) → CreateTable
    Collection indexes
    returns CreateTable
    getSpannerInterleaveIn () → SpannerInterleaveIn
    setSpannerInterleaveIn (spannerInterleaveIn)
    SpannerInterleaveIn spannerInterleaveIn
    withSpannerInterleaveIn (spannerInterleaveIn) → CreateTable
    SpannerInterleaveIn spannerInterleaveIn
    returns CreateTable

    ExcludeConstraint

    extends: Index

    ExcludeConstraint ()
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    withExpression (expression) → ExcludeConstraint
    Expression expression
    getExpression (part) → E
    Class part
    returns E
    @Override
    withName (name) → ExcludeConstraint
    List name
    @Override
    withType (part) → ExcludeConstraint
    String part
    @Override
    withUsing (using) → ExcludeConstraint
    String using
    @Override
    withColumnsNames (list) → ExcludeConstraint
    List list
    @Override
    withColumns (columns) → ExcludeConstraint
    List columns
    @Override
    addColumns (functionDeclarationParts) → ExcludeConstraint
    ColumnParams functionDeclarationParts
    @Override
    addColumns (functionDeclarationParts) → ExcludeConstraint
    Collection functionDeclarationParts
    @Override
    withIndexSpec (idxSpec) → ExcludeConstraint
    List idxSpec
    @Override
    withName (name) → ExcludeConstraint
    String name

    ForeignKeyIndex

    extends: NamedConstraint

    ForeignKeyIndex ()
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getReferencedColumnNames () → List
    returns List
    setReferencedColumnNames (referencedColumnNames)
    List referencedColumnNames
    setReferentialAction (part, action)
    Type part
    Action action
    withReferentialAction (part, action) → ForeignKeyIndex
    Type part
    Action action
    removeReferentialAction (part)
    Type part
    getReferentialAction (part) → ReferentialAction
    Type part
    @Deprecated
    getOnDeleteReferenceOption () → String
    returns String
    @Deprecated
    setOnDeleteReferenceOption (onDeleteReferenceOption)
    String onDeleteReferenceOption
    @Deprecated
    getOnUpdateReferenceOption () → String
    returns String
    @Deprecated
    setOnUpdateReferenceOption (onUpdateReferenceOption)
    String onUpdateReferenceOption
    @Override
    toString () → String
    returns String
    withTable (table) → ForeignKeyIndex
    Table table
    withReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex
    List referencedColumnNames
    withOnDeleteReferenceOption (onDeleteReferenceOption) → ForeignKeyIndex
    String onDeleteReferenceOption
    withOnUpdateReferenceOption (onUpdateReferenceOption) → ForeignKeyIndex
    String onUpdateReferenceOption
    addReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex
    String referencedColumnNames
    addReferencedColumnNames (referencedColumnNames) → ForeignKeyIndex
    Collection referencedColumnNames
    @Override
    withType (part) → ForeignKeyIndex
    String part
    @Override
    withUsing (using) → ForeignKeyIndex
    String using
    @Override
    withName (name) → ForeignKeyIndex
    List name
    @Override
    withName (name) → ForeignKeyIndex
    String name
    @Override
    withColumnsNames (list) → ForeignKeyIndex
    List list
    @Override
    withColumns (columns) → ForeignKeyIndex
    List columns
    @Override
    addColumns (functionDeclarationParts) → ForeignKeyIndex
    ColumnParams functionDeclarationParts
    @Override
    addColumns (functionDeclarationParts) → ForeignKeyIndex
    Collection functionDeclarationParts
    @Override
    withIndexSpec (idxSpec) → ForeignKeyIndex
    List idxSpec

    Index

    extends: Object implements: Serializable provides: ExcludeConstraint, NamedConstraint

    Index ()
    getColumnsNames () → List
    returns List
    @Deprecated
    getColumnWithParams () → List
    returns List
    @Deprecated
    setColumnNamesWithParams (list)
    List list
    getColumns () → List
    returns List
    setColumns (columns)
    List columns
    withColumns (columns) → Index
    List columns
    returns Index
    addColumns (functionDeclarationParts) → Index
    ColumnParams functionDeclarationParts
    returns Index
    addColumns (functionDeclarationParts) → Index
    Collection functionDeclarationParts
    returns Index
    getName () → String
    returns String
    getNameParts () → List
    returns List
    getType () → String
    returns String
    setUsing (using)
    In postgresql, the index part (Btree, GIST, etc.) is indicated with a USING clause. Please note that: Oracle - the part might be BITMAP, indicating a bitmap kind of index MySQL - the part might be FULLTEXT or SPATIAL
    String using
    setColumnsNames (list)
    List list
    withColumnsNames (list) → Index
    List list
    returns Index
    setName (name)
    String name
    setName (name)
    List name
    setType (string)
    String string
    getUsing () → String
    returns String
    getIndexSpec () → List
    returns List
    setIndexSpec (idxSpec)
    List idxSpec
    withIndexSpec (idxSpec) → Index
    List idxSpec
    returns Index
    @Override
    toString () → String
    returns String
    withType (part) → Index
    String part
    returns Index
    withUsing (using) → Index
    String using
    returns Index
    withName (name) → Index
    List name
    returns Index
    withName (name) → Index
    String name
    returns Index
    getCommentText () → String
    returns String
    setCommentText (commentText)
    String commentText

    Index.ColumnParams

    extends: Object implements: Serializable

    ColumnParams (columnName)
    String columnName
    ColumnParams (columnName, params)
    String columnName
    List params
    getColumnName () → String
    returns String
    getParams () → List
    returns List
    @Override
    toString () → String
    returns String

    NamedConstraint

    extends: Index provides: CheckConstraint, ForeignKeyIndex

    NamedConstraint ()
    @Override
    toString () → String
    returns String
    @Override
    withName (name) → NamedConstraint
    List name
    @Override
    withName (name) → NamedConstraint
    String name
    @Override
    withType (part) → NamedConstraint
    String part
    @Override
    withUsing (using) → NamedConstraint
    String using
    @Override
    withColumnsNames (list) → NamedConstraint
    List list
    @Override
    withColumns (columns) → NamedConstraint
    List columns
    @Override
    addColumns (functionDeclarationParts) → NamedConstraint
    ColumnParams functionDeclarationParts
    @Override
    addColumns (functionDeclarationParts) → NamedConstraint
    Collection functionDeclarationParts
    @Override
    withIndexSpec (idxSpec) → NamedConstraint
    List idxSpec

    RowMovement

    extends: Object implements: Serializable

    RowMovement ()
    getMode () → RowMovementMode
    returns RowMovementMode
    setMode (mode)
    RowMovementMode mode
    withMode (mode) → RowMovement
    RowMovementMode mode
    returns RowMovement

    statement.create.view

    AutoRefreshOption

    [NONE, YES, NO]

    ForceOption

    [NONE, FORCE, NO_FORCE]

    TemporaryOption

    [NONE, TEMP, TEMPORARY, VOLATILE]

    AlterView

    extends: Object implements: Statement

    AlterView ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getView () → Table
    returns Table
    setView (view)
    Table view
    getSelect () → Select
    returns Select
    setSelect (select)
    Select select
    getColumnNames () → List
    returns List
    setColumnNames (columnNames)
    List columnNames
    isUseReplace () → boolean
    returns boolean
    setUseReplace (useReplace)
    boolean useReplace
    @Override
    toString () → String
    returns String
    withView (view) → AlterView
    Table view
    returns AlterView
    withSelect (select) → AlterView
    Select select
    returns AlterView
    withUseReplace (useReplace) → AlterView
    boolean useReplace
    returns AlterView
    withColumnNames (columnNames) → AlterView
    List columnNames
    returns AlterView
    addColumnNames (columnNames) → AlterView
    String columnNames
    returns AlterView
    addColumnNames (columnNames) → AlterView
    Collection columnNames
    returns AlterView
    getSelectBody (part) → E
    Class part
    returns E

    CreateView

    extends: Object implements: Statement

    CreateView ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getView () → Table
    returns Table
    setView (view)
    Table view
    isOrReplace () → boolean
    returns boolean
    setOrReplace (orReplace)
    boolean orReplace | orReplace was “OR REPLACE” specified?
    getSelect () → Select
    returns Select
    setSelect (select)
    Select select
    getColumnNames () → ExpressionList
    setColumnNames (columnNames)
    ExpressionList columnNames
    isMaterialized () → boolean
    returns boolean
    setMaterialized (materialized)
    boolean materialized
    getForce () → ForceOption
    returns ForceOption
    setForce (force)
    ForceOption force
    isSecure () → boolean
    returns boolean
    setSecure (secure)
    boolean secure
    getTemporary () → TemporaryOption
    returns TemporaryOption
    setTemporary (temp)
    TemporaryOption temp
    getAutoRefresh () → AutoRefreshOption
    returns AutoRefreshOption
    setAutoRefresh (autoRefresh)
    AutoRefreshOption autoRefresh
    isWithReadOnly () → boolean
    returns boolean
    setWithReadOnly (withReadOnly)
    boolean withReadOnly
    isIfNotExists () → boolean
    returns boolean
    setIfNotExists (ifNotExists)
    boolean ifNotExists
    @Override
    toString () → String
    returns String
    withView (view) → CreateView
    Table view
    returns CreateView
    withSelect (select) → CreateView
    Select select
    returns CreateView
    withOrReplace (orReplace) → CreateView
    boolean orReplace
    returns CreateView
    withColumnNames (columnNames) → CreateView
    ExpressionList columnNames
    returns CreateView
    withMaterialized (materialized) → CreateView
    boolean materialized
    returns CreateView
    withForce (force) → CreateView
    ForceOption force
    returns CreateView
    withWithReadOnly (withReadOnly) → CreateView
    boolean withReadOnly
    returns CreateView
    getViewCommentOptions () → List
    returns List
    setViewCommentOptions (viewCommentOptions)
    List viewCommentOptions

    statement.delete

    DeleteModifierPriority

    [LOW_PRIORITY]

    Delete

    extends: Object implements: Statement

    Delete ()
    getOutputClause () → OutputClause
    returns OutputClause
    setOutputClause (outputClause)
    OutputClause outputClause
    getReturningClause () → ReturningClause
    setReturningClause (returningClause) → Delete
    ReturningClause returningClause
    returns Delete
    getWithItemsList () → List
    returns List
    setWithItemsList (withItemsList)
    List withItemsList
    withWithItemsList (withItemsList) → Delete
    List withItemsList
    returns Delete
    addWithItemsList (withItemsList) → Delete
    WithItem withItemsList
    returns Delete
    addWithItemsList (withItemsList) → Delete
    Collection withItemsList
    returns Delete
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    getWhere () → Expression
    returns Expression
    setTable (name)
    Table name
    setWhere (expression)
    Expression expression
    getOracleHint () → OracleHint
    returns OracleHint
    setOracleHint (oracleHint)
    OracleHint oracleHint
    getLimit () → Limit
    returns Limit
    setLimit (limit)
    Limit limit
    getTables () → List
    returns List
    setTables (tables)
    List tables
    getUsingList () → List
    returns List
    setUsingList (usingList)
    List usingList
    getJoins () → List
    returns List
    setJoins (joins)
    List joins
    isHasFrom () → boolean
    returns boolean
    setHasFrom (hasFrom)
    boolean hasFrom
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withTables (tables) → Delete
    List tables
    returns Delete
    withUsingList (usingList) → Delete
    List usingList
    returns Delete
    withJoins (joins) → Delete
    List joins
    returns Delete
    withLimit (limit) → Delete
    Limit limit
    returns Delete
    withOrderByElements (orderByElements) → Delete
    List orderByElements
    returns Delete
    withTable (table) → Delete
    Table table
    returns Delete
    withWhere (where) → Delete
    returns Delete
    withHasFrom (hasFrom) → Delete
    boolean hasFrom
    returns Delete
    withModifierPriority (modifierPriority) → Delete
    DeleteModifierPriority modifierPriority
    returns Delete
    withModifierIgnore (modifierIgnore) → Delete
    boolean modifierIgnore
    returns Delete
    withModifierQuick (modifierQuick) → Delete
    boolean modifierQuick
    returns Delete
    setModifierPriority (modifierPriority)
    DeleteModifierPriority modifierPriority
    getModifierPriority () → DeleteModifierPriority
    returns DeleteModifierPriority
    setModifierIgnore (modifierIgnore)
    boolean modifierIgnore
    setModifierQuick (modifierQuick)
    boolean modifierQuick
    isModifierIgnore () → boolean
    returns boolean
    isModifierQuick () → boolean
    returns boolean
    addTables (tables) → Delete
    Table tables
    returns Delete
    addTables (tables) → Delete
    Collection tables
    returns Delete
    addUsingList (usingList) → Delete
    Table usingList
    returns Delete
    addUsingList (usingList) → Delete
    Collection usingList
    returns Delete
    addJoins (joins) → Delete
    Join joins
    returns Delete
    addJoins (joins) → Delete
    Collection joins
    returns Delete
    addOrderByElements (orderByElements) → Delete
    OrderByElement orderByElements
    returns Delete
    addOrderByElements (orderByElements) → Delete
    Collection orderByElements
    returns Delete
    getWhere (part) → E
    Class part
    returns E

    statement.drop

    Drop

    extends: Object implements: Statement

    Drop ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getName () → Table
    returns Table
    getParameters () → List
    returns List
    getType () → String
    returns String
    setName (string)
    Table string
    setParameters (list)
    List list
    setType (string)
    String string
    isIfExists () → boolean
    returns boolean
    setIfExists (ifExists)
    boolean ifExists
    isUsingTemporary () → boolean
    returns boolean
    setUsingTemporary (useTemporary)
    boolean useTemporary
    withUsingTemporary (useTemporary) → Drop
    boolean useTemporary
    returns Drop
    isMaterialized () → boolean
    returns boolean
    setMaterialized (materialized)
    boolean materialized
    getTypeToParameters () → Map
    returns Map
    setTypeToParameters (typeToParameters)
    Map typeToParameters
    @Override
    toString () → String
    returns String
    formatFuncParams (params) → String
    List params
    returns String
    getParamsByType (part) → List
    String part
    returns List
    withIfExists (ifExists) → Drop
    boolean ifExists
    returns Drop
    withMaterialized (materialized) → Drop
    boolean materialized
    returns Drop
    withType (part) → Drop
    String part
    returns Drop
    withName (name) → Drop
    Table name
    returns Drop
    withParameters (parameters) → Drop
    List parameters
    returns Drop
    addParameters (parameters) → Drop
    String parameters
    returns Drop
    addParameters (parameters) → Drop
    Collection parameters
    returns Drop

    statement.execute

    Execute.ExecType

    [EXECUTE, EXEC, CALL]

    Execute

    extends: Object implements: Statement

    Execute ()
    getName () → String
    returns String
    setName (name)
    String name
    setName (names)
    List names
    getExprList () → ExpressionList
    setExprList (exprList)
    getExecType () → ExecType
    returns ExecType
    setExecType (execType)
    ExecType execType
    @Deprecated
    isParenthesis () → boolean
    returns boolean
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    toString () → String
    returns String
    withExecType (execType) → Execute
    ExecType execType
    returns Execute
    withName (name) → Execute
    String name
    returns Execute
    withExprList (exprList) → Execute
    returns Execute

    statement.grant

    Grant

    extends: Object implements: Statement

    Grant ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getRole () → String
    returns String
    setRole (role)
    String role
    getPrivileges () → List
    returns List
    setPrivileges (privileges)
    List privileges
    getObjectName () → String
    returns String
    getObjectNameParts () → List
    returns List
    setObjectName (objectName)
    String objectName
    setObjectName (objectName)
    List objectName
    getUsers () → List
    returns List
    setUsers (users)
    List users
    @Override
    toString () → String
    returns String
    withRole (role) → Grant
    String role
    returns Grant
    withPrivileges (privileges) → Grant
    List privileges
    returns Grant
    withObjectName (objectName) → Grant
    String objectName
    returns Grant
    withObjectName (objectName) → Grant
    List objectName
    returns Grant
    withUsers (users) → Grant
    List users
    returns Grant
    addPrivileges (privileges) → Grant
    String privileges
    returns Grant
    addPrivileges (privileges) → Grant
    Collection privileges
    returns Grant
    addUsers (users) → Grant
    String users
    returns Grant
    addUsers (users) → Grant
    Collection users
    returns Grant

    statement.insert

    ConflictActionType

    [DO_NOTHING, DO_UPDATE]

    InsertModifierPriority

    [LOW_PRIORITY, DELAYED, HIGH_PRIORITY, IGNORE]

    Insert

    extends: Object implements: Statement

    Insert ()
    getDuplicateUpdateSets () → List
    returns List
    getSetUpdateSets () → List
    returns List
    withDuplicateUpdateSets (duplicateUpdateSets) → Insert
    List duplicateUpdateSets
    returns Insert
    withSetUpdateSets (setUpdateSets) → Insert
    List setUpdateSets
    returns Insert
    getOutputClause () → OutputClause
    returns OutputClause
    setOutputClause (outputClause)
    OutputClause outputClause
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (name)
    Table name
    getOracleHint () → OracleHint
    returns OracleHint
    setOracleHint (oracleHint)
    OracleHint oracleHint
    getColumns () → ExpressionList
    setColumns (list)
    @Deprecated
    isUseValues () → boolean
    returns boolean
    getReturningClause () → ReturningClause
    setReturningClause (returningClause) → Insert
    ReturningClause returningClause
    returns Insert
    getSelect () → Select
    returns Select
    setSelect (select)
    Select select
    getValues () → Values
    returns Values
    getPlainSelect () → PlainSelect
    returns PlainSelect
    getSetOperationList () → SetOperationList
    @Deprecated
    isUseSelectBrackets () → boolean
    returns boolean
    @Deprecated
    isUseDuplicate () → boolean
    returns boolean
    getModifierPriority () → InsertModifierPriority
    returns InsertModifierPriority
    setModifierPriority (modifierPriority)
    InsertModifierPriority modifierPriority
    isModifierIgnore () → boolean
    returns boolean
    setModifierIgnore (modifierIgnore)
    boolean modifierIgnore
    @Deprecated
    isUseSet () → boolean
    returns boolean
    getWithItemsList () → List
    returns List
    setWithItemsList (withItemsList)
    List withItemsList
    getConflictTarget () → InsertConflictTarget
    setConflictTarget (conflictTarget)
    InsertConflictTarget conflictTarget
    withConflictTarget (conflictTarget) → Insert
    InsertConflictTarget conflictTarget
    returns Insert
    getConflictAction () → InsertConflictAction
    setConflictAction (conflictAction)
    InsertConflictAction conflictAction
    withConflictAction (conflictAction) → Insert
    InsertConflictAction conflictAction
    returns Insert
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withWithItemsList (withList) → Insert
    List withList
    returns Insert
    withSelect (select) → Insert
    Select select
    returns Insert
    withModifierPriority (modifierPriority) → Insert
    InsertModifierPriority modifierPriority
    returns Insert
    withModifierIgnore (modifierIgnore) → Insert
    boolean modifierIgnore
    returns Insert
    withTable (table) → Insert
    Table table
    returns Insert
    withColumns (columns) → Insert
    returns Insert
    addColumns (columns) → Insert
    Column columns
    returns Insert
    addColumns (columns) → Insert
    Collection columns
    returns Insert

    InsertConflictAction

    extends: Object implements: Serializable

    https://www.postgresql.org/docs/current/sql-insert.html conflict_action is one of: DO NOTHING DO UPDATE SET { column_name = { expression | DEFAULT } | ( column_name [, …] ) = [ ROW ] ( { expression | DEFAULT } [, …] ) | ( column_name [, …] ) = ( sub-SELECT ) } [, …] [ WHERE condition ]
    InsertConflictAction (conflictActionType)
    ConflictActionType conflictActionType
    getUpdateSets () → List
    returns List
    setUpdateSets (updateSets)
    List updateSets
    withUpdateSets (updateSets) → InsertConflictAction
    List updateSets
    getConflictActionType () → ConflictActionType
    returns ConflictActionType
    setConflictActionType (conflictActionType)
    ConflictActionType conflictActionType
    withConflictActionType (conflictActionType) → InsertConflictAction
    ConflictActionType conflictActionType
    addUpdateSet (column, expression) → InsertConflictAction
    Column column
    Expression expression
    addUpdateSet (updateSet) → InsertConflictAction
    UpdateSet updateSet
    withUpdateSets (updateSets) → InsertConflictAction
    Collection updateSets
    getWhereExpression () → Expression
    returns Expression
    setWhereExpression (whereExpression)
    Expression whereExpression
    withWhereExpression (whereExpression) → InsertConflictAction
    Expression whereExpression
    @SuppressWarnings
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    InsertConflictTarget

    extends: Object implements: Serializable

    https://www.postgresql.org/docs/current/sql-insert.html conflict_target can be one of: ( { index_column_name | ( index_expression ) } [ COLLATE collation ] [ opclass ] [, …] ) [ WHERE index_predicate ] ON CONSTRAINT constraint_name Currently, COLLATE is not supported yet.
    InsertConflictTarget (indexColumnName, indexExpression, whereExpression, constraintName)
    String indexColumnName
    Expression indexExpression
    Expression whereExpression
    String constraintName
    InsertConflictTarget (indexColumnName, indexExpression, whereExpression, constraintName)
    Collection indexColumnName
    Expression indexExpression
    Expression whereExpression
    String constraintName
    getIndexColumnNames () → List
    returns List
    @Deprecated
    getIndexColumnName () → String
    returns String
    getIndexColumnName (index) → String
    int index
    returns String
    addIndexColumnName (indexColumnName) → boolean
    String indexColumnName
    returns boolean
    withIndexColumnName (indexColumnName) → InsertConflictTarget
    String indexColumnName
    addAllIndexColumnNames (indexColumnName) → boolean
    Collection indexColumnName
    returns boolean
    getIndexExpression () → Expression
    returns Expression
    setIndexExpression (indexExpression)
    Expression indexExpression
    withIndexExpression (indexExpression) → InsertConflictTarget
    Expression indexExpression
    getWhereExpression () → Expression
    returns Expression
    setWhereExpression (whereExpression)
    Expression whereExpression
    withWhereExpression (whereExpression) → InsertConflictTarget
    Expression whereExpression
    getConstraintName () → String
    returns String
    setConstraintName (constraintName)
    String constraintName
    withConstraintName (constraintName) → InsertConflictTarget
    String constraintName
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    toString () → String
    returns String

    statement.merge

    Merge

    extends: Object implements: Statement

    Merge ()
    getWithItemsList () → List
    returns List
    setWithItemsList (withItemsList)
    List withItemsList
    withWithItemsList (withItemsList) → Merge
    List withItemsList
    returns Merge
    addWithItemsList (withItemsList) → Merge
    WithItem withItemsList
    returns Merge
    addWithItemsList (withItemsList) → Merge
    Collection withItemsList
    returns Merge
    getTable () → Table
    returns Table
    setTable (name)
    Table name
    getOracleHint () → OracleHint
    returns OracleHint
    setOracleHint (oracleHint)
    OracleHint oracleHint
    @Deprecated
    getUsingTable () → Table
    returns Table
    @Deprecated
    setUsingTable (usingTable)
    Table usingTable
    @Deprecated
    setUsingSelect (usingSelect)
    ParenthesedSelect usingSelect
    @Deprecated
    getUsingAlias () → Alias
    returns Alias
    @Deprecated
    setUsingAlias (usingAlias)
    Alias usingAlias
    getFromItem () → FromItem
    returns FromItem
    setFromItem (fromItem)
    FromItem fromItem
    withFromItem (fromItem) → Merge
    FromItem fromItem
    returns Merge
    getOnCondition () → Expression
    returns Expression
    setOnCondition (onCondition)
    Expression onCondition
    getOperations () → List
    returns List
    setOperations (operations)
    List operations
    getMergeInsert () → MergeInsert
    returns MergeInsert
    setMergeInsert (mergeInsert)
    MergeInsert mergeInsert
    getMergeUpdate () → MergeUpdate
    returns MergeUpdate
    setMergeUpdate (mergeUpdate)
    MergeUpdate mergeUpdate
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    isInsertFirst () → boolean
    returns boolean
    setInsertFirst (insertFirst)
    boolean insertFirst
    getOutputClause () → OutputClause
    returns OutputClause
    setOutputClause (outputClause) → Merge
    OutputClause outputClause
    returns Merge
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    @Deprecated
    withUsingTable (usingTable) → Merge
    Table usingTable
    returns Merge
    @Deprecated
    withUsingSelect (usingSelect) → Merge
    ParenthesedSelect usingSelect
    returns Merge
    @Deprecated
    withUsingAlias (usingAlias) → Merge
    Alias usingAlias
    returns Merge
    withOnCondition (onCondition) → Merge
    Expression onCondition
    returns Merge
    withMergeUpdate (mergeUpdate) → Merge
    MergeUpdate mergeUpdate
    returns Merge
    withInsertFirst (insertFirst) → Merge
    boolean insertFirst
    returns Merge
    withTable (table) → Merge
    Table table
    returns Merge
    withMergeInsert (mergeInsert) → Merge
    MergeInsert mergeInsert
    returns Merge
    getOnCondition (part) → E
    Class part
    returns E

    MergeDelete

    extends: Object implements: Serializable, MergeOperation

    MergeDelete ()
    getAndPredicate () → Expression
    returns Expression
    setAndPredicate (andPredicate)
    Expression andPredicate
    withAndPredicate (andPredicate) → MergeDelete
    Expression andPredicate
    returns MergeDelete
    @Override
    accept (mergeOperationVisitor)
    MergeOperationVisitor mergeOperationVisitor
    @Override
    toString () → String
    returns String

    MergeInsert

    extends: Object implements: Serializable, MergeOperation

    MergeInsert ()
    getAndPredicate () → Expression
    returns Expression
    setAndPredicate (andPredicate)
    Expression andPredicate
    getColumns () → ExpressionList
    setColumns (columns)
    getValues () → ExpressionList
    setValues (values)
    getWhereCondition () → Expression
    returns Expression
    setWhereCondition (whereCondition)
    Expression whereCondition
    @Override
    accept (mergeOperationVisitor)
    MergeOperationVisitor mergeOperationVisitor
    @Override
    toString () → String
    returns String
    withAndPredicate (andPredicate) → MergeInsert
    Expression andPredicate
    returns MergeInsert
    withColumns (columns) → MergeInsert
    returns MergeInsert
    withValues (values) → MergeInsert
    returns MergeInsert
    addColumns (columns) → MergeInsert
    Column columns
    returns MergeInsert
    addColumns (columns) → MergeInsert
    Collection columns
    returns MergeInsert
    addValues (values) → MergeInsert
    Expression values
    returns MergeInsert
    addValues (values) → MergeInsert
    Collection values
    returns MergeInsert
    withWhereCondition (whereCondition) → MergeInsert
    Expression whereCondition
    returns MergeInsert
    getAndPredicate (part) → E
    Class part
    returns E
    getWhereCondition (part) → E
    Class part
    returns E

    MergeOperationVisitorAdapter

    extends: Object implements: MergeOperationVisitor

    MergeOperationVisitorAdapter ()
    @Override
    visit (mergeDelete)
    MergeDelete mergeDelete
    @Override
    visit (mergeUpdate)
    MergeUpdate mergeUpdate
    @Override
    visit (mergeInsert)
    MergeInsert mergeInsert

    MergeUpdate

    extends: Object implements: Serializable, MergeOperation

    MergeUpdate ()
    MergeUpdate (updateSets)
    List updateSets
    getUpdateSets () → List
    returns List
    setUpdateSets (updateSets) → MergeUpdate
    List updateSets
    returns MergeUpdate
    getAndPredicate () → Expression
    returns Expression
    setAndPredicate (andPredicate)
    Expression andPredicate
    getWhereCondition () → Expression
    returns Expression
    setWhereCondition (whereCondition)
    Expression whereCondition
    getDeleteWhereCondition () → Expression
    returns Expression
    setDeleteWhereCondition (deleteWhereCondition)
    Expression deleteWhereCondition
    @Override
    accept (mergeOperationVisitor)
    MergeOperationVisitor mergeOperationVisitor
    @Override
    toString () → String
    returns String
    withAndPredicate (andPredicate) → MergeUpdate
    Expression andPredicate
    returns MergeUpdate
    withWhereCondition (whereCondition) → MergeUpdate
    Expression whereCondition
    returns MergeUpdate
    withDeleteWhereCondition (deleteWhereCondition) → MergeUpdate
    Expression deleteWhereCondition
    returns MergeUpdate
    getAndPredicate (part) → E
    Class part
    returns E
    getWhereCondition (part) → E
    Class part
    returns E
    getDeleteWhereCondition (part) → E
    Class part
    returns E

    MergeOperation

    provides: MergeDelete, MergeInsert, MergeUpdate,

    Marker interface to cover MergeDelete, MergeUpdate and MergeInsert
    accept (mergeOperationVisitor)
    MergeOperationVisitor mergeOperationVisitor

    MergeOperationVisitor

    provides: MergeDeParser, MergeOperationVisitorAdapter, MergeValidator,

    visit (mergeDelete)
    MergeDelete mergeDelete
    visit (mergeUpdate)
    MergeUpdate mergeUpdate
    visit (mergeInsert)
    MergeInsert mergeInsert

    statement.refresh

    RefreshMode

    [DEFAULT, WITH_DATA, WITH_NO_DATA]

    RefreshMaterializedViewStatement

    extends: Object implements: Statement

    REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] name [ WITH [ NO ] DATA ]
    RefreshMaterializedViewStatement ()
    RefreshMaterializedViewStatement (view, concurrently, refreshMode)
    Table view
    boolean concurrently
    RefreshMode refreshMode
    getView () → Table
    returns Table
    setView (view)
    Table view
    getRefreshMode () → RefreshMode
    returns RefreshMode
    setRefreshMode (refreshMode)
    RefreshMode refreshMode
    isConcurrently () → boolean
    returns boolean
    setConcurrently (concurrently)
    boolean concurrently
    @SuppressWarnings,| @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withConcurrently (concurrently) → RefreshMaterializedViewStatement
    boolean concurrently

    statement.select

    First.Keyword

    [FIRST, LIMIT]

    ForClause.ForOption

    [BROWSE, XML, JSON]

    ForMode

    [UPDATE, SHARE, NO_KEY_UPDATE, KEY_SHARE]

    KSQLWindow.TimeUnit

    [DAY, HOUR, MINUTE, SECOND, MILLISECOND, DAYS, HOURS, MINUTES, SECONDS, MILLISECONDS]

    KSQLWindow.WindowType

    [HOPPING, SESSION, TUMBLING]

    MySqlSqlCacheFlags

    [SQL_CACHE, SQL_NO_CACHE]

    OrderByElement.NullOrdering

    [NULLS_FIRST, NULLS_LAST]

    SampleClause.SampleKeyword

    [SAMPLE, TABLESAMPLE]

    SampleClause.SampleMethod

    [BERNOULLI, SYSTEM, BLOCK]

    SetOperationList.SetOperationType

    [INTERSECT, EXCEPT, MINUS, UNION]

    AllColumns

    extends: ASTNodeAccessImpl implements: Expression provides: AllTableColumns

    AllColumns (exceptColumns, replaceExpressions)
    ExpressionList exceptColumns
    List replaceExpressions
    AllColumns ()
    getExceptColumns () → ExpressionList
    addExceptColumn (column) → ExpressionList
    Column column
    setExceptColumns (exceptColumns) → AllColumns
    ExpressionList exceptColumns
    returns AllColumns
    getReplaceExpressions () → List
    returns List
    addReplaceExpression (selectItem) → List
    SelectItem selectItem
    returns List
    setReplaceExpressions (replaceExpressions) → AllColumns
    List replaceExpressions
    returns AllColumns
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    AllTableColumns

    extends: AllColumns

    AllTableColumns (table, exceptColumns, replaceExpressions)
    Table table
    ExpressionList exceptColumns
    List replaceExpressions
    AllTableColumns (table)
    Table table
    AllTableColumns (table, allColumns)
    Table table
    AllColumns allColumns
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    withTable (table) → AllTableColumns
    Table table
    @Override
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor

    Distinct

    extends: Object implements: Serializable

    Distinct ()
    Distinct (useUnique)
    boolean useUnique
    getOnSelectItems () → List
    returns List
    setOnSelectItems (list)
    List list
    isUseUnique () → boolean
    returns boolean
    setUseUnique (useUnique)
    boolean useUnique
    @Override
    toString () → String
    returns String
    withOnSelectItems (onSelectItems) → Distinct
    List onSelectItems
    returns Distinct
    withUseUnique (useUnique) → Distinct
    boolean useUnique
    returns Distinct
    addOnSelectItems (onSelectItems) → Distinct
    SelectItem onSelectItems
    returns Distinct
    addOnSelectItems (onSelectItems) → Distinct
    Collection onSelectItems
    returns Distinct

    ExceptOp

    extends: SetOperation

    ExceptOp ()

    Fetch

    extends: Object implements: Serializable

    Fetch ()
    @Deprecated
    getRowCount () → long
    returns long
    @Deprecated
    setRowCount (l)
    long l
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    withExpression (expression) → Fetch
    Expression expression
    returns Fetch
    @Deprecated
    getFetchJdbcParameter () → JdbcParameter
    addFetchParameter (parameter) → Fetch
    String parameter
    returns Fetch
    getFetchParameters () → List
    returns List
    @Deprecated
    getFetchParam () → String
    returns String
    isFetchParamFirst () → boolean
    returns boolean
    @Deprecated
    setFetchJdbcParameter (jdbc)
    @Deprecated
    setFetchParam (s)
    String s
    setFetchParamFirst (b)
    boolean b
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Deprecated
    withRowCount (rowCount) → Fetch
    long rowCount
    returns Fetch
    @Deprecated
    withFetchJdbcParameter (fetchJdbcParameter) → Fetch
    JdbcParameter fetchJdbcParameter
    returns Fetch
    @Deprecated
    withFetchParam (fetchParam) → Fetch
    String fetchParam
    returns Fetch

    First

    extends: Object implements: Serializable

    First ()
    getRowCount () → Long
    returns Long
    setRowCount (rowCount)
    Long rowCount
    getJdbcParameter () → JdbcParameter
    setJdbcParameter (jdbcParameter)
    JdbcParameter jdbcParameter
    getKeyword () → Keyword
    returns Keyword
    setKeyword (keyword)
    Keyword keyword
    getVariable () → String
    returns String
    setVariable (variable)
    String variable
    @Override
    toString () → String
    returns String
    withKeyword (keyword) → First
    Keyword keyword
    returns First
    withRowCount (rowCount) → First
    Long rowCount
    returns First
    withJdbcParameter (jdbcParameter) → First
    JdbcParameter jdbcParameter
    returns First
    withVariable (variable) → First
    String variable
    returns First

    ForClause

    extends: ASTNodeAccessImpl

    ForClause ()
    getForOption () → ForOption
    returns ForOption
    setForOption (forOption) → ForClause
    String forOption
    returns ForClause
    @Override
    toString () → String
    returns String

    FromItemVisitorAdapter

    extends: Object implements: FromItemVisitor

    FromItemVisitorAdapter ()
    @Override
    visit (table)
    Table table
    @Override
    visit (selectBody)
    @Override
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    @Override
    visit (valuesList)
    TableFunction valuesList
    @Override
    visit (aThis)

    GroupByElement

    extends: Object implements: Serializable

    GroupByElement ()
    isUsingBrackets () → boolean
    returns boolean
    accept (groupByVisitor)
    GroupByVisitor groupByVisitor
    getGroupByExpressionList () → ExpressionList
    setGroupByExpressions (groupByExpressions)
    ExpressionList groupByExpressions
    @Deprecated
    getGroupByExpressions () → ExpressionList
    @Deprecated
    addGroupByExpression (groupByExpression)
    Expression groupByExpression
    getGroupingSets () → List
    returns List
    setGroupingSets (groupingSets)
    List groupingSets
    addGroupingSet (list)
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withGroupByExpressions (groupByExpressions) → GroupByElement
    ExpressionList groupByExpressions
    withGroupingSets (groupingSets) → GroupByElement
    List groupingSets
    addGroupByExpressions (groupByExpressions) → GroupByElement
    Expression groupByExpressions
    addGroupByExpressions (groupByExpressions) → GroupByElement
    Collection groupByExpressions
    addGroupingSets (groupingSets) → GroupByElement
    Object groupingSets
    addGroupingSets (groupingSets) → GroupByElement
    Collection groupingSets
    isMysqlWithRollup () → boolean
    returns boolean
    setMysqlWithRollup (mysqlWithRollup) → GroupByElement
    boolean mysqlWithRollup

    IntersectOp

    extends: SetOperation

    IntersectOp ()

    IntoTableVisitorAdapter

    extends: Object implements: IntoTableVisitor

    IntoTableVisitorAdapter ()
    @Override
    visit (tableName)
    Table tableName

    Join

    extends: ASTNodeAccessImpl

    Join ()
    isSimple () → boolean
    returns boolean
    withSimple (b) → Join
    boolean b
    returns Join
    setSimple (b)
    boolean b
    isInnerJoin () → boolean
    A JOIN means INNER when the INNER keyword is set or when no other qualifier has been set.
    returns boolean | Tells, if a JOIN means a qualified INNER JOIN.
    isInner () → boolean
    returns boolean | Tells, if the INNER keyword has been set.
    withInner (b) → Join
    boolean b
    returns Join
    setInner (b)
    Sets the INNER keyword and switches off any contradicting qualifiers automatically.
    boolean b
    isStraight () → boolean
    returns boolean
    withStraight (b) → Join
    boolean b
    returns Join
    setStraight (b)
    boolean b
    isOuter () → boolean
    Whether is a “OUTER” join
    returns boolean | true if is a “OUTER” join
    withOuter (b) → Join
    boolean b
    returns Join
    setOuter (b)
    Sets the OUTER keyword and switches off any contradicting qualifiers automatically.
    boolean b
    isApply () → boolean
    returns boolean
    withApply (apply) → Join
    boolean apply
    returns Join
    setApply (apply)
    boolean apply
    isSemi () → boolean
    Whether is a “SEMI” join
    returns boolean | true if is a “SEMI” join
    withSemi (b) → Join
    boolean b
    returns Join
    setSemi (b)
    boolean b
    isLeft () → boolean
    Whether is a “LEFT” join
    returns boolean | true if is a “LEFT” join
    withLeft (b) → Join
    boolean b
    returns Join
    setLeft (b)
    Sets the LEFT keyword and switches off any contradicting qualifiers automatically.
    boolean b
    isRight () → boolean
    Whether is a “RIGHT” join
    returns boolean | true if is a “RIGHT” join
    withRight (b) → Join
    boolean b
    returns Join
    setRight (b)
    Sets the RIGHT keyword and switches off any contradicting qualifiers automatically.
    boolean b
    isNatural () → boolean
    Whether is a “NATURAL” join
    returns boolean | true if is a “NATURAL” join
    isGlobal () → boolean
    returns boolean
    withNatural (b) → Join
    boolean b
    returns Join
    setNatural (b)
    boolean b
    setGlobal (b)
    boolean b
    isFull () → boolean
    Whether is a “FULL” join
    returns boolean | true if is a “FULL” join
    withFull (b) → Join
    boolean b
    returns Join
    setFull (b)
    boolean b
    isCross () → boolean
    returns boolean
    withCross (cross) → Join
    boolean cross
    returns Join
    setCross (cross)
    boolean cross
    getRightItem () → FromItem
    Returns the right item of the join
    returns FromItem
    @Deprecated
    withRightItem (item) → Join
    returns Join
    setRightItem (item)
    getFromItem () → FromItem
    returns FromItem
    setFromItem (fromItem) → Join
    FromItem fromItem
    returns Join
    @Deprecated
    getOnExpression () → Expression
    Returns the “ON” expression (if any)
    returns Expression
    getOnExpressions () → Collection
    returns Collection
    @Deprecated
    withOnExpression (expression) → Join
    Expression expression
    returns Join
    @Deprecated
    setOnExpression (expression)
    Expression expression
    addOnExpression (expression) → Join
    Expression expression
    returns Join
    setOnExpressions (expressions) → Join
    Collection expressions
    returns Join
    getUsingColumns () → List
    Returns the “USING” list of `net.sf.jsqlparser.schema.Column`s (if any)
    returns List
    withUsingColumns (list) → Join
    List list
    returns Join
    setUsingColumns (list)
    List list
    isWindowJoin () → boolean
    returns boolean
    getJoinWindow () → KSQLJoinWindow
    Return the “WITHIN” join window (if any)
    returns KSQLJoinWindow |
    withJoinWindow (joinWindow) → Join
    KSQLJoinWindow joinWindow
    returns Join
    setJoinWindow (joinWindow)
    KSQLJoinWindow joinWindow
    getJoinHint () → JoinHint
    returns JoinHint
    setJoinHint (joinHint) → Join
    JoinHint joinHint
    returns Join
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    addUsingColumns (usingColumns) → Join
    Column usingColumns
    returns Join
    addUsingColumns (usingColumns) → Join
    Collection usingColumns
    returns Join

    JoinHint

    extends: Object

    Hints (Transact-SQL) - Join
    JoinHint (keyword)
    String keyword
    @Override
    toString () → String
    returns String

    KSQLJoinWindow

    extends: ASTNodeAccessImpl

    KSQLJoinWindow ()
    isBeforeAfterWindow () → boolean
    returns boolean
    setBeforeAfterWindow (beforeAfter)
    boolean beforeAfter
    getDuration () → long
    returns long
    setDuration (duration)
    long duration
    getTimeUnit () → TimeUnit
    returns TimeUnit
    setTimeUnit (timeUnit)
    TimeUnit timeUnit
    getBeforeDuration () → long
    returns long
    setBeforeDuration (beforeDuration)
    long beforeDuration
    getBeforeTimeUnit () → TimeUnit
    returns TimeUnit
    setBeforeTimeUnit (beforeTimeUnit)
    TimeUnit beforeTimeUnit
    getAfterDuration () → long
    returns long
    setAfterDuration (afterDuration)
    long afterDuration
    getAfterTimeUnit () → TimeUnit
    returns TimeUnit
    setAfterTimeUnit (afterTimeUnit)
    TimeUnit afterTimeUnit
    @Override
    toString () → String
    returns String
    withDuration (duration) → KSQLJoinWindow
    long duration
    withTimeUnit (timeUnit) → KSQLJoinWindow
    TimeUnit timeUnit
    withBeforeDuration (beforeDuration) → KSQLJoinWindow
    long beforeDuration
    withBeforeTimeUnit (beforeTimeUnit) → KSQLJoinWindow
    TimeUnit beforeTimeUnit
    withAfterDuration (afterDuration) → KSQLJoinWindow
    long afterDuration
    withAfterTimeUnit (afterTimeUnit) → KSQLJoinWindow
    TimeUnit afterTimeUnit
    from (timeUnitStr) → TimeUnit
    String timeUnitStr
    returns TimeUnit

    KSQLWindow

    extends: ASTNodeAccessImpl

    KSQLWindow ()
    isHoppingWindow () → boolean
    returns boolean
    setHoppingWindow (hopping)
    boolean hopping
    isTumblingWindow () → boolean
    returns boolean
    setTumblingWindow (tumbling)
    boolean tumbling
    isSessionWindow () → boolean
    returns boolean
    setSessionWindow (session)
    boolean session
    getSizeDuration () → long
    returns long
    setSizeDuration (sizeDuration)
    long sizeDuration
    getSizeTimeUnit () → TimeUnit
    returns TimeUnit
    setSizeTimeUnit (sizeTimeUnit)
    TimeUnit sizeTimeUnit
    getAdvanceDuration () → long
    returns long
    setAdvanceDuration (advanceDuration)
    long advanceDuration
    getAdvanceTimeUnit () → TimeUnit
    returns TimeUnit
    setAdvanceTimeUnit (advanceTimeUnit)
    TimeUnit advanceTimeUnit
    @Override
    toString () → String
    returns String
    withSizeDuration (sizeDuration) → KSQLWindow
    long sizeDuration
    returns KSQLWindow
    withSizeTimeUnit (sizeTimeUnit) → KSQLWindow
    TimeUnit sizeTimeUnit
    returns KSQLWindow
    withAdvanceDuration (advanceDuration) → KSQLWindow
    long advanceDuration
    returns KSQLWindow
    withAdvanceTimeUnit (advanceTimeUnit) → KSQLWindow
    TimeUnit advanceTimeUnit
    returns KSQLWindow

    LateralSubSelect

    extends: ParenthesedSelect

    lateral sub select
    LateralSubSelect ()
    LateralSubSelect (prefix)
    String prefix
    getPrefix () → String
    returns String
    setPrefix (prefix)
    String prefix
    withPrefix (prefix) → LateralSubSelect
    String prefix
    withSelect (select) → LateralSubSelect
    Select select
    toString () → String
    returns String
    accept (selectVisitor)
    SelectVisitor selectVisitor
    @Override
    accept (fromItemVisitor)
    FromItemVisitor fromItemVisitor

    LateralView

    extends: Object implements: Serializable

    LateralView (useOuter, generatorFunction, tableAlias, columnAlias)
    boolean useOuter
    Function generatorFunction
    Alias tableAlias
    Alias columnAlias
    isUsingOuter () → boolean
    returns boolean
    setUsingOuter (useOuter)
    boolean useOuter
    withOuter (useOuter) → LateralView
    boolean useOuter
    returns LateralView
    getGeneratorFunction () → Function
    returns Function
    setGeneratorFunction (generatorFunction)
    Function generatorFunction
    withGeneratorFunction (generatorFunction) → LateralView
    Function generatorFunction
    returns LateralView
    getTableAlias () → Alias
    returns Alias
    setTableAlias (tableAlias)
    Alias tableAlias
    withTableAlias (tableAlias) → LateralView
    Alias tableAlias
    returns LateralView
    getColumnAlias () → Alias
    returns Alias
    setColumnAlias (columnAlias)
    Alias columnAlias
    withColumnAlias (columnAlias) → LateralView
    Alias columnAlias
    returns LateralView
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    Limit

    extends: ASTNodeAccessImpl

    Limit ()
    getOffset () → Expression
    returns Expression
    getRowCount () → Expression
    returns Expression
    setOffset (l)
    setRowCount (l)
    @Deprecated
    isLimitAll () → boolean
    returns boolean
    @Deprecated
    setLimitAll (b)
    boolean b
    @Deprecated
    isLimitNull () → boolean
    returns boolean
    @Deprecated
    setLimitNull (b)
    boolean b
    @Override
    toString () → String
    returns String
    withRowCount (rowCount) → Limit
    Expression rowCount
    returns Limit
    withOffset (offset) → Limit
    Expression offset
    returns Limit
    @Deprecated
    withLimitAll (limitAll) → Limit
    boolean limitAll
    returns Limit
    @Deprecated
    withLimitNull (limitNull) → Limit
    boolean limitNull
    returns Limit
    getOffset (part) → E
    Class part
    returns E
    getRowCount (part) → E
    Class part
    returns E
    getByExpressions () → ExpressionList
    setByExpressions (byExpressions)
    ExpressionList byExpressions
    setByExpressions (byExpressions)
    Expression byExpressions
    addByExpression (byExpression)
    Expression byExpression
    withByExpressions (byExpressions) → Limit
    ExpressionList byExpressions
    returns Limit
    withByExpressions (byExpressions) → Limit
    Expression byExpressions
    returns Limit

    MinusOp

    extends: SetOperation

    MinusOp ()

    Offset

    extends: Object implements: Serializable

    Offset ()
    getOffset () → Expression
    returns Expression
    getOffsetParam () → String
    returns String
    setOffset (offsetExpression)
    Expression offsetExpression
    setOffsetParam (s)
    String s
    @Override
    toString () → String
    returns String
    withOffset (offsetExpression) → Offset
    Expression offsetExpression
    returns Offset
    withOffsetParam (offsetParam) → Offset
    String offsetParam
    returns Offset
    getOffset (part) → E
    Class part
    returns E

    OptimizeFor

    extends: Object implements: Serializable

    A optimize for clause.
    OptimizeFor (rowCount)
    long rowCount
    getRowCount () → long
    returns long
    setRowCount (l)
    long l
    @Override
    toString () → String
    returns String
    withRowCount (rowCount) → OptimizeFor
    long rowCount
    returns OptimizeFor

    OrderByElement

    extends: Object implements: Serializable

    OrderByElement ()
    isAsc () → boolean
    returns boolean
    getNullOrdering () → NullOrdering
    returns NullOrdering
    setNullOrdering (nullOrdering)
    NullOrdering nullOrdering
    setAsc (asc)
    boolean asc
    setAscDescPresent (ascDescPresent)
    boolean ascDescPresent
    isAscDescPresent () → boolean
    returns boolean
    accept (orderByVisitor)
    OrderByVisitor orderByVisitor
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    @Override
    toString () → String
    returns String
    withExpression (expression) → OrderByElement
    Expression expression
    withAsc (asc) → OrderByElement
    boolean asc
    withAscDescPresent (ascDescPresent) → OrderByElement
    boolean ascDescPresent
    withNullOrdering (nullOrdering) → OrderByElement
    NullOrdering nullOrdering
    getExpression (part) → E
    Class part
    returns E
    isMysqlWithRollup () → boolean
    returns boolean
    setMysqlWithRollup (mysqlWithRollup) → OrderByElement
    boolean mysqlWithRollup

    OrderByVisitorAdapter

    extends: Object implements: OrderByVisitor

    OrderByVisitorAdapter ()
    @Override
    visit (orderBy)

    ParenthesedFromItem

    extends: Object implements: FromItem

    ParenthesedFromItem ()
    ParenthesedFromItem (fromItem)
    FromItem fromItem
    getFromItem () → FromItem
    returns FromItem
    setFromItem (fromItem)
    FromItem fromItem
    getJoins () → List
    returns List
    getJoin (index) → Join
    int index
    returns Join
    addJoins (joins) → FromItem
    Join joins
    returns FromItem
    withJoins (joins) → FromItem
    List joins
    returns FromItem
    setJoins (list)
    List list
    @Override
    accept (fromItemVisitor)
    FromItemVisitor fromItemVisitor
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    @Override
    getAlias () → Alias
    returns Alias
    @Override
    setAlias (alias)
    Alias alias
    @Override
    getPivot () → Pivot
    returns Pivot
    @Override
    setPivot (pivot)
    Pivot pivot
    @Override
    getUnPivot () → UnPivot
    returns UnPivot
    @Override
    setUnPivot (unpivot)
    UnPivot unpivot
    withFromItem (fromItem) → ParenthesedFromItem
    FromItem fromItem
    @Override
    withAlias (alias) → ParenthesedFromItem
    Alias alias
    getFromItem (part) → E
    Class part
    returns E

    ParenthesedSelect

    extends: Select implements: FromItem provides: LateralSubSelect, WithItem

    ParenthesedSelect ()
    @Override
    getAlias () → Alias
    returns Alias
    @Override
    setAlias (alias)
    Alias alias
    withAlias (alias) → ParenthesedSelect
    Alias alias
    @Override
    getPivot () → Pivot
    returns Pivot
    @Override
    setPivot (pivot)
    Pivot pivot
    getUnPivot () → UnPivot
    returns UnPivot
    setUnPivot (unPivot)
    UnPivot unPivot
    getSelect () → Select
    returns Select
    getValues () → Values
    returns Values
    getPlainSelect () → PlainSelect
    returns PlainSelect
    getSetOperationList () → SetOperationList
    setSelect (select)
    Select select
    withSelect (selectBody) → ParenthesedSelect
    Select selectBody
    @Override
    accept (selectVisitor)
    SelectVisitor selectVisitor
    @Override
    accept (fromItemVisitor)
    FromItemVisitor fromItemVisitor
    appendSelectBodyTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder

    Pivot

    extends: Object implements: Serializable provides: PivotXml

    Pivot ()
    accept (pivotVisitor)
    PivotVisitor pivotVisitor
    getSingleInItems () → List
    returns List
    setSingleInItems (singleInItems)
    List singleInItems
    getMultiInItems () → List
    returns List
    setMultiInItems (multiInItems)
    List multiInItems
    getFunctionItems () → List
    returns List
    setFunctionItems (functionItems)
    List functionItems
    getForColumns () → ExpressionList
    setForColumns (forColumns)
    ExpressionList forColumns
    getInItems () → List
    returns List
    getAlias () → Alias
    returns Alias
    setAlias (alias)
    Alias alias
    @Override
    toString () → String
    returns String
    withFunctionItems (functionItems) → Pivot
    List functionItems
    returns Pivot
    withForColumns (forColumns) → Pivot
    ExpressionList forColumns
    returns Pivot
    withSingleInItems (singleInItems) → Pivot
    List singleInItems
    returns Pivot
    withMultiInItems (multiInItems) → Pivot
    List multiInItems
    returns Pivot
    withAlias (alias) → Pivot
    Alias alias
    returns Pivot
    addFunctionItems (functionItems) → Pivot
    SelectItem functionItems
    returns Pivot
    addFunctionItems (functionItems) → Pivot
    Collection functionItems
    returns Pivot
    addForColumns (forColumns) → Pivot
    Column forColumns
    returns Pivot
    addForColumns (forColumns) → Pivot
    Collection forColumns
    returns Pivot
    addSingleInItems (singleInItems) → Pivot
    SelectItem singleInItems
    returns Pivot
    addSingleInItems (singleInItems) → Pivot
    Collection singleInItems
    returns Pivot
    addMultiInItems (multiInItems) → Pivot
    SelectItem multiInItems
    returns Pivot
    addMultiInItems (multiInItems) → Pivot
    Collection multiInItems
    returns Pivot

    PivotVisitorAdapter

    extends: Object implements: PivotVisitor

    PivotVisitorAdapter ()
    @Override
    visit (pivot)
    Pivot pivot
    @Override
    visit (pivot)
    PivotXml pivot
    @Override
    visit (unpivot)
    UnPivot unpivot

    PivotXml

    extends: Pivot

    PivotXml ()
    @Override
    accept (pivotVisitor)
    PivotVisitor pivotVisitor
    getInSelect () → Select
    returns Select
    setInSelect (inSelect)
    Select inSelect
    isInAny () → boolean
    returns boolean
    setInAny (inAny)
    boolean inAny
    @Override
    toString () → String
    returns String
    withInSelect (inSelect) → PivotXml
    Select inSelect
    returns PivotXml
    withInAny (inAny) → PivotXml
    boolean inAny
    returns PivotXml
    getInSelect (part) → E
    Class part
    returns E
    @Override
    withAlias (alias) → PivotXml
    Alias alias
    returns PivotXml
    @Override
    withFunctionItems (functionItems) → PivotXml
    List functionItems
    returns PivotXml
    @Override
    withForColumns (forColumns) → PivotXml
    ExpressionList forColumns
    returns PivotXml
    @Override
    withSingleInItems (singleInItems) → PivotXml
    List singleInItems
    returns PivotXml
    @Override
    withMultiInItems (multiInItems) → PivotXml
    List multiInItems
    returns PivotXml
    @Override
    addFunctionItems (functionItems) → PivotXml
    Collection functionItems
    returns PivotXml
    @Override
    addFunctionItems (functionItems) → PivotXml
    SelectItem functionItems
    returns PivotXml
    @Override
    addForColumns (forColumns) → PivotXml
    Collection forColumns
    returns PivotXml
    @Override
    addForColumns (forColumns) → PivotXml
    Column forColumns
    returns PivotXml
    @Override
    addSingleInItems (singleInItems) → PivotXml
    Collection singleInItems
    returns PivotXml
    @Override
    addSingleInItems (singleInItems) → PivotXml
    SelectItem singleInItems
    returns PivotXml
    @Override
    addMultiInItems (multiInItems) → PivotXml
    SelectItem multiInItems
    returns PivotXml
    @Override
    addMultiInItems (multiInItems) → PivotXml
    Collection multiInItems
    returns PivotXml

    PlainSelect

    extends: Select

    PlainSelect ()
    @Deprecated
    isUseBrackets () → boolean
    returns boolean
    getFromItem () → FromItem
    returns FromItem
    getIntoTables () → List
    returns List
    getSelectItems () → List
    returns List
    getSelectItem (index) → SelectItem
    int index
    returns SelectItem
    getWhere () → Expression
    returns Expression
    withFromItem (item) → PlainSelect
    returns PlainSelect
    setFromItem (item)
    setIntoTables (intoTables)
    List intoTables
    withSelectItems (list) → PlainSelect
    List list
    returns PlainSelect
    setSelectItems (list)
    List list
    addSelectItems (items) → PlainSelect
    returns PlainSelect
    addSelectItems (expressions) → PlainSelect
    Expression expressions
    returns PlainSelect
    addSelectItem (expression, alias) → PlainSelect
    Expression expression
    Alias alias
    returns PlainSelect
    addSelectItem (expression) → PlainSelect
    Expression expression
    returns PlainSelect
    setWhere (where)
    getLateralViews () → List
    returns List
    setLateralViews (lateralViews)
    Collection lateralViews
    addLateralView (lateralView) → PlainSelect
    LateralView lateralView
    returns PlainSelect
    withLateralViews (lateralViews) → PlainSelect
    Collection lateralViews
    returns PlainSelect
    getJoins () → List
    The list of `Join`s
    returns List | the list of `Join`s
    getJoin (index) → Join
    int index
    returns Join
    addJoins (joins) → PlainSelect
    Join joins
    returns PlainSelect
    withJoins (joins) → PlainSelect
    List joins
    returns PlainSelect
    setJoins (list)
    List list
    isUsingFinal () → boolean
    returns boolean
    setUsingFinal (usingFinal)
    boolean usingFinal
    withUsingFinal (usingFinal) → PlainSelect
    boolean usingFinal
    returns PlainSelect
    isUsingOnly () → boolean
    returns boolean
    setUsingOnly (usingOnly)
    boolean usingOnly
    withUsingOnly (usingOnly) → PlainSelect
    boolean usingOnly
    returns PlainSelect
    isUseWithNoLog () → boolean
    returns boolean
    setUseWithNoLog (useWithNoLog)
    boolean useWithNoLog
    withUseWithNoLog (useWithNoLog) → PlainSelect
    boolean useWithNoLog
    returns PlainSelect
    getIntoTempTable () → Table
    returns Table
    setIntoTempTable (intoTempTable)
    Table intoTempTable
    withIntoTempTable (intoTempTable) → PlainSelect
    Table intoTempTable
    returns PlainSelect
    @Override
    accept (selectVisitor)
    SelectVisitor selectVisitor
    getOptimizeFor () → OptimizeFor
    returns OptimizeFor
    setOptimizeFor (optimizeFor)
    OptimizeFor optimizeFor
    getTop () → Top
    returns Top
    setTop (top)
    Top top
    getSkip () → Skip
    returns Skip
    setSkip (skip)
    Skip skip
    getMySqlHintStraightJoin () → boolean
    returns boolean
    setMySqlHintStraightJoin (mySqlHintStraightJoin)
    boolean mySqlHintStraightJoin
    getFirst () → First
    returns First
    setFirst (first)
    First first
    getDistinct () → Distinct
    returns Distinct
    setDistinct (distinct)
    Distinct distinct
    getHaving () → Expression
    returns Expression
    setHaving (expression)
    Expression expression
    getQualify () → Expression
    returns Expression
    setQualify (qualify) → PlainSelect
    Expression qualify
    returns PlainSelect
    getGroupBy () → GroupByElement
    A list of `Expression`s of the GROUP BY clause. It is null in case there is no GROUP BY clause
    returns GroupByElement | a list of `Expression`s
    setGroupByElement (groupBy)
    addGroupByColumnReference (expr) → PlainSelect
    returns PlainSelect
    getOracleHierarchical () → OracleHierarchicalExpression
    setOracleHierarchical (oracleHierarchical)
    OracleHierarchicalExpression oracleHierarchical
    getForMode () → ForMode
    returns ForMode
    setForMode (forMode)
    ForMode forMode
    getForUpdateTable () → Table
    returns Table
    setForUpdateTable (forUpdateTable)
    Table forUpdateTable
    getOracleHint () → OracleHint
    returns OracleHint
    setOracleHint (oracleHint)
    OracleHint oracleHint
    setWait (wait)
    Sets the Wait for this SELECT
    Wait wait | wait the Wait for this SELECT
    getWait () → Wait
    Returns the value of the Wait set for this SELECT
    returns Wait | the value of the Wait set for this SELECT
    getForXmlPath () → String
    returns String
    setForXmlPath (forXmlPath)
    String forXmlPath
    getKsqlWindow () → KSQLWindow
    returns KSQLWindow
    setKsqlWindow (ksqlWindow)
    KSQLWindow ksqlWindow
    setEmitChanges (emitChanges)
    boolean emitChanges
    isEmitChanges () → boolean
    returns boolean
    getWindowDefinitions () → List
    returns List
    setWindowDefinitions (windowDefinitions)
    List windowDefinitions
    isSkipLocked () → boolean
    returns boolean
    setSkipLocked (skipLocked)
    boolean skipLocked
    @SuppressWarnings
    appendSelectBodyTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withMySqlSqlCalcFoundRows (mySqlCalcFoundRows) → PlainSelect
    boolean mySqlCalcFoundRows
    returns PlainSelect
    withMySqlSqlNoCache (mySqlCacheFlag) → PlainSelect
    MySqlSqlCacheFlags mySqlCacheFlag
    returns PlainSelect
    setMySqlSqlCalcFoundRows (mySqlCalcFoundRows)
    boolean mySqlCalcFoundRows
    setMySqlSqlCacheFlag (sqlCacheFlag)
    MySqlSqlCacheFlags sqlCacheFlag
    getMySqlSqlCalcFoundRows () → boolean
    returns boolean
    getMySqlSqlCacheFlag () → MySqlSqlCacheFlags
    returns MySqlSqlCacheFlags
    setNoWait (noWait)
    boolean noWait
    isNoWait () → boolean
    returns boolean
    withDistinct (distinct) → PlainSelect
    Distinct distinct
    returns PlainSelect
    withIntoTables (intoTables) → PlainSelect
    List intoTables
    returns PlainSelect
    withWhere (where) → PlainSelect
    returns PlainSelect
    withOptimizeFor (optimizeFor) → PlainSelect
    OptimizeFor optimizeFor
    returns PlainSelect
    withSkip (skip) → PlainSelect
    Skip skip
    returns PlainSelect
    withMySqlHintStraightJoin (mySqlHintStraightJoin) → PlainSelect
    boolean mySqlHintStraightJoin
    returns PlainSelect
    withFirst (first) → PlainSelect
    First first
    returns PlainSelect
    withTop (top) → PlainSelect
    Top top
    returns PlainSelect
    withOracleHierarchical (oracleHierarchical) → PlainSelect
    OracleHierarchicalExpression oracleHierarchical
    returns PlainSelect
    withOracleHint (oracleHint) → PlainSelect
    OracleHint oracleHint
    returns PlainSelect
    withOracleSiblings (oracleSiblings) → PlainSelect
    boolean oracleSiblings
    returns PlainSelect
    withForMode (forMode) → PlainSelect
    ForMode forMode
    returns PlainSelect
    withForUpdateTable (forUpdateTable) → PlainSelect
    Table forUpdateTable
    returns PlainSelect
    withForXmlPath (forXmlPath) → PlainSelect
    String forXmlPath
    returns PlainSelect
    withKsqlWindow (ksqlWindow) → PlainSelect
    KSQLWindow ksqlWindow
    returns PlainSelect
    withNoWait (noWait) → PlainSelect
    boolean noWait
    returns PlainSelect
    withSkipLocked (skipLocked) → PlainSelect
    boolean skipLocked
    returns PlainSelect
    withHaving (having) → PlainSelect
    Expression having
    returns PlainSelect
    withWait (wait) → PlainSelect
    Wait wait
    returns PlainSelect
    addSelectItems (selectItems) → PlainSelect
    Collection selectItems
    returns PlainSelect
    addIntoTables (intoTables) → PlainSelect
    Table intoTables
    returns PlainSelect
    addIntoTables (intoTables) → PlainSelect
    Collection intoTables
    returns PlainSelect
    addJoins (joins) → PlainSelect
    Collection joins
    returns PlainSelect
    getFromItem (part) → E
    Class part
    returns E
    getWhere (part) → E
    Class part
    returns E
    getHaving (part) → E
    Class part
    returns E

    SampleClause

    extends: Object

    SampleClause (keyword, method, percentageArgument, repeatArgument, seedArgument)
    String keyword
    String method
    Number percentageArgument
    Number repeatArgument
    Number seedArgument
    SampleClause ()
    SampleClause (keyword)
    String keyword
    getKeyword () → SampleKeyword
    returns SampleKeyword
    setKeyword (keyword) → SampleClause
    SampleKeyword keyword
    returns SampleClause
    getPercentageArgument () → Number
    returns Number
    setPercentageArgument (percentageArgument) → SampleClause
    Number percentageArgument
    returns SampleClause
    getRepeatArgument () → Number
    returns Number
    setRepeatArgument (repeatArgument) → SampleClause
    Number repeatArgument
    returns SampleClause
    getSeedArgument () → Number
    returns Number
    setSeedArgument (seedArgument) → SampleClause
    Number seedArgument
    returns SampleClause
    getMethod () → SampleMethod
    returns SampleMethod
    setMethod (method) → SampleClause
    SampleMethod method
    returns SampleClause
    setMethod (method) → SampleClause
    String method
    returns SampleClause
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    toString () → String
    returns String

    Select

    extends: ASTNodeAccessImpl implements: Statement, Expression provides: ParenthesedSelect, PlainSelect, SetOperationList, TableStatement, Values

    Select ()
    orderByToString (orderByElements) → String
    List orderByElements
    returns String
    orderByToString (oracleSiblings, orderByElements) → String
    boolean oracleSiblings
    List orderByElements
    returns String
    getFormattedList (list, expression) → String
    List list
    String expression
    returns String
    getFormattedList (list, expression, useComma, useBrackets) → String
    List list
    String expression
    boolean useComma
    boolean useBrackets
    returns String
    getStringList (list) → String
    List the toString out put of the objects in the List comma separated. If the List is null or empty an empty string is returned.
    The same as getStringList(list, true, false)
    List list | list list of objects with toString methods
    returns String | comma separated list of the elements in the list
    getStringList (list, useComma, useBrackets) → String
    List the toString out put of the objects in the List that can be comma separated. If the List is null or empty an empty string is returned.
    List list | list list of objects with toString methods
    boolean useComma | useComma true if the list has to be comma separated
    boolean useBrackets | useBrackets true if the list has to be enclosed in brackets
    returns String | comma separated list of the elements in the list
    appendStringListTo (builder, list, useComma, useBrackets) → StringBuilder
    Append the toString out put of the objects in the List (that can be comma separated). If the List is null or empty an empty string is returned.
    StringBuilder builder
    List list | list list of objects with toString methods
    boolean useComma | useComma true if the list has to be comma separated
    boolean useBrackets | useBrackets true if the list has to be enclosed in brackets
    returns StringBuilder | comma separated list of the elements in the list
    getWithItemsList () → List
    returns List
    setWithItemsList (withItemsList)
    List withItemsList
    withWithItemsList (withItemsList) → Select
    List withItemsList
    returns Select
    addWithItemsList (withItemsList) → Select
    Collection withItemsList
    returns Select
    addWithItemsList (withItemsList) → Select
    WithItem withItemsList
    returns Select
    isOracleSiblings () → boolean
    returns boolean
    setOracleSiblings (oracleSiblings)
    boolean oracleSiblings
    withOracleSiblings (oracleSiblings) → Select
    boolean oracleSiblings
    returns Select
    getForClause () → ForClause
    returns ForClause
    setForClause (forClause) → Select
    ForClause forClause
    returns Select
    getOrderByElements () → List
    returns List
    setOrderByElements (orderByElements)
    List orderByElements
    withOrderByElements (orderByElements) → Select
    List orderByElements
    returns Select
    addOrderByElements (orderByElements) → Select
    Collection orderByElements
    returns Select
    addOrderByElements (orderByElements) → Select
    OrderByElement orderByElements
    returns Select
    getLimit () → Limit
    returns Limit
    setLimit (limit)
    Limit limit
    withLimit (limit) → Select
    Limit limit
    returns Select
    getLimitBy () → Limit
    returns Limit
    setLimitBy (limitBy)
    Limit limitBy
    withLimitBy (part, limitBy) → E
    Class part
    Limit limitBy
    returns E
    getOffset () → Offset
    returns Offset
    setOffset (offset)
    Offset offset
    withOffset (offset) → Select
    Offset offset
    returns Select
    getFetch () → Fetch
    returns Fetch
    setFetch (fetch)
    Fetch fetch
    withFetch (fetch) → Select
    Fetch fetch
    returns Select
    getIsolation () → WithIsolation
    setIsolation (isolation)
    WithIsolation isolation
    withIsolation (isolation) → Select
    WithIsolation isolation
    returns Select
    appendSelectBodyTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String
    accept (selectVisitor)
    SelectVisitor selectVisitor
    accept (statementVisitor)
    StatementVisitor statementVisitor
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    @Deprecated
    getSelectBody () → Select
    returns Select
    getValues () → Values
    returns Values
    getPlainSelect () → PlainSelect
    returns PlainSelect
    getSetOperationList () → SetOperationList
    as (part) → E
    Class part
    returns E

    SelectItem

    extends: ASTNodeAccessImpl

    SelectItem (expression, alias)
    T expression
    Alias alias
    SelectItem ()
    SelectItem (expression)
    T expression
    from (expression, alias) → SelectItem
    Expression expression
    Alias alias
    returns SelectItem
    from (expression) → SelectItem
    Expression expression
    returns SelectItem
    getAlias () → Alias
    returns Alias
    setAlias (alias)
    Alias alias
    getExpression () → T
    returns T
    setExpression (expression)
    T expression
    accept (selectItemVisitor)
    SelectItemVisitor selectItemVisitor
    @Override
    toString () → String
    returns String
    withExpression (expression) → SelectItem
    T expression
    returns SelectItem
    withAlias (alias) → SelectItem
    Alias alias
    returns SelectItem
    getExpression (part) → E
    Class part
    returns E

    SelectItemVisitorAdapter

    extends: Object implements: SelectItemVisitor

    SelectItemVisitorAdapter ()
    @Override
    visit (item)

    SelectVisitorAdapter

    extends: Object implements: SelectVisitor

    SelectVisitorAdapter ()
    @Override
    visit (parenthesedSelect)
    ParenthesedSelect parenthesedSelect
    @Override
    visit (plainSelect)
    PlainSelect plainSelect
    @Override
    visit (setOpList)
    @Override
    visit (withItem)
    WithItem withItem
    @Override
    visit (aThis)
    Values aThis
    @Override
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    @Override
    visit (tableStatement)
    TableStatement tableStatement

    SetOperation

    extends: ASTNodeAccessImpl provides: ExceptOp, IntersectOp, MinusOp, UnionOp

    SetOperation (part)
    SetOperationType part
    @Override
    toString () → String
    returns String

    SetOperationList

    extends: Select

    SetOperationList ()
    @Override
    accept (selectVisitor)
    SelectVisitor selectVisitor
    getOrderByElements () → List
    returns List
    getSelects () → List
    returns List
    getSelect (index) → Select
    int index
    returns Select
    setSelects (selects)
    List selects
    setOperations (operations)
    List operations
    getOperations () → List
    returns List
    getOperation (index) → SetOperation
    int index
    returns SetOperation
    setOrderByElements (orderByElements)
    List orderByElements
    setBracketsOpsAndSelects (select, ops)
    List select
    List ops
    @Override
    appendSelectBodyTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    withOperations (operationList) → SetOperationList
    List operationList
    withSelects (selects) → SetOperationList
    List selects
    addSelects (selects) → SetOperationList
    Select selects
    addSelects (selects) → SetOperationList
    Collection selects
    addOperations (operationList) → SetOperationList
    SetOperation operationList
    addOperations (operationList) → SetOperationList
    Collection operationList

    Skip

    extends: Object implements: Serializable

    Skip ()
    getRowCount () → Long
    returns Long
    setRowCount (rowCount)
    Long rowCount
    getJdbcParameter () → JdbcParameter
    setJdbcParameter (jdbcParameter)
    JdbcParameter jdbcParameter
    getVariable () → String
    returns String
    setVariable (variable)
    String variable
    @Override
    toString () → String
    returns String
    withRowCount (rowCount) → Skip
    Long rowCount
    returns Skip
    withJdbcParameter (jdbcParameter) → Skip
    JdbcParameter jdbcParameter
    returns Skip
    withVariable (variable) → Skip
    String variable
    returns Skip

    TableFunction

    extends: Function implements: FromItem

    TableFunction (function)
    Function function
    TableFunction (prefix, function)
    String prefix
    Function function
    getFunction () → Function
    returns Function
    @Deprecated
    getExpression () → Function
    returns Function
    setFunction (function) → TableFunction
    Function function
    getPrefix () → String
    returns String
    setPrefix (prefix) → TableFunction
    String prefix
    @Override
    accept (fromItemVisitor)
    FromItemVisitor fromItemVisitor
    @Override
    getAlias () → Alias
    returns Alias
    @Override
    setAlias (alias)
    Alias alias
    @Override
    withAlias (alias) → TableFunction
    Alias alias
    @Override
    getPivot () → Pivot
    returns Pivot
    @Override
    setPivot (pivot)
    Pivot pivot
    @Override
    withPivot (pivot) → TableFunction
    Pivot pivot
    @Override
    getUnPivot () → UnPivot
    returns UnPivot
    @Override
    setUnPivot (unPivot)
    UnPivot unPivot
    @Override
    withUnPivot (unpivot) → TableFunction
    UnPivot unpivot
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    toString () → String
    returns String

    TableStatement

    extends: Select

    TableStatement ()
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    @Override
    appendSelectBodyTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @SuppressWarnings,| @Override
    appendTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    accept (selectVisitor)
    SelectVisitor selectVisitor

    Top

    extends: Object implements: Serializable

    Top ()
    getExpression () → Expression
    returns Expression
    setExpression (expression)
    Expression expression
    hasParenthesis () → boolean
    returns boolean
    setParenthesis (hasParenthesis)
    boolean hasParenthesis
    isPercentage () → boolean
    returns boolean
    setPercentage (percentage)
    boolean percentage
    setWithTies (withTies)
    boolean withTies
    isWithTies () → boolean
    returns boolean
    @Override
    toString () → String
    returns String
    withExpression (expression) → Top
    Expression expression
    returns Top
    getExpression (part) → E
    Class part
    returns E

    UnPivot

    extends: Object implements: Serializable

    UnPivot ()
    accept (pivotVisitor)
    PivotVisitor pivotVisitor
    getIncludeNulls () → boolean
    returns boolean
    setIncludeNulls (includeNulls)
    boolean includeNulls
    getIncludeNullsSpecified () → boolean
    returns boolean
    getUnPivotClause () → List
    returns List
    setUnPivotClause (unpivotClause)
    ExpressionList unpivotClause
    getUnPivotForClause () → List
    returns List
    setUnPivotForClause (forColumns)
    ExpressionList forColumns
    getUnPivotInClause () → List
    returns List
    setUnPivotInClause (unpivotInClause)
    List unpivotInClause
    @Override
    toString () → String
    returns String
    withIncludeNulls (includeNulls) → UnPivot
    boolean includeNulls
    returns UnPivot
    getAlias () → Alias
    returns Alias
    setAlias (alias)
    Alias alias

    UnionOp

    extends: SetOperation

    UnionOp ()
    isAll () → boolean
    returns boolean
    setAll (all)
    boolean all
    isDistinct () → boolean
    returns boolean
    setDistinct (distinct)
    boolean distinct
    @Override
    toString () → String
    returns String
    withDistinct (distinct) → UnionOp
    boolean distinct
    returns UnionOp
    withAll (all) → UnionOp
    boolean all
    returns UnionOp

    Values

    extends: Select

    Values ()
    Values (expressions)
    ExpressionList expressions
    getExpressions () → ExpressionList
    setExpressions (expressions)
    ExpressionList expressions
    @Override
    appendSelectBodyTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    accept (selectVisitor)
    SelectVisitor selectVisitor
    withExpressions (expressions) → Values
    ExpressionList expressions
    returns Values
    addExpressions (expressions) → Values
    Expression expressions
    returns Values
    addExpressions (expressions) → Values
    Collection expressions
    returns Values

    Wait

    extends: Object implements: Serializable

    Wait ()
    getTimeout () → long
    returns long
    setTimeout (timeout)
    long timeout
    @Override
    toString () → String
    Returns a String containing the WAIT clause and its timeout, where TIMEOUT is specified by #getTimeout(). The returned string will null be:" WAIT <TIMEOUT>"
    returns String
    withTimeout (timeout) → Wait
    long timeout
    returns Wait

    WithIsolation

    extends: Object implements: Serializable

    WithIsolation ()
    getIsolation () → String
    returns String
    setIsolation (s)
    String s
    @Override
    toString () → String
    returns String

    WithItem

    extends: ParenthesedSelect

    WithItem ()
    isRecursive () → boolean
    returns boolean
    setRecursive (recursive)
    boolean recursive
    getWithItemList () → List
    The `SelectItem`s in this WITH (for example the A,B,C in “WITH mywith (A,B,C) AS …”)
    returns List | a list of `SelectItem`s
    setWithItemList (withItemList)
    List withItemList
    @Override,| @SuppressWarnings
    appendSelectBodyTo (builder) → StringBuilder
    StringBuilder builder
    returns StringBuilder
    @Override
    accept (visitor)
    withWithItemList (withItemList) → WithItem
    List withItemList
    returns WithItem
    withRecursive (recursive) → WithItem
    boolean recursive
    returns WithItem
    addWithItemList (withItemList) → WithItem
    SelectItem withItemList
    returns WithItem
    addWithItemList (withItemList) → WithItem
    Collection withItemList
    returns WithItem

    FromItem

    implements: Model provides: ParenthesedFromItem, ParenthesedSelect, Table, TableFunction,

    accept (fromItemVisitor)
    FromItemVisitor fromItemVisitor
    getAlias () → Alias
    returns Alias
    withAlias (alias) → FromItem
    Alias alias
    returns FromItem
    setAlias (alias)
    Alias alias
    getPivot () → Pivot
    returns Pivot
    withPivot (pivot) → FromItem
    Pivot pivot
    returns FromItem
    setPivot (pivot)
    Pivot pivot
    getUnPivot () → UnPivot
    returns UnPivot
    withUnPivot (unpivot) → FromItem
    UnPivot unpivot
    returns FromItem
    setUnPivot (unpivot)
    UnPivot unpivot

    FromItemVisitor

    provides: FromItemVisitorAdapter, SelectDeParser, SelectValidator, TablesNamesFinder,

    visit (tableName)
    Table tableName
    visit (selectBody)
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    visit (tableFunction)
    TableFunction tableFunction
    visit (aThis)

    GroupByVisitor

    provides: GroupByValidator,

    visit (groupBy)

    IntoTableVisitor

    provides: IntoTableVisitorAdapter,

    visit (tableName)
    Table tableName

    OrderByVisitor

    provides: OrderByValidator, OrderByVisitorAdapter, UpdateDeParser,

    visit (orderBy)

    PivotVisitor

    provides: ExpressionVisitorAdapter, PivotVisitorAdapter, SelectDeParser, SelectValidator,

    visit (pivot)
    Pivot pivot
    visit (pivot)
    PivotXml pivot
    visit (unpivot)
    UnPivot unpivot

    SelectItemVisitor

    provides: AddAliasesVisitor, ConnectExpressionsVisitor, ExpressionVisitorAdapter, SelectDeParser, SelectItemVisitorAdapter, SelectValidator, TablesNamesFinder,

    visit (selectItem)
    SelectItem selectItem

    SelectVisitor

    provides: AddAliasesVisitor, ConnectExpressionsVisitor, SelectDeParser, SelectValidator, SelectVisitorAdapter, TableStatementDeParser, TablesNamesFinder,

    visit (parenthesedSelect)
    ParenthesedSelect parenthesedSelect
    visit (plainSelect)
    PlainSelect plainSelect
    visit (setOpList)
    visit (withItem)
    WithItem withItem
    visit (aThis)
    Values aThis
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    visit (tableStatement)
    TableStatement tableStatement

    statement.show

    ShowTablesStatement.Modifiers

    [EXTENDED, FULL]

    ShowTablesStatement.SelectionMode

    [FROM, IN]

    ShowIndexStatement

    extends: Object implements: Statement

    ShowIndexStatement ()
    ShowIndexStatement (tableName)
    String tableName
    getTableName () → String
    returns String
    setTableName (tableName)
    String tableName
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    withTableName (tableName) → ShowIndexStatement
    String tableName

    ShowTablesStatement

    extends: Object implements: Statement

    A SHOW TABLES statement
    ShowTablesStatement ()
    getModifiers () → EnumSet
    returns EnumSet
    setModifiers (modifiers)
    EnumSet modifiers
    getSelectionMode () → SelectionMode
    returns SelectionMode
    setSelectionMode (selectionMode)
    SelectionMode selectionMode
    getDbName () → String
    returns String
    setDbName (dbName)
    String dbName
    getLikeExpression () → Expression
    returns Expression
    setLikeExpression (likeExpression)
    Expression likeExpression
    getWhereCondition () → Expression
    returns Expression
    setWhereCondition (whereCondition)
    Expression whereCondition
    @Override
    toString () → String
    returns String
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor

    statement.truncate

    Truncate

    extends: Object implements: Statement

    Truncate ()
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getTable () → Table
    returns Table
    setTable (table)
    Table table
    getCascade () → boolean
    returns boolean
    setCascade (c)
    boolean c
    @Override
    toString () → String
    returns String
    isTableToken () → boolean
    returns boolean
    setTableToken (hasTable)
    boolean hasTable
    isOnly () → boolean
    returns boolean
    setOnly (only)
    boolean only
    withTableToken (hasTableToken) → Truncate
    boolean hasTableToken
    returns Truncate
    withTable (table) → Truncate
    Table table
    returns Truncate
    withCascade (cascade) → Truncate
    boolean cascade
    returns Truncate
    withOnly (only) → Truncate
    boolean only
    returns Truncate

    statement.update

    UpdateModifierPriority

    [LOW_PRIORITY]

    Update

    extends: Object implements: Statement

    Update ()
    getOutputClause () → OutputClause
    returns OutputClause
    setOutputClause (outputClause)
    OutputClause outputClause
    getUpdateSets () → List
    returns List
    getUpdateSet (index) → UpdateSet
    int index
    returns UpdateSet
    setUpdateSets (updateSets)
    List updateSets
    withUpdateSets (updateSets) → Update
    List updateSets
    returns Update
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getWithItemsList () → List
    returns List
    setWithItemsList (withItemsList)
    List withItemsList
    withWithItemsList (withItemsList) → Update
    List withItemsList
    returns Update
    addWithItemsList (withItemsList) → Update
    WithItem withItemsList
    returns Update
    addWithItemsList (withItemsList) → Update
    Collection withItemsList
    returns Update
    getTable () → Table
    returns Table
    getWhere () → Expression
    returns Expression
    setTable (table)
    Table table
    setWhere (expression)
    Expression expression
    getOracleHint () → OracleHint
    returns OracleHint
    setOracleHint (oracleHint)
    OracleHint oracleHint
    addUpdateSet (column, expression) → Update
    Column column
    Expression expression
    returns Update
    addUpdateSet (updateSet) → Update
    UpdateSet updateSet
    returns Update
    @Deprecated
    getColumns () → List
    returns List
    @Deprecated
    getExpressions () → List
    returns List
    @Deprecated
    setColumns (list)
    List list
    @Deprecated
    setExpressions (list)
    List list
    getFromItem () → FromItem
    returns FromItem
    setFromItem (fromItem)
    FromItem fromItem
    getJoins () → List
    returns List
    setJoins (joins)
    List joins
    getStartJoins () → List
    returns List
    setStartJoins (startJoins)
    List startJoins
    @Deprecated
    getSelect () → Select
    returns Select
    @Deprecated
    setSelect (select)
    Select select
    @Deprecated
    isUseColumnsBrackets () → boolean
    returns boolean
    @Deprecated
    setUseColumnsBrackets (useColumnsBrackets)
    boolean useColumnsBrackets
    @Deprecated
    isUseSelect () → boolean
    returns boolean
    @Deprecated
    setUseSelect (useSelect)
    boolean useSelect
    setOrderByElements (orderByElements)
    List orderByElements
    setLimit (limit)
    Limit limit
    getOrderByElements () → List
    returns List
    getLimit () → Limit
    returns Limit
    getReturningClause () → ReturningClause
    setReturningClause (returningClause) → Update
    ReturningClause returningClause
    returns Update
    getModifierPriority () → UpdateModifierPriority
    returns UpdateModifierPriority
    setModifierPriority (modifierPriority)
    UpdateModifierPriority modifierPriority
    isModifierIgnore () → boolean
    returns boolean
    setModifierIgnore (modifierIgnore)
    boolean modifierIgnore
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withTable (table) → Update
    Table table
    returns Update
    withFromItem (fromItem) → Update
    FromItem fromItem
    returns Update
    withJoins (joins) → Update
    List joins
    returns Update
    withStartJoins (startJoins) → Update
    List startJoins
    returns Update
    withSelect (select) → Update
    Select select
    returns Update
    withUseColumnsBrackets (useColumnsBrackets) → Update
    boolean useColumnsBrackets
    returns Update
    withUseSelect (useSelect) → Update
    boolean useSelect
    returns Update
    withOrderByElements (orderByElements) → Update
    List orderByElements
    returns Update
    withLimit (limit) → Update
    Limit limit
    returns Update
    withWhere (where) → Update
    returns Update
    withColumns (columns) → Update
    List columns
    returns Update
    withExpressions (expressions) → Update
    List expressions
    returns Update
    withModifierPriority (modifierPriority) → Update
    UpdateModifierPriority modifierPriority
    returns Update
    withModifierIgnore (modifierIgnore) → Update
    boolean modifierIgnore
    returns Update
    addColumns (columns) → Update
    Column columns
    returns Update
    addColumns (columns) → Update
    Collection columns
    returns Update
    addExpressions (expressions) → Update
    Expression expressions
    returns Update
    addExpressions (expressions) → Update
    Collection expressions
    returns Update
    addJoins (joins) → Update
    Join joins
    returns Update
    addJoins (joins) → Update
    Collection joins
    returns Update
    addStartJoins (startJoins) → Update
    Join startJoins
    returns Update
    addStartJoins (startJoins) → Update
    Collection startJoins
    returns Update
    addOrderByElements (orderByElements) → Update
    OrderByElement orderByElements
    returns Update
    addOrderByElements (orderByElements) → Update
    Collection orderByElements
    returns Update
    getWhere (part) → E
    Class part
    returns E
    getFromItem (part) → E
    Class part
    returns E

    UpdateSet

    extends: Object implements: Serializable

    UpdateSet ()
    UpdateSet (column)
    Column column
    UpdateSet (column, value)
    Column column
    getColumns () → ExpressionList
    getColumn (index) → Column
    int index
    returns Column
    setColumns (columns)
    getValues () → ExpressionList
    getValue (index) → Expression
    int index
    returns Expression
    setValues (values)
    add (column, value)
    Column column
    add (column)
    Add another column to the existing column list. Transform this list into a ParenthesedExpression list when needed.
    Column column
    add (expression)
    Add another expression to the existing value list. Transform this list into a ParenthesedExpression list when needed.
    Expression expression
    add (expressionList)
    ExpressionList expressionList
    appendUpdateSetsTo (builder, updateSets) → StringBuilder
    StringBuilder builder
    Collection updateSets
    returns StringBuilder

    statement.upsert

    UpsertType

    [UPSERT, REPLACE, REPLACE_SET, INSERT_OR_ABORT, INSERT_OR_FAIL, INSERT_OR_IGNORE, INSERT_OR_REPLACE, INSERT_OR_ROLLBACK]

    Upsert

    extends: Object implements: Statement

    Upsert ()
    getUpdateSets () → List
    returns List
    setUpdateSets (updateSets) → Upsert
    List updateSets
    returns Upsert
    getDuplicateUpdateSets () → List
    returns List
    setDuplicateUpdateSets (duplicateUpdateSets) → Upsert
    List duplicateUpdateSets
    returns Upsert
    @Override
    accept (statementVisitor)
    StatementVisitor statementVisitor
    getUpsertType () → UpsertType
    returns UpsertType
    setUpsertType (upsertType)
    UpsertType upsertType
    withUpsertType (upsertType) → Upsert
    UpsertType upsertType
    returns Upsert
    isUsingInto () → boolean
    returns boolean
    setUsingInto (useInto)
    boolean useInto
    withUsingInto (useInto) → Upsert
    boolean useInto
    returns Upsert
    getTable () → Table
    returns Table
    setTable (name)
    Table name
    getColumns () → ExpressionList
    setColumns (list)
    getExpressions () → ExpressionList
    setExpressions (list)
    @Deprecated
    getSetExpressions () → ExpressionList
    getSelect () → Select
    returns Select
    setSelect (select)
    Select select
    getValues () → Values
    returns Values
    getPlainSelect () → PlainSelect
    returns PlainSelect
    getSetOperationList () → SetOperationList
    @Override,| @SuppressWarnings
    toString () → String
    returns String
    withSelect (select) → Upsert
    Select select
    returns Upsert
    withTable (table) → Upsert
    Table table
    returns Upsert
    withColumns (columns) → Upsert
    returns Upsert
    withExpressions (expressions) → Upsert
    ExpressionList expressions
    returns Upsert
    addColumns (columns) → Upsert
    Column columns
    returns Upsert
    addColumns (columns) → Upsert
    Collection columns
    returns Upsert

    util

    AddAliasesVisitor

    extends: Object implements: SelectVisitor, SelectItemVisitor

    Add aliases to every column and expression selected by a select - statement. Existing aliases are recognized and preserved. This class standard uses a prefix of A and a counter to generate new aliases (e.g. A1, A5, …). This behaviour can be altered.
    AddAliasesVisitor ()
    @Override
    visit (parenthesedSelect)
    ParenthesedSelect parenthesedSelect
    @Override
    visit (plainSelect)
    PlainSelect plainSelect
    @Override
    visit (setOpList)
    @Override
    visit (selectExpressionItem)
    SelectItem selectExpressionItem
    returns String
    setPrefix (prefix)
    String prefix
    @Override
    visit (withItem)
    WithItem withItem
    @Override
    visit (aThis)
    Values aThis
    @Override
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    @Override
    visit (tableStatement)
    TableStatement tableStatement

    ConnectExpressionsVisitor

    extends: Object implements: SelectVisitor, SelectItemVisitor

    Connect all selected expressions with a binary expression. Out of select a,b from table one gets select a || b as expr from table. The part of binary expression is set by overwriting this class abstract method createBinaryExpression.
    ConnectExpressionsVisitor ()
    ConnectExpressionsVisitor (alias)
    String alias
    @Override
    visit (parenthesedSelect)
    ParenthesedSelect parenthesedSelect
    @Override
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    @Override
    visit (plainSelect)
    PlainSelect plainSelect
    @Override
    visit (setOpList)
    @Override
    visit (withItem)
    WithItem withItem
    @Override
    visit (selectItem)
    SelectItem selectItem
    @Override
    visit (aThis)
    Values aThis
    @Override
    visit (tableStatement)
    TableStatement tableStatement

    PerformanceTest

    extends: Object

    PerformanceTest ()
    @SuppressWarnings
    main (args)
    String args

    SelectUtils

    extends: Object

    buildSelectFromTableAndExpressions (table, expr) → Select
    Table table
    returns Select
    buildSelectFromTableAndExpressions (table, expr) → Select
    Table table
    String expr
    returns Select
    buildSelectFromTableAndSelectItems (table, selectItems) → Select
    Table table
    SelectItem selectItems
    returns Select
    buildSelectFromTable (table) → Select
    Builds select * from table.
    Table table
    returns Select |
    addExpression (select, expr)
    Adds an expression to select statements. E.g. a simple column is an expression.
    Select select
    addJoin (select, table, onExpression) → Join
    Adds a simple join to a select statement. The introduced join is returned for more configuration settings on it (e.g. left join, right join).
    Select select
    Table table
    Expression onExpression
    returns Join |
    addGroupBy (select, expr)
    Adds group by to a plain select statement.
    Select select

    TablesNamesFinder

    extends: Object implements: SelectVisitor, FromItemVisitor, ExpressionVisitor, SelectItemVisitor, StatementVisitor

    Find all used tables within an select statement.
    Override extractTableName method to modify the extracted table names (e.g. without schema).
    TablesNamesFinder ()
    @Deprecated
    getTableList (statement) → List
    Statement statement
    returns List
    getTables (statement) → Set
    Statement statement
    returns Set
    findTables (sqlStr) → Set
    String sqlStr
    returns Set
    @Override
    visit (select)
    Select select
    @Override
    visit (transcodingFunction)
    TranscodingFunction transcodingFunction
    @Override
    visit (trimFunction)
    TrimFunction trimFunction
    @Override
    visit (rangeExpression)
    RangeExpression rangeExpression
    @Deprecated
    getTableList (expr) → List
    Main entry for this Tool class. A list of found tables is returned.
    returns List
    getTables (expr) → Set
    returns Set
    findTablesInExpression (exprStr) → Set
    String exprStr
    returns Set
    @Override
    visit (withItem)
    WithItem withItem
    @Override
    visit (selectBody)
    @Override
    visit (plainSelect)
    PlainSelect plainSelect

    Override to adapt the tableName generation (e.g. with / without schema).

    Table table
    returns String |
    @Override
    visit (tableName)
    Table tableName
    @Override
    visit (addition)
    Addition addition
    @Override
    visit (andExpression)
    AndExpression andExpression
    @Override
    visit (between)
    Between between
    @Override
    visit (overlapsCondition)
    OverlapsCondition overlapsCondition
    @Override
    visit (tableColumn)
    Column tableColumn
    @Override
    visit (division)
    Division division
    @Override
    visit (division)
    @Override
    visit (doubleValue)
    DoubleValue doubleValue
    @Override
    visit (equalsTo)
    EqualsTo equalsTo
    @Override
    visit (function)
    Function function
    @Override
    visit (greaterThan)
    GreaterThan greaterThan
    @Override
    visit (greaterThanEquals)
    GreaterThanEquals greaterThanEquals
    @Override
    visit (inExpression)
    InExpression inExpression
    @Override
    visit (fullTextSearch)
    FullTextSearch fullTextSearch
    @Override
    visit (signedExpression)
    SignedExpression signedExpression
    @Override
    visit (isNullExpression)
    IsNullExpression isNullExpression
    @Override
    visit (isBooleanExpression)
    IsBooleanExpression isBooleanExpression
    @Override
    visit (jdbcParameter)
    JdbcParameter jdbcParameter
    @Override
    visit (likeExpression)
    LikeExpression likeExpression
    @Override
    visit (existsExpression)
    ExistsExpression existsExpression
    @Override
    visit (memberOfExpression)
    MemberOfExpression memberOfExpression
    @Override
    visit (longValue)
    LongValue longValue
    @Override
    visit (minorThan)
    MinorThan minorThan
    @Override
    visit (minorThanEquals)
    MinorThanEquals minorThanEquals
    @Override
    visit (multiplication)
    Multiplication multiplication
    @Override
    visit (notEqualsTo)
    NotEqualsTo notEqualsTo
    @Override
    visit (doubleAnd)
    DoubleAnd doubleAnd
    @Override
    visit (contains)
    Contains contains
    @Override
    visit (containedBy)
    ContainedBy containedBy
    @Override
    visit (nullValue)
    NullValue nullValue
    @Override
    visit (orExpression)
    OrExpression orExpression
    @Override
    visit (xorExpression)
    XorExpression xorExpression
    @Override
    visit (parenthesis)
    Parenthesis parenthesis
    @Override
    visit (stringValue)
    StringValue stringValue
    @Override
    visit (subtraction)
    Subtraction subtraction
    @Override
    visit (notExpr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    visitBinaryExpression (binaryExpression)
    BinaryExpression binaryExpression
    @Override
    visit (expressionList)
    ExpressionList expressionList
    @Override
    visit (dateValue)
    DateValue dateValue
    @Override
    visit (timestampValue)
    TimestampValue timestampValue
    @Override
    visit (timeValue)
    TimeValue timeValue
    @Override
    visit (caseExpression)
    CaseExpression caseExpression
    @Override
    visit (whenClause)
    WhenClause whenClause
    @Override
    visit (anyComparisonExpression)
    AnyComparisonExpression anyComparisonExpression
    @Override
    visit (concat)
    Concat concat
    @Override
    visit (matches)
    Matches matches
    @Override
    visit (bitwiseAnd)
    BitwiseAnd bitwiseAnd
    @Override
    visit (bitwiseOr)
    BitwiseOr bitwiseOr
    @Override
    visit (bitwiseXor)
    BitwiseXor bitwiseXor
    @Override
    visit (cast)
    @Override
    visit (modulo)
    Modulo modulo
    @Override
    visit (analytic)
    @Override
    visit (list)
    @Override
    visit (eexpr)
    @Override
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    @Override
    visit (tableStatement)
    TableStatement tableStatement

    Initializes table names collector. Important is the usage of Column instances to find table

    names. This is only allowed for expression parsing, where a better place for tablenames could not be there. For complete statements only from items are used to avoid some alias as tablenames.

    boolean allowColumnProcessing
    returns void
    @Override
    visit (iexpr)
    @Override
    visit (jdbcNamedParameter)
    JdbcNamedParameter jdbcNamedParameter
    @Override
    visit (oexpr)
    @Override
    visit (rexpr)
    @Override
    visit (jsonExpr)
    @Override
    visit (jsonExpr)
    JsonOperator jsonExpr
    @Override
    visit (allColumns)
    AllColumns allColumns
    @Override
    visit (allTableColumns)
    AllTableColumns allTableColumns
    @Override
    visit (allValue)
    AllValue allValue
    @Override
    visit (isDistinctExpression)
    IsDistinctExpression isDistinctExpression
    @Override
    visit (item)
    @Override
    visit (var)
    @Override
    visit (bind)
    @Override
    visit (aexpr)
    @Override
    visit (groupConcat)
    MySQLGroupConcat groupConcat
    @Override
    visit (delete)
    Delete delete
    @Override
    visit (update)
    Update update
    @Override
    visit (insert)
    Insert insert
    visit (analyze)
    Analyze analyze
    @Override
    visit (drop)
    Drop drop
    @Override
    visit (truncate)
    Truncate truncate
    @Override
    visit (createIndex)
    CreateIndex createIndex
    @Override
    visit (aThis)
    @Override
    visit (create)
    @Override
    visit (createView)
    CreateView createView
    @Override
    visit (alter)
    Alter alter
    @Override
    visit (stmts)
    @Override
    visit (execute)
    Execute execute
    @Override
    visit (set)
    @Override
    visit (reset)
    @Override
    visit (set)
    @Override
    visit (showIndex)
    @Override
    visit (rowConstructor)
    RowConstructor rowConstructor
    @Override
    visit (rowGetExpression)
    RowGetExpression rowGetExpression
    @Override
    visit (hexValue)
    HexValue hexValue
    @Override
    visit (merge)
    Merge merge
    @Override
    visit (hint)
    @Override
    visit (tableFunction)
    TableFunction tableFunction
    @Override
    visit (alterView)
    AlterView alterView
    @Override
    visit (materializedView)
    @Override
    visit (timeKeyExpression)
    TimeKeyExpression timeKeyExpression
    @Override
    visit (literal)
    @Override
    visit (commit)
    Commit commit
    @Override
    visit (upsert)
    Upsert upsert
    @Override
    visit (use)
    @Override
    visit (parenthesis)
    @Override
    visit (block)
    Block block
    @Override
    visit (comment)
    Comment comment
    @Override
    visit (values)
    Values values
    @Override
    visit (describe)
    @Override
    visit (explain)
    @Override
    visit (nextVal)
    @Override
    visit (col)
    @Override
    visit (aThis)
    @Override
    visit (expr)
    @Override
    visit (aThis)
    @Override
    visit (grant)
    Grant grant
    @Override
    visit (array)
    @Override
    visit (array)
    @Override
    visit (createSequence)
    CreateSequence createSequence
    @Override
    visit (alterSequence)
    AlterSequence alterSequence
    @Override
    visit (createFunctionalStatement)
    CreateFunctionalStatement createFunctionalStatement
    @Override
    visit (showTables)
    @Override
    visit (tsqlLeftJoin)
    TSQLLeftJoin tsqlLeftJoin
    @Override
    visit (tsqlRightJoin)
    TSQLRightJoin tsqlRightJoin
    @Override
    visit (var)
    @Override
    visit (aThis)
    @Override
    visit (createSynonym)
    CreateSynonym createSynonym
    @Override
    visit (aThis)
    @Override
    visit (savepointStatement)
    SavepointStatement savepointStatement
    @Override
    visit (rollbackStatement)
    RollbackStatement rollbackStatement
    @Override
    visit (alterSession)
    AlterSession alterSession
    @Override
    visit (expression)
    @Override
    visit (expression)
    JsonFunction expression
    @Override
    visit (connectByRootOperator)
    ConnectByRootOperator connectByRootOperator
    visit (ifElseStatement)
    IfElseStatement ifElseStatement
    visit (oracleNamedFunctionParameter)
    OracleNamedFunctionParameter oracleNamedFunctionParameter
    @Override
    visit (renameTableStatement)
    RenameTableStatement renameTableStatement
    @Override
    visit (purgeStatement)
    PurgeStatement purgeStatement
    @Override
    visit (alterSystemStatement)
    AlterSystemStatement alterSystemStatement
    @Override
    visit (unsupportedStatement)
    UnsupportedStatement unsupportedStatement
    @Override
    visit (geometryDistance)
    GeometryDistance geometryDistance

    util.cnfexpression

    CNFConverter

    extends: Object

    This class handles the conversion from a normal expression tree into the CNF form. Here is the definition of CNF form: https://en.wikipedia.org/wiki/Conjunctive_normal_form Basically it will follow these steps: To help understanding, I will generate an example: Here is the original tree: OR / OR NOT / | NOT H AND | / NOT G OR | / F H NOT | OR / AND L / ( ) ( ) | | J K 1. rebuild the tree by replacing the “and” and “or” operators (which are binary) into their counterparts node that could hold multiple elements. Also, leave out the parenthesis node between the conditional operators to make the tree uniform. After the transform, the result should be like this: OR(M) / OR(M) NOT / | NOT H AND(M) | / NOT G OR(M) | / F H NOT | OR(M) / AND(M) L / J K 2. push the not operators into the bottom of the expression. That means the not operator will be the root of the expression tree where no “and” or “or” exists. Be sure use the De Morgan’s law and double not law. How to use De Morgan law: For example, here is the original expression tree: NOT | AND(M) / G H After we use the De Morgan law, the result should be like this: OR(M) / NOT NOT | | G H After the transform, the result should be like this: OR(M) / OR(M) OR(M) / / F H NOT AND(M) | / G NOT OR(M) | / H AND(M) L / J K 3. gather all the adjacent “and” or “or” operator together. After doing that, the expression tree will be presented as: all the and expression will be in either odd or even levels, this will be the same for the or operator. After the transform, the expression tree should be like this: OR(M) / / F H NOT AND(M) | / G NOT OR(M) | / H AND(M) L / J K 4. push the and operator upwards until the root is an and operator and all the children are or operators with multiple components. At this time we get the result: an expression in CNF form. How do we push and up? Use distribution law! For example, here is the way to push the and up and merge them. OR / AND L / J K In the normal form, it could be: (J AND K) OR L. If we apply the distribution law, we will get the result like this: (J OR L) AND (K OR L), the tree form of this should be like: AND / OR OR / / J L K L So after we push the AND at the deepest level up and merge it with the existing add, we get this result. OR(M) / / F H NOT AND(M) | / | G NOT OR(M) OR(M) | / / H J L K L Now let us push the and up and we will get the result like this: AND(M) / | OR(M) OR(M) OR(M) / / / / | / / | F H NOT NOT F H NOT J L F H NOT K L | | | | G H G G 5. The last step, convert the Multiple Expression back to the binary form. Note the final tree shall be left-inclined. The final expression tree shall be like this: AND / AND ( ) / | ( ) ( ) part1 | | OR part2 / OR NOT / | OR NOT H / | F H G part1: OR / OR L / OR K / OR NOT / | F H G part2: OR / OR L / OR J / OR NOT / | F H G
    CNFConverter ()
    convertToCNF (expr) → Expression
    returns Expression

    MultiAndExpression

    extends: MultipleExpression

    This helper class is mainly used for handling the CNF conversion.
    MultiAndExpression (childlist)
    List childlist
    @Override
    getStringExpression () → String
    returns String

    MultiOrExpression

    extends: MultipleExpression

    MultiOrExpression (childlist)
    List childlist
    @Override
    getStringExpression () → String
    returns String

    MultipleExpression

    extends: ASTNodeAccessImpl implements: Expression provides: MultiAndExpression, MultiOrExpression

    This is a helper class that mainly used for handling the CNF conversion.
    MultipleExpression (childlist)
    List childlist
    size () → int
    returns int
    @Override
    accept (expressionVisitor)
    ExpressionVisitor expressionVisitor
    getList () → List
    returns List
    getChild (index) → Expression
    int index
    returns Expression
    removeChild (index) → Expression
    int index
    returns Expression
    setChild (index, express)
    int index
    Expression express
    getIndex (express) → int
    Expression express
    returns int
    addChild (index, express)
    int index
    Expression express
    getStringExpression () → String
    returns String
    @Override
    toString () → String
    returns String

    util.deparser

    AlterDeParser

    extends: AbstractDeParser

    AlterDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (alter)
    Alter alter

    AlterSequenceDeParser

    extends: AbstractDeParser

    A class to de-parse (that is, transform from JSqlParser hierarchy into a string) a net.sf.jsqlparser.statement.alter.sequence.AlterSequence
    AlterSequenceDeParser (buffer)
    StringBuilder buffer | buffer the buffer that will be filled with the AlterSequence
    @Override
    deParse (statement)
    AlterSequence statement

    AlterSessionDeParser

    extends: AbstractDeParser

    AlterSessionDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (alterSession)
    AlterSession alterSession

    AlterViewDeParser

    extends: AbstractDeParser

    AlterViewDeParser (buffer)
    StringBuilder buffer
    AlterViewDeParser (buffer, selectVisitor)
    StringBuilder buffer
    SelectVisitor selectVisitor
    @Override
    deParse (alterView)
    AlterView alterView

    CreateIndexDeParser

    extends: AbstractDeParser

    CreateIndexDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (createIndex)
    CreateIndex createIndex

    CreateSequenceDeParser

    extends: AbstractDeParser

    A class to de-parse (that is, transform from JSqlParser hierarchy into a string) a net.sf.jsqlparser.statement.create.sequence.CreateSequence
    CreateSequenceDeParser (buffer)
    StringBuilder buffer | buffer the buffer that will be filled with the CreatSequence
    @Override
    deParse (statement)
    CreateSequence statement

    CreateSynonymDeparser

    extends: AbstractDeParser

    A class to de-parse (that is, transform from JSqlParser hierarchy into a string) a CreateSynonym
    CreateSynonymDeparser (buffer)
    StringBuilder buffer

    CreateTableDeParser

    extends: AbstractDeParser

    CreateTableDeParser (buffer)
    StringBuilder buffer
    CreateTableDeParser (statementDeParser, buffer)
    StatementDeParser statementDeParser
    StringBuilder buffer
    @Override,| @SuppressWarnings
    deParse (createTable)
    CreateTable createTable

    CreateViewDeParser

    extends: AbstractDeParser

    CreateViewDeParser (buffer)
    StringBuilder buffer
    CreateViewDeParser (buffer, selectVisitor)
    StringBuilder buffer
    SelectVisitor selectVisitor
    @Override,| @SuppressWarnings
    deParse (createView)
    CreateView createView

    DeclareStatementDeParser

    extends: AbstractDeParser

    DeclareStatementDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override,| @SuppressWarnings
    deParse (declare)
    getExpressionVisitor () → ExpressionVisitor
    setExpressionVisitor (visitor)

    DeleteDeParser

    extends: AbstractDeParser

    DeleteDeParser ()
    DeleteDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override,| @SuppressWarnings
    deParse (delete)
    Delete delete
    getExpressionVisitor () → ExpressionVisitor
    setExpressionVisitor (visitor)

    DropDeParser

    extends: AbstractDeParser

    DropDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (drop)
    Drop drop

    ExecuteDeParser

    extends: AbstractDeParser

    ExecuteDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override
    deParse (execute)
    Execute execute
    getExpressionVisitor () → ExpressionVisitor
    setExpressionVisitor (visitor)

    ExpressionDeParser

    extends: AbstractDeParser implements: ExpressionVisitor

    ExpressionDeParser ()
    ExpressionDeParser (selectVisitor, buffer)
    SelectVisitor selectVisitor
    StringBuilder buffer
    @Override
    visit (addition)
    Addition addition
    @Override
    visit (andExpression)
    AndExpression andExpression
    @Override
    visit (between)
    Between between
    @Override
    visit (overlapsCondition)
    OverlapsCondition overlapsCondition
    @Override
    visit (equalsTo)
    EqualsTo equalsTo
    @Override
    visit (division)
    Division division
    @Override
    visit (division)
    @Override
    visit (doubleValue)
    DoubleValue doubleValue
    @Override
    visit (hexValue)
    HexValue hexValue
    @Override
    visit (notExpr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    visitOldOracleJoinBinaryExpression (expression, operator)
    String operator
    @Override
    visit (greaterThan)
    GreaterThan greaterThan
    @Override
    visit (greaterThanEquals)
    GreaterThanEquals greaterThanEquals
    @Override
    visit (inExpression)
    InExpression inExpression
    @Override
    visit (fullTextSearch)
    FullTextSearch fullTextSearch
    @Override
    visit (signedExpression)
    SignedExpression signedExpression
    @Override
    visit (isNullExpression)
    IsNullExpression isNullExpression
    @Override
    visit (isBooleanExpression)
    IsBooleanExpression isBooleanExpression
    @Override
    visit (jdbcParameter)
    JdbcParameter jdbcParameter
    @Override
    visit (likeExpression)
    LikeExpression likeExpression
    @Override
    visit (existsExpression)
    ExistsExpression existsExpression
    @Override
    visit (memberOfExpression)
    MemberOfExpression memberOfExpression
    @Override
    visit (longValue)
    LongValue longValue
    @Override
    visit (minorThan)
    MinorThan minorThan
    @Override
    visit (minorThanEquals)
    MinorThanEquals minorThanEquals
    @Override
    visit (multiplication)
    Multiplication multiplication
    @Override
    visit (notEqualsTo)
    NotEqualsTo notEqualsTo
    @Override
    visit (doubleAnd)
    DoubleAnd doubleAnd
    @Override
    visit (contains)
    Contains contains
    @Override
    visit (containedBy)
    ContainedBy containedBy
    @Override
    visit (nullValue)
    NullValue nullValue
    @Override
    visit (orExpression)
    OrExpression orExpression
    @Override
    visit (xorExpression)
    XorExpression xorExpression
    @Override
    visit (parenthesis)
    Parenthesis parenthesis
    @Override
    visit (stringValue)
    StringValue stringValue
    @Override
    visit (subtraction)
    Subtraction subtraction
    BinaryExpression binaryExpression
    String operator
    returns void
    @Override
    visit (selectBody)
    Select selectBody
    @Override
    visit (transcodingFunction)
    TranscodingFunction transcodingFunction
    visit (trimFunction)
    TrimFunction trimFunction
    @Override
    visit (rangeExpression)
    RangeExpression rangeExpression
    @Override
    visit (tableColumn)
    Column tableColumn
    @Override,| @SuppressWarnings
    visit (function)
    Function function
    @Override
    visit (selectBody)
    getSelectVisitor () → SelectVisitor
    setSelectVisitor (visitor)
    @Override
    visit (dateValue)
    DateValue dateValue
    @Override
    visit (timestampValue)
    TimestampValue timestampValue
    @Override
    visit (timeValue)
    TimeValue timeValue
    @Override
    visit (caseExpression)
    CaseExpression caseExpression
    @Override
    visit (whenClause)
    WhenClause whenClause
    @Override
    visit (anyComparisonExpression)
    AnyComparisonExpression anyComparisonExpression
    @Override
    visit (concat)
    Concat concat
    @Override
    visit (matches)
    Matches matches
    @Override
    visit (bitwiseAnd)
    BitwiseAnd bitwiseAnd
    @Override
    visit (bitwiseOr)
    BitwiseOr bitwiseOr
    @Override
    visit (bitwiseXor)
    BitwiseXor bitwiseXor
    @Override
    visit (cast)
    @Override
    visit (modulo)
    Modulo modulo
    @Override,| @SuppressWarnings
    visit (aexpr)
    @Override
    visit (eexpr)
    @Override
    visit (intervalExpression)
    IntervalExpression intervalExpression
    @Override
    visit (jdbcNamedParameter)
    JdbcNamedParameter jdbcNamedParameter
    @Override
    visit (oexpr)
    @Override
    visit (rexpr)
    @Override
    visit (jsonExpr)
    @Override
    visit (jsonExpr)
    JsonOperator jsonExpr
    @Override
    visit (var)
    @Override
    visit (bind)
    @Override
    visit (aexpr)
    @Override
    visit (groupConcat)
    MySQLGroupConcat groupConcat
    @Override
    visit (expressionList)
    ExpressionList expressionList
    @Override
    visit (rowConstructor)
    RowConstructor rowConstructor
    @Override
    visit (rowGetExpression)
    RowGetExpression rowGetExpression
    @Override
    visit (hint)
    @Override
    visit (timeKeyExpression)
    TimeKeyExpression timeKeyExpression
    @Override
    visit (literal)
    @Override
    visit (nextVal)
    @Override
    visit (col)
    @Override
    visit (expr)
    @Override
    visit (array)
    @Override
    visit (aThis)
    @Override
    visit (var)
    @Override
    visit (expr)
    @Override
    visit (var)
    @Override
    visit (expression)
    @Override
    visit (expression)
    JsonFunction expression
    @Override
    visit (connectByRootOperator)
    ConnectByRootOperator connectByRootOperator
    @Override
    visit (oracleNamedFunctionParameter)
    OracleNamedFunctionParameter oracleNamedFunctionParameter
    @Override
    visit (allColumns)
    AllColumns allColumns
    @Override
    visit (allTableColumns)
    AllTableColumns allTableColumns
    @Override
    visit (allValue)
    AllValue allValue
    @Override
    visit (isDistinctExpression)
    IsDistinctExpression isDistinctExpression
    @Override
    visit (geometryDistance)
    GeometryDistance geometryDistance
    @Override
    visit (tsqlLeftJoin)
    TSQLLeftJoin tsqlLeftJoin
    @Override
    visit (tsqlRightJoin)
    TSQLRightJoin tsqlRightJoin

    ExpressionListDeParser

    extends: AbstractDeParser

    ExpressionListDeParser (expressionVisitor, builder)
    ExpressionVisitor expressionVisitor
    StringBuilder builder
    @Override
    deParse (expressionList)
    ExpressionList expressionList

    GrantDeParser

    extends: AbstractDeParser

    GrantDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (grant)
    Grant grant

    GroupByDeParser

    extends: AbstractDeParser

    GroupByDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override,| @SuppressWarnings
    deParse (groupBy)

    InsertDeParser

    extends: AbstractDeParser

    InsertDeParser ()
    InsertDeParser (expressionVisitor, selectVisitor, buffer)
    ExpressionVisitor expressionVisitor
    SelectVisitor selectVisitor
    StringBuilder buffer
    @Override,| @SuppressWarnings
    deParse (insert)
    Insert insert
    getExpressionVisitor () → ExpressionVisitor
    getSelectVisitor () → SelectVisitor
    setExpressionVisitor (visitor)
    setSelectVisitor (visitor)

    LimitDeparser

    extends: AbstractDeParser

    LimitDeparser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override
    deParse (limit)
    Limit limit
    getExpressionVisitor () → ExpressionVisitor
    setExpressionVisitor (expressionVisitor)
    ExpressionVisitor expressionVisitor

    MergeDeParser

    extends: AbstractDeParser implements: MergeOperationVisitor

    MergeDeParser (expressionDeParser, selectDeParser, buffer)
    ExpressionDeParser expressionDeParser
    SelectDeParser selectDeParser
    StringBuilder buffer
    @Override
    visit (mergeDelete)
    MergeDelete mergeDelete
    @Override
    visit (mergeUpdate)
    MergeUpdate mergeUpdate
    @Override
    visit (mergeInsert)
    MergeInsert mergeInsert

    OrderByDeParser

    extends: AbstractDeParser

    OrderByDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override
    deParse (orderByElementList)
    List orderByElementList
    deParse (oracleSiblings, orderByElementList)
    boolean oracleSiblings
    List orderByElementList
    deParseElement (orderBy)

    RefreshMaterializedViewStatementDeParser

    extends: AbstractDeParser

    RefreshMaterializedViewStatementDeParser (buffer)
    StringBuilder buffer
    @SuppressWarnings,| @Override
    deParse (view)

    ResetStatementDeParser

    extends: AbstractDeParser

    ResetStatementDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override
    deParse (set)
    getExpressionVisitor () → ExpressionVisitor
    setExpressionVisitor (visitor)

    SelectDeParser

    extends: AbstractDeParser implements: SelectVisitor, SelectItemVisitor, FromItemVisitor, PivotVisitor

    SelectDeParser ()
    SelectDeParser (buffer)
    StringBuilder buffer
    SelectDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override
    visit (selectBody)
    @Override,| @SuppressWarnings
    visit (plainSelect)
    PlainSelect plainSelect
    @Override
    visit (selectExpressionItem)
    SelectItem selectExpressionItem
    @Override
    visit (tableName)
    Table tableName
    @Override
    visit (pivot)
    Pivot pivot
    @Override
    visit (unpivot)
    UnPivot unpivot
    @Override
    visit (pivot)
    PivotXml pivot
    visit (offset)
    Offset offset
    visit (fetch)
    Fetch fetch
    getExpressionVisitor () → ExpressionVisitor
    setExpressionVisitor (visitor)
    @SuppressWarnings
    deparseJoin (join)
    Join join
    deparseLateralView (lateralView)
    LateralView lateralView
    @Override
    visit (list)
    @Override
    visit (withItem)
    WithItem withItem
    @Override
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    @Override
    visit (tableStatement)
    TableStatement tableStatement
    @Override
    visit (tableFunction)
    TableFunction tableFunction
    @Override
    visit (fromItem)
    @Override
    visit (values)
    Values values

    SetStatementDeParser

    extends: AbstractDeParser

    SetStatementDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override
    deParse (set)
    getExpressionVisitor () → ExpressionVisitor
    setExpressionVisitor (visitor)

    ShowColumnsStatementDeParser

    extends: AbstractDeParser

    ShowColumnsStatementDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (show)

    ShowIndexStatementDeParser

    extends: AbstractDeParser

    ShowIndexStatementDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (show)

    ShowStatementDeParser

    extends: AbstractDeParser

    ShowStatementDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (show)

    ShowTablesStatementDeparser

    extends: AbstractDeParser

    ShowTablesStatementDeparser (buffer)
    StringBuilder buffer

    StatementDeParser

    extends: AbstractDeParser implements: StatementVisitor

    StatementDeParser (buffer)
    StringBuilder buffer
    StatementDeParser (expressionDeParser, selectDeParser, buffer)
    ExpressionDeParser expressionDeParser
    SelectDeParser selectDeParser
    StringBuilder buffer
    @Override
    visit (createIndex)
    CreateIndex createIndex
    @Override
    visit (createTable)
    CreateTable createTable
    @Override
    visit (createView)
    CreateView createView
    @Override
    visit (materializedViewStatement)
    RefreshMaterializedViewStatement materializedViewStatement
    @Override
    visit (alterView)
    AlterView alterView
    @Override
    visit (delete)
    Delete delete
    @Override
    visit (drop)
    Drop drop
    @Override
    visit (insert)
    Insert insert
    @Override
    visit (select)
    Select select
    @Override
    visit (truncate)
    Truncate truncate
    @Override
    visit (update)
    Update update
    visit (analyzer)
    Analyze analyzer
    @Override
    visit (alter)
    Alter alter
    @Override
    visit (stmts)
    @Override
    visit (execute)
    Execute execute
    @Override
    visit (set)
    @Override
    visit (reset)
    @SuppressWarnings,| @Override
    visit (merge)
    Merge merge
    @Override
    visit (savepointStatement)
    SavepointStatement savepointStatement
    @Override
    visit (rollbackStatement)
    RollbackStatement rollbackStatement
    @Override
    visit (commit)
    Commit commit
    @Override
    visit (upsert)
    Upsert upsert
    @Override
    visit (use)
    @Override
    visit (show)
    @Override
    visit (showIndexes)
    ShowIndexStatement showIndexes
    @Override
    visit (showTables)
    @Override
    visit (block)
    Block block
    @Override
    visit (comment)
    Comment comment
    @Override
    visit (describe)
    @Override
    visit (explain)
    @Override
    visit (show)
    @Override
    visit (declare)
    @Override
    visit (grant)
    Grant grant
    @Override
    visit (aThis)
    @Override
    visit (createSequence)
    CreateSequence createSequence
    @Override
    visit (alterSequence)
    AlterSequence alterSequence
    @Override
    visit (createFunctionalStatement)
    CreateFunctionalStatement createFunctionalStatement
    @Override
    visit (createSynonym)
    CreateSynonym createSynonym
    @Override
    visit (alterSession)
    AlterSession alterSession
    @Override
    visit (ifElseStatement)
    IfElseStatement ifElseStatement
    @Override
    visit (renameTableStatement)
    RenameTableStatement renameTableStatement
    @Override
    visit (purgeStatement)
    PurgeStatement purgeStatement
    @Override
    visit (alterSystemStatement)
    AlterSystemStatement alterSystemStatement
    @Override
    visit (unsupportedStatement)
    UnsupportedStatement unsupportedStatement

    TableStatementDeParser

    extends: AbstractDeParser implements: SelectVisitor

    TableStatementDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override
    deParse (tableStatement)
    TableStatement tableStatement
    visit (offset)
    Offset offset
    @Override
    visit (parenthesedSelect)
    ParenthesedSelect parenthesedSelect
    @Override
    visit (plainSelect)
    PlainSelect plainSelect
    @Override
    visit (setOpList)
    @Override
    visit (withItem)
    WithItem withItem
    @Override
    visit (aThis)
    Values aThis
    @Override
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    @Override
    visit (tableStatement)
    TableStatement tableStatement

    UpdateDeParser

    extends: AbstractDeParser implements: OrderByVisitor

    UpdateDeParser ()
    UpdateDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override,| @SuppressWarnings
    deParse (update)
    Update update
    getExpressionVisitor () → ExpressionVisitor
    setExpressionVisitor (visitor)
    @Override
    visit (orderBy)

    UpsertDeParser

    extends: AbstractDeParser

    UpsertDeParser (expressionVisitor, selectVisitor, buffer)
    ExpressionDeParser expressionVisitor
    SelectDeParser selectVisitor
    StringBuilder buffer
    @Override,| @SuppressWarnings
    deParse (upsert)
    Upsert upsert
    getExpressionVisitor () → ExpressionVisitor
    getSelectVisitor () → SelectVisitor
    setExpressionVisitor (visitor)
    setSelectVisitor (visitor)

    UseStatementDeParser

    extends: AbstractDeParser

    UseStatementDeParser (buffer)
    StringBuilder buffer
    @Override
    deParse (set)

    ValuesStatementDeParser

    extends: AbstractDeParser

    ValuesStatementDeParser (expressionVisitor, buffer)
    ExpressionVisitor expressionVisitor
    StringBuilder buffer
    @Override
    deParse (values)
    Values values

    util.validation

    ParseException

    extends: ValidationException

    wraps a JSQLParserException to add to the errors collected by validation
    ParseException (message, cause)
    String message
    Throwable cause
    ParseException (message)
    String message
    ParseException (cause)
    Throwable cause

    UnexpectedValidationException

    extends: ValidationException

    can be used on unexpected errors during validation
    UnexpectedValidationException (message, cause)
    String message
    Throwable cause
    UnexpectedValidationException (message)
    String message
    UnexpectedValidationException (cause)
    Throwable cause

    Validation

    extends: Object

    Parses the given statement list with ParseCapability and performs validation with configured ValidationCapability’s. Errors are are reported by calling #validate().
    Validation (capabilities, statements)
    Collection capabilities
    String statements
    Validation (featureConfiguration, capabilities, statements)
    FeatureConfiguration featureConfiguration
    Collection capabilities
    String statements
    validate () → List
    returns List | the errors - may be an empty list.
    getFeatureConfiguration () → FeatureConfiguration
    getCapabilities () → Collection
    returns Collection
    getStatements () → List
    returns List
    getErrors () → List
    returns List
    getParsedStatements () → Statements
    returns Statements
    validate (capabilities, statements) → List
    Collection capabilities
    String statements
    returns List | a list of ValidationError’s
    createValidationContext (config, capabilities) → ValidationContext
    Collection capabilities
    returns ValidationContext | a ValidationContext of the given config and capabilities
    toValidationErrors (statements, parsedStatement, errorMap) → List
    String statements
    Statement parsedStatement
    Map errorMap
    returns List | a list of ValidationError
    validate (statement, context) → Map
    Statement statement
    returns Map | a map mapping the ValidationCapability to a set of `ValidationException`s

    ValidationContext

    extends: Object

    ValidationContext ()
    put (key, value) → ValidationContext
    Object value
    get (key, part) → T
    Class part
    returns T
    getOptional (key, part) → T
    Class part
    returns T
    reinit (reInit) → ValidationContext
    boolean reInit
    setConfiguration (configuration) → ValidationContext
    FeatureConfiguration configuration
    getConfiguration () → FeatureConfiguration
    getAsBoolean (f) → boolean
    Feature f
    returns boolean
    getAsString (f) → String
    Feature f
    returns String
    getCapabilities () → Collection
    returns Collection
    setCapabilities (capabilities) → ValidationContext
    Collection capabilities

    ValidationError

    extends: Object

    ValidationError (statements)
    String statements
    addError (error) → ValidationError
    addErrors (errors) → ValidationError
    Collection errors
    getErrors () → Set
    returns Set | the set of ValidationException’s (no duplicates)
    getCapability () → ValidationCapability
    returns ValidationCapability | the ValidationCapability which produced this error
    getParsedStatement () → Statement
    returns Statement | the parsed Statement, if parsing was possible
    getStatements () → String
    returns String | the statements (may be more than one) given for validation
    setCapability (databaseType)
    setParsedStatement (parsedStatement)
    Statement parsedStatement
    withCapability (databaseType) → ValidationError
    withParsedStatement (parsedStatement) → ValidationError
    Statement parsedStatement
    @Override
    toString () → String
    returns String

    ValidationException

    extends: RuntimeException provides: DatabaseException, ParseException, UnexpectedValidationException

    ValidationException (message, cause)
    String message
    Throwable cause
    ValidationException (message)
    String message
    ValidationException (cause)
    Throwable cause
    @Override
    equals (o) → boolean
    Object o
    returns boolean
    @Override
    hashCode () → int
    returns int
    @Override
    toString () → String
    returns String

    ValidationUtil

    extends: Object

    map (list, fn) → List
    List list
    Function fn
    returns List
    getAlias (alias) → String
    Alias alias
    returns String

    ContextKey

    provides: AllowedTypesContext, FeatureContext, MetadataContext,

    the context key - a ValidationCapability should define constants of expected context - values needed for validation.

    ValidationCapability

    provides: AllowedTypesValidation, DatabaseMetaDataValidation, FeatureSetValidation,

    getName () → String
    returns String | a name of this ValidationCapability
    validate (context, errorConsumer)
    Validate and add ValidationException’s to given consumer.
    Consumer errorConsumer
    toError (message) → ValidationException
    String message
    toError (message, th) → ValidationException
    String message
    Throwable th

    Validator

    provides: AbstractValidator,

    isValid () → boolean
    returns boolean | true, all ValidationCapability’s have no errors
    isValid (capabilities) → boolean
    returns boolean | true, if the given ValidationCapability’s have no errors. false otherwise.
    getValidationErrors () → Map
    returns Map | the ValidationCapability’s requested mapped to a set of error-messages
    getValidationErrors (capabilities) → Map
    returns Map | the filtered view of requested ValidationCapability’s mapped to a set of error-messages
    getValidationErrors (capabilities) → Map
    Collection capabilities
    returns Map | the filtered view of requested ValidationCapability’s mapped to a set of error-messages
    setContext (ctx)
    validate (statement)
    validates given statement.
    S statement

    util.validation.allowedtypes

    AllowedTypesContext

    [allowed_types, argument, allow_null]

    AllowedTypesValidation

    extends: Object implements: ValidationCapability

    AllowedTypesValidation ()
    @Override
    validate (context, errorConsumer)
    Consumer errorConsumer
    @Override
    getName () → String
    returns String

    util.validation.feature

    DatabaseType

    [ANSI_SQL, ORACLE, MYSQL, SQLSERVER, MARIADB, POSTGRESQL, H2]


    The DatabaseType is named like the identifier used within the jdbc-connection-url (upper case), this may change in future, therefore use #get(String) to retrieve the DatabaseType.

    FeatureContext

    [feature]

    H2Version

    [V_1_4_200]

    Please add Features supported and place a link to public documentation

    MariaDbVersion

    [V10_5_4, ORACLE_MODE]

    Please add Features supported and place a link to public documentation

    MySqlVersion

    [V8_0]

    Please add Features supported and place a link to public documentation

    OracleVersion

    [V19C]

    Please add Features supported and place a link to public documentation

    PostgresqlVersion

    [V10, V11, V12, V13, V14]

    Please add Features supported and place a link to public documentation

    SQLVersion

    [SQL1986, SQL1989, SQL1992, SQL1999, SQL2003, SQL2006, SQL2008, SQL2011, SQL2016, SQL2019]

    Enum containing the ANSI SQL Standard Versions - features are not guaranteed to be complete, just add them if you are sure they are part of the standard :)

    SqlServerVersion

    [V2019]

    Please add Features supported and place a link to public documentation

    FeaturesAllowed

    extends: Object implements: FeatureSetValidation, ModifyableFeatureSet

    Privileges/Features allowed
    FeaturesAllowed (features)
    Feature features
    FeaturesAllowed (name, features)
    String name
    Feature features
    @Override
    add (featureSets) → FeaturesAllowed
    FeatureSet featureSets
    returns FeaturesAllowed | this
    @Override
    add (features) → FeaturesAllowed
    Feature features
    returns FeaturesAllowed | this
    @Override
    add (features) → FeaturesAllowed
    Collection features
    returns FeaturesAllowed | this
    @Override
    remove (featureSets) → FeaturesAllowed
    FeatureSet featureSets
    returns FeaturesAllowed | this
    @Override
    remove (features) → FeaturesAllowed
    Feature features
    returns FeaturesAllowed | this
    @Override
    remove (features) → FeaturesAllowed
    Collection features
    returns FeaturesAllowed | this
    @Override
    copy () → FeaturesAllowed
    returns FeaturesAllowed | returns a modifiable copy of this FeaturesAllowed object
    @Override
    unmodifyable () → FeaturesAllowed
    makes the inner Feature-set unmodifiable
    returns FeaturesAllowed | this
    @Override
    getMessage (feature) → ValidationException
    Feature feature
    returns ValidationException | featureName + " not allowed."
    @Override
    getName () → String
    returns String
    @Override
    getFeatures () → Set
    returns Set

    FeatureSetValidation

    implements: ValidationCapability, FeatureSet provides: DatabaseType, FeaturesAllowed, Version,

    @Override
    validate (context, errorConsumer)
    Consumer errorConsumer
    @Override
    getFeatures () → Set
    returns Set | all supported Feature’s
    getMessage (feature) → ValidationException
    Feature feature
    returns ValidationException | the default message if not contained in the feature set
    @Override
    getName () → String
    returns String

    Version

    implements: FeatureSetValidation provides: DatabaseType, H2Version, MariaDbVersion, MySqlVersion, OracleVersion, PostgresqlVersion, SQLVersion, SqlServerVersion,

    getVersionString () → String
    returns String | the version string
    @Override
    getMessage (feature) → ValidationException
    Feature feature
    returns ValidationException | featureName + " not supported."

    util.validation.metadata

    MetadataContext

    [named, exists]

    NamedObject

    [database, schema, table, view, column, index, constraint, uniqueConstraint, sequence, synonym, procedure, user, role, trigger, alias]

    NamesLookup

    [UPPERCASE, LOWERCASE, NO_TRANSFORMATION]

    A strategy for transformation of database-names before lookup in database-catalog-metadata

    AbstractDatabaseMetaDataCapability

    extends: Object implements: DatabaseMetaDataValidation provides: JdbcDatabaseMetaDataCapability

    Adapter class always throwing UnsupportedOperationException for all exists - methods.
    AbstractDatabaseMetaDataCapability (connection, namesLookup)
    With caching enabled - see #isCacheResults()
    Connection connection
    UnaryOperator namesLookup | namesLookup - see NamesLookup
    AbstractDatabaseMetaDataCapability (connection, namesLookup, cacheResults)
    Connection connection
    UnaryOperator namesLookup | namesLookup - see NamesLookup
    boolean cacheResults | cacheResults - whether the results should be cached for later lookups
    getNamesLookup () → UnaryOperator
    returns UnaryOperator
    getConnection () → Connection
    returns Connection
    isCacheResults () → boolean
    returns boolean
    @Override,| @SuppressWarnings
    exists (named) → boolean
    Named named
    returns boolean
    Named named
    BiPredicate fn
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Map results
    Named name
    returns boolean
    Named name
    returns UnsupportedOperationException

    DatabaseException

    extends: ValidationException

    database-errors wrapping a SQLException or PersistenceException
    DatabaseException (message, cause)
    String message
    Throwable cause
    DatabaseException (message)
    String message
    DatabaseException (cause)
    Throwable cause

    JdbcDatabaseMetaDataCapability

    extends: AbstractDatabaseMetaDataCapability

    Validates against schema by jdbc-metadata in a very basic way with simple caching and comparing names by String#equalsIgnoreCase(String)
    JdbcDatabaseMetaDataCapability (connection, namesLookup)
    Connection connection
    UnaryOperator namesLookup | namesLookup - see NamesLookup
    JdbcDatabaseMetaDataCapability (connection, namesLookup, cacheResults)
    Connection connection
    UnaryOperator namesLookup | namesLookup - see NamesLookup
    boolean cacheResults | cacheResults - whether the results should be cached for later lookups
    Map results
    Named named
    returns boolean

    PMD.CyclomaticComplexity

    Map results
    Named named
    returns boolean
    Map results
    Named named
    returns boolean
    Named named
    String part
    returns boolean

    PMD.CyclomaticComplexity

    Named

    extends: Object

    Named (namedObject, fqn)
    NamedObject namedObject
    String fqn
    getFqn () → String
    returns String
    getAlias () → String
    returns String
    setAlias (alias) → Named
    String alias
    returns Named
    getNamedObject () → NamedObject
    returns NamedObject
    getParents () → List
    returns List
    setParents (parents) → Named
    List parents
    returns Named
    setFqnLookup (fqnLookup) → Named
    String fqnLookup
    returns Named
    setAliasLookup (aliasLookup) → Named
    String aliasLookup
    returns Named
    getFqnLookup () → String
    returns String | the fqn transformed for catalog-lookup (uppercase/lowercase/.. depends on database)
    getAliasLookup () → String
    returns String | the alias transformed for catalog-lookup (uppercase/lowercase/.. depends on database)
    @Override
    hashCode () → int
    returns int
    @Override
    equals (obj) → boolean
    Object obj
    returns boolean
    @Override
    toString () → String
    returns String

    DatabaseMetaDataValidation

    implements: ValidationCapability provides: AbstractDatabaseMetaDataCapability,

    @Override
    validate (context, errorConsumer)
    Consumer errorConsumer
    exists (named) → boolean
    Named named
    returns boolean | true, if the object exists, false otherwise.
    getErrorMessage (named, checkForExists) → ValidationException
    Named named
    boolean checkForExists
    returns ValidationException | a new ValidationException
    getUnexpectedErrorMessage (named, cause) → ValidationException
    Named named
    Exception cause
    returns ValidationException | a new ValidationException
    @Override
    getName () → String
    returns String

    util.validation.validator

    AbstractValidator

    extends: Object implements: Validator provides: AlterSequenceValidator, AlterSessionValidator, AlterValidator, AlterViewValidator, AnalyzeValidator, CreateIndexValidator, CreateSequenceValidator, CreateSynonymValidator, CreateTableValidator, CreateViewValidator, DeclareStatementValidator, DeleteValidator, DropValidator, ExecuteValidator, ExpressionValidator, GrantValidator, GroupByValidator, InsertValidator, LimitValidator, MergeValidator, OrderByValidator, RefreshMaterializedViewStatementValidator, ResetStatementValidator, SelectValidator, SetStatementValidator, ShowColumnsStatementValidator, ShowIndexStatementValidator, ShowStatementValidator, ShowTablesStatementValidator, StatementValidator, TableStatementValidator, UpdateValidator, UpsertValidator, UseStatementValidator, ValuesStatementValidator

    A abstract base for a Validation
    AbstractValidator ()
    getValidator (part) → T
    Class part
    returns T
    returns Consumer
    boolean reInit

    adds an error for this {@link ValidationCapability}

    returns void
    @Override
    getValidationErrors () → Map
    returns Map
    getCapabilities () → Collection
    returns Collection
    @Override
    setContext (context)
    E element
    Consumer elementConsumer
    returns void
    List elementList
    Supplier validatorSupplier
    BiConsumer elementConsumer
    returns void
    Expression expression
    returns void
    Expression expression
    returns void
    List expressions
    returns void
    FromItem fromItems
    returns void
    List fromItems
    returns void
    List orderByElements
    returns void
    FromItem fromItem
    returns void
    FromItem fromItem
    returns void

    Iterates through all {@link ValidationCapability} and validates the feature with

    {@link #validateFeature(ValidationCapability, Feature)}

    Feature feature
    returns void

    Iterates through all {@link ValidationCapability} and validates

    <ul> <li>the name with {@link #validateName(ValidationCapability, NamedObject, String)}</li> <li>the feature with {@link #validateFeature(ValidationCapability, Feature)}</li> </ul>

    Feature feature
    NamedObject namedObject
    String fqn | fqn - fully qualified name of named object
    returns void

    Iterates through all {@link ValidationCapability} and validates

    <ul> <li>the name with {@link #validateName(ValidationCapability, NamedObject, String)}</li> <li>the feature with {@link #validateFeature(ValidationCapability, Feature)}</li> </ul>

    Feature feature
    NamedObject namedObject
    String fqn | fqn - fully qualified name of named object
    String alias
    returns void

    Iterates through all {@link ValidationCapability} and validates for the name with

    {@link #validateName(ValidationCapability, NamedObject, String)}

    NamedObject namedObject
    String fqn | fqn - fully qualified name of named object
    returns void

    Iterates through all {@link ValidationCapability} and validates for the name with

    {@link #validateName(ValidationCapability, NamedObject, String)}

    NamedObject namedObject
    String fqn | fqn - fully qualified name of named object
    String alias
    returns void

    Validates the feature if given {@link ValidationCapability} is a {@link FeatureSetValidation}

    and condition is <code>true</code>

    boolean condition
    Feature feature
    returns void

    validates for the feature if given elements is not empty - see

    {@link #isNotEmpty(Collection)}

    List elements
    Feature feature
    returns void

    Validates for the feature if given element is not <code>null</code>

    Object element
    Feature feature
    returns void

    Validates if given {@link ValidationCapability} is a {@link FeatureSetValidation}

    Feature feature
    returns void

    Validates if given {@link ValidationCapability} is a {@link DatabaseMetaDataValidation}

    NamedObject namedObject
    String fqn | fqn - fully qualified name of named object
    String alias
    returns void
    NamedObject namedObject
    String fqn | fqn - fully qualified name of named object
    returns void

    Validates if given {@link ValidationCapability} is a {@link DatabaseMetaDataValidation}

    NamedObject namedObject
    String fqn | fqn - fully qualified name of named object
    String alias
    boolean exists | exists - true, check for existence, false, check for non-existence
    NamedObject parents
    returns void
    NamedObject namedObject
    String fqn | fqn - fully qualified name of named object
    boolean exists
    NamedObject parents
    returns void
    String name
    returns void
    String name
    String alias
    returns void
    List columnNames
    NamedObject parents
    returns void
    List columnNames
    boolean exists
    NamedObject parents
    returns void
    NamedObject namedObject
    String name
    String alias
    NamedObject parents
    returns void
    NamedObject namedObject
    String name
    NamedObject parents
    returns void
    NamedObject namedObject
    String name
    String alias
    boolean exists
    NamedObject parents
    returns void
    Collection c
    returns boolean
    String c
    returns boolean

    AlterSequenceValidator

    extends: AbstractValidator

    AlterSequenceValidator ()
    @Override
    validate (statement)
    AlterSequence statement

    AlterSessionValidator

    extends: AbstractValidator

    AlterSessionValidator ()
    @Override
    validate (statement)
    AlterSession statement

    AlterValidator

    extends: AbstractValidator

    AlterValidator ()
    @Override
    validate (alter)
    Alter alter
    validate (alter, e)

    AlterViewValidator

    extends: AbstractValidator

    AlterViewValidator ()
    @Override
    validate (alterView)
    AlterView alterView

    AnalyzeValidator

    extends: AbstractValidator

    AnalyzeValidator ()
    @Override
    validate (analyze)
    Analyze analyze

    CreateIndexValidator

    extends: AbstractValidator

    CreateIndexValidator ()
    @Override
    validate (createIndex)
    CreateIndex createIndex

    CreateSequenceValidator

    extends: AbstractValidator

    CreateSequenceValidator ()
    @Override
    validate (statement)
    CreateSequence statement

    CreateSynonymValidator

    extends: AbstractValidator

    CreateSynonymValidator ()
    @Override
    validate (statement)
    CreateSynonym statement

    CreateTableValidator

    extends: AbstractValidator

    CreateTableValidator ()
    @Override
    validate (createTable)
    CreateTable createTable

    CreateViewValidator

    extends: AbstractValidator

    CreateViewValidator ()
    @Override
    validate (createView)
    CreateView createView

    DeclareStatementValidator

    extends: AbstractValidator

    DeclareStatementValidator ()
    @Override
    validate (declare)

    DeleteValidator

    extends: AbstractValidator

    DeleteValidator ()
    @Override
    validate (delete)
    Delete delete

    DropValidator

    extends: AbstractValidator

    DropValidator ()
    @Override
    validate (drop)
    Drop drop

    ExecuteValidator

    extends: AbstractValidator

    ExecuteValidator ()
    @Override
    validate (execute)
    Execute execute

    ExpressionValidator

    extends: AbstractValidator implements: ExpressionVisitor

    ExpressionValidator ()
    @Override
    visit (addition)
    Addition addition
    @Override
    visit (andExpression)
    AndExpression andExpression
    @Override
    visit (between)
    Between between
    @Override
    visit (overlapsCondition)
    OverlapsCondition overlapsCondition
    @Override
    visit (equalsTo)
    EqualsTo equalsTo
    @Override
    visit (division)
    Division division
    @Override
    visit (division)
    @Override
    visit (doubleValue)
    DoubleValue doubleValue
    @Override
    visit (hexValue)
    HexValue hexValue
    @Override
    visit (notExpr)
    @Override
    visit (expr)
    @Override
    visit (expr)
    visitOldOracleJoinBinaryExpression (expression, operator)
    String operator
    @Override
    visit (greaterThan)
    GreaterThan greaterThan
    @Override
    visit (greaterThanEquals)
    GreaterThanEquals greaterThanEquals
    @Override
    visit (inExpression)
    InExpression inExpression
    @Override
    visit (fullTextSearch)
    FullTextSearch fullTextSearch
    @Override
    visit (signedExpression)
    SignedExpression signedExpression
    @Override
    visit (isNullExpression)
    IsNullExpression isNullExpression
    @Override
    visit (isBooleanExpression)
    IsBooleanExpression isBooleanExpression
    @Override
    visit (jdbcParameter)
    JdbcParameter jdbcParameter
    @Override
    visit (likeExpression)
    LikeExpression likeExpression
    @Override
    visit (existsExpression)
    ExistsExpression existsExpression
    @Override
    visit (memberOfExpression)
    MemberOfExpression memberOfExpression
    @Override
    visit (longValue)
    LongValue longValue
    @Override
    visit (minorThan)
    MinorThan minorThan
    @Override
    visit (minorThanEquals)
    MinorThanEquals minorThanEquals
    @Override
    visit (multiplication)
    Multiplication multiplication
    @Override
    visit (notEqualsTo)
    NotEqualsTo notEqualsTo
    @Override
    visit (doubleAnd)
    DoubleAnd doubleAnd
    @Override
    visit (contains)
    Contains contains
    @Override
    visit (containedBy)
    ContainedBy containedBy
    @Override
    visit (nullValue)
    NullValue nullValue
    @Override
    visit (orExpression)
    OrExpression orExpression
    @Override
    visit (xorExpression)
    XorExpression xorExpression
    @Override
    visit (parenthesis)
    Parenthesis parenthesis
    @Override
    visit (stringValue)
    StringValue stringValue
    @Override
    visit (subtraction)
    Subtraction subtraction
    BinaryExpression binaryExpression
    String operator
    returns void
    @Override
    visit (selectBody)
    @Override
    visit (tableColumn)
    Column tableColumn
    @Override
    visit (function)
    Function function
    @Override
    visit (dateValue)
    DateValue dateValue
    @Override
    visit (timestampValue)
    TimestampValue timestampValue
    @Override
    visit (timeValue)
    TimeValue timeValue
    @Override
    visit (caseExpression)
    CaseExpression caseExpression
    @Override
    visit (whenClause)
    WhenClause whenClause
    @Override
    visit (anyComparisonExpression)
    AnyComparisonExpression anyComparisonExpression
    @Override
    visit (concat)
    Concat concat
    @Override
    visit (matches)
    Matches matches
    @Override
    visit (bitwiseAnd)
    BitwiseAnd bitwiseAnd
    @Override
    visit (bitwiseOr)
    BitwiseOr bitwiseOr
    @Override
    visit (bitwiseXor)
    BitwiseXor bitwiseXor
    @Override
    visit (cast)
    @Override
    visit (modulo)
    Modulo modulo
    @Override
    visit (aexpr)
    @Override
    visit (eexpr)
    @Override
    visit (iexpr)
    @Override
    visit (jdbcNamedParameter)
    JdbcNamedParameter jdbcNamedParameter
    @Override
    visit (oexpr)
    @Override
    visit (rexpr)
    @Override
    visit (jsonExpr)
    @Override
    visit (jsonExpr)
    JsonOperator jsonExpr
    @Override
    visit (var)
    @Override
    visit (bind)
    @Override
    visit (aexpr)
    @Override
    visit (groupConcat)
    MySQLGroupConcat groupConcat
    @Override
    visit (expressionList)
    ExpressionList expressionList
    @Override
    visit (rowConstructor)
    RowConstructor rowConstructor
    @Override
    visit (rowGetExpression)
    RowGetExpression rowGetExpression
    @Override
    visit (hint)
    @Override
    visit (timeKeyExpression)
    TimeKeyExpression timeKeyExpression
    @Override
    visit (literal)
    @Override
    visit (nextVal)
    @Override
    visit (col)
    @Override
    visit (expr)
    @Override
    visit (array)
    @Override
    visit (aThis)
    @Override
    validate (expression)
    Expression expression
    @Override
    visit (a)
    @Override
    visit (a)
    @Override
    visit (xml)
    @Override
    visit (expression)
    @Override
    visit (expression)
    JsonFunction expression
    @Override
    visit (connectByRootOperator)
    ConnectByRootOperator connectByRootOperator
    @Override
    visit (oracleNamedFunctionParameter)
    OracleNamedFunctionParameter oracleNamedFunctionParameter
    @Override
    visit (allColumns)
    AllColumns allColumns
    @Override
    visit (allTableColumns)
    AllTableColumns allTableColumns
    @Override
    visit (allValue)
    AllValue allValue
    @Override
    visit (isDistinctExpression)
    IsDistinctExpression isDistinctExpression
    @Override
    visit (geometryDistance)
    GeometryDistance geometryDistance
    @Override
    visit (selectBody)
    Select selectBody
    @Override
    visit (transcodingFunction)
    TranscodingFunction transcodingFunction
    @Override
    visit (trimFunction)
    TrimFunction trimFunction
    @Override
    visit (rangeExpression)
    RangeExpression rangeExpression
    @Override
    visit (tsqlLeftJoin)
    TSQLLeftJoin tsqlLeftJoin
    @Override
    visit (tsqlRightJoin)
    TSQLRightJoin tsqlRightJoin

    GrantValidator

    extends: AbstractValidator

    GrantValidator ()
    @Override
    validate (grant)
    Grant grant

    GroupByValidator

    extends: AbstractValidator implements: GroupByVisitor

    GroupByValidator ()
    @Override
    validate (groupBy)
    @Override
    visit (groupBy)

    InsertValidator

    extends: AbstractValidator

    InsertValidator ()
    @Override
    validate (insert)
    Insert insert

    LimitValidator

    extends: AbstractValidator

    LimitValidator ()
    @Override
    validate (limit)
    Limit limit

    MergeValidator

    extends: AbstractValidator implements: MergeOperationVisitor

    MergeValidator ()
    @Override
    validate (merge)
    Merge merge
    @Override
    visit (mergeDelete)
    MergeDelete mergeDelete
    @Override
    visit (mergeUpdate)
    MergeUpdate mergeUpdate
    @Override
    visit (mergeInsert)
    MergeInsert mergeInsert

    OrderByValidator

    extends: AbstractValidator implements: OrderByVisitor

    OrderByValidator ()
    @Override
    validate (element)
    @Override
    visit (orderBy)

    RefreshMaterializedViewStatementValidator

    extends: AbstractValidator

    RefreshMaterializedViewStatementValidator ()
    @Override
    validate (viewStatement)

    ReplaceValidator

    extends: UpsertValidator

    ReplaceValidator ()

    ResetStatementValidator

    extends: AbstractValidator

    ResetStatementValidator ()
    @Override
    validate (reset)

    SelectValidator

    extends: AbstractValidator implements: SelectVisitor, SelectItemVisitor, FromItemVisitor, PivotVisitor

    SelectValidator ()
    @SuppressWarnings,| @Override
    visit (plainSelect)
    PlainSelect plainSelect
    @Override
    visit (selectExpressionItem)
    SelectItem selectExpressionItem
    @Override
    visit (selectBody)
    @Override
    visit (table)
    Table table
    @Override
    visit (pivot)
    Pivot pivot
    @Override
    visit (unpivot)
    UnPivot unpivot
    @Override
    visit (pivot)
    PivotXml pivot
    validateOffset (offset)
    Offset offset
    validateFetch (fetch)
    Fetch fetch
    validateOptionalJoins (joins)
    List joins
    validateOptionalJoin (join)
    Join join
    @Override
    visit (setOperation)
    SetOperationList setOperation
    @Override
    visit (withItem)
    WithItem withItem
    @Override
    visit (lateralSubSelect)
    LateralSubSelect lateralSubSelect
    @Override
    visit (tableStatement)
    TableStatement tableStatement
    @Override
    visit (tableFunction)
    TableFunction tableFunction
    @Override
    visit (parenthesis)
    @Override
    visit (values)
    Values values
    @Override
    validate (statement)
    SelectItem statement

    SetStatementValidator

    extends: AbstractValidator

    SetStatementValidator ()
    @Override
    validate (set)

    ShowColumnsStatementValidator

    extends: AbstractValidator

    ShowColumnsStatementValidator ()
    @Override
    validate (show)

    ShowIndexStatementValidator

    extends: AbstractValidator

    ShowIndexStatementValidator ()
    @Override
    validate (show)

    ShowStatementValidator

    extends: AbstractValidator

    ShowStatementValidator ()
    @Override
    validate (show)

    ShowTablesStatementValidator

    extends: AbstractValidator

    ShowTablesStatementValidator ()
    @Override
    validate (show)

    StatementValidator

    extends: AbstractValidator implements: StatementVisitor

    StatementValidator ()
    @Override
    visit (createIndex)
    CreateIndex createIndex
    @Override
    visit (createTable)
    CreateTable createTable
    @Override
    visit (createView)
    CreateView createView
    @Override
    visit (alterView)
    AlterView alterView
    @Override
    visit (materializedView)
    @Override
    visit (delete)
    Delete delete
    @Override
    visit (drop)
    Drop drop
    @Override
    visit (insert)
    Insert insert
    @Override
    visit (select)
    Select select
    @Override
    visit (truncate)
    Truncate truncate
    @Override
    visit (update)
    Update update
    @Override
    visit (alter)
    Alter alter
    @Override
    visit (stmts)
    @Override
    visit (execute)
    Execute execute
    @Override
    visit (set)
    @Override
    visit (reset)
    @Override
    visit (merge)
    Merge merge
    @Override
    visit (commit)
    Commit commit
    @Override
    visit (upsert)
    Upsert upsert
    @Override
    visit (use)
    @Override
    visit (show)
    @Override
    visit (show)
    @Override
    visit (show)
    @Override
    visit (showTables)
    @Override
    visit (block)
    Block block
    @Override
    visit (comment)
    Comment comment
    @Override
    visit (describe)
    @Override
    visit (explain)
    @Override
    visit (declare)
    @Override
    visit (grant)
    Grant grant
    @Override
    visit (aThis)
    @Override
    visit (createSequence)
    CreateSequence createSequence
    @Override
    visit (alterSequence)
    AlterSequence alterSequence
    @Override
    visit (createFunctionalStatement)
    CreateFunctionalStatement createFunctionalStatement
    @Override
    validate (statement)
    Statement statement
    @Override
    visit (createSynonym)
    CreateSynonym createSynonym
    @Override
    visit (analyze)
    Analyze analyze
    @Override
    visit (savepointStatement)
    SavepointStatement savepointStatement
    @Override
    visit (rollbackStatement)
    RollbackStatement rollbackStatement
    @Override
    visit (alterSession)
    AlterSession alterSession
    @Override
    visit (ifElseStatement)
    IfElseStatement ifElseStatement
    visit (renameTableStatement)
    RenameTableStatement renameTableStatement
    @Override
    visit (purgeStatement)
    PurgeStatement purgeStatement
    @Override
    visit (alterSystemStatement)
    AlterSystemStatement alterSystemStatement
    @Override
    visit (unsupportedStatement)
    UnsupportedStatement unsupportedStatement

    TableStatementValidator

    extends: AbstractValidator

    TableStatementValidator ()
    @Override
    validate (statement)
    TableStatement statement

    UpdateValidator

    extends: AbstractValidator

    UpdateValidator ()
    @Override
    validate (update)
    Update update

    UpsertValidator

    extends: AbstractValidator provides: ReplaceValidator

    UpsertValidator ()
    @Override
    validate (upsert)
    Upsert upsert

    UseStatementValidator

    extends: AbstractValidator

    UseStatementValidator ()
    @Override
    validate (set)

    ValuesStatementValidator

    extends: AbstractValidator

    ValuesStatementValidator ()
    @Override
    validate (values)
    Values values