Uses of Class
com.exasol.adapter.sql.SqlNode

Packages that use SqlNode

Package	Description
com.exasol.adapter.request.parser
com.exasol.adapter.sql

Uses of SqlNode in com.exasol.adapter.request.parser

Methods in com.exasol.adapter.request.parser that return SqlNode

Modifier and Type	Method	Description
SqlNode	PushdownSqlParser.parseExpression(javax.json.JsonObject expression)

Uses of SqlNode in com.exasol.adapter.sql

Subclasses of SqlNode in com.exasol.adapter.sql

Modifier and Type	Class	Description
class	AbstractSqlBinaryEquality
class	AbstractSqlPredicateJson	This class contains a common behavior for the SqlNodeType.PREDICATE_IS_JSON and SqlNodeType.PREDICATE_IS_NOT_JSON predicates.
class	SqlColumn
class	SqlExpressionList
class	SqlFunctionAggregate	A simple aggregate function with a name and zero or more arguments.
class	SqlFunctionAggregateGroupConcat	Represents a GROUP_CONCAT aggregate function.
class	SqlFunctionAggregateListagg	Represents a LISTAGG aggregate function.
class	SqlFunctionScalar	A simple scalar function with a name and zero or more arguments.
class	SqlFunctionScalarCase
class	SqlFunctionScalarCast
class	SqlFunctionScalarExtract
class	SqlFunctionScalarJsonValue	This class represents the ScalarFunction.JSON_VALUE scalar function.
class	SqlGroupBy
class	SqlJoin
class	SqlLimit
class	SqlLiteralBool
class	SqlLiteralDate
class	SqlLiteralDouble
class	SqlLiteralExactnumeric
class	SqlLiteralInterval
class	SqlLiteralNull
class	SqlLiteralString
class	SqlLiteralTimestamp
class	SqlLiteralTimestampUtc
class	SqlOrderBy
class	SqlPredicate
class	SqlPredicateAnd
class	SqlPredicateBetween
class	SqlPredicateEqual
class	SqlPredicateInConstList
class	SqlPredicateIsJson	This class represents the Predicate.IS_JSON predicate.
class	SqlPredicateIsNotJson	This class represents the Predicate.IS_NOT_JSON predicate.
class	SqlPredicateIsNotNull
class	SqlPredicateIsNull
class	SqlPredicateLess
class	SqlPredicateLessEqual
class	SqlPredicateLike
class	SqlPredicateLikeRegexp
class	SqlPredicateNot
class	SqlPredicateNotEqual
class	SqlPredicateOr
class	SqlSelectList
class	SqlStatement
class	SqlStatementSelect	We could consider to apply builder pattern here (if time)
class	SqlTable

Fields in com.exasol.adapter.sql declared as SqlNode

Modifier and Type	Field	Description
protected SqlNode	AbstractSqlPredicateJson.expression

Methods in com.exasol.adapter.sql that return SqlNode

Modifier and Type	Method	Description
SqlNode	SqlFunctionAggregateGroupConcat.getArgument()	Get a function argument.
SqlNode	SqlFunctionAggregateListagg.getArgument()	Get a function argument.
SqlNode	SqlFunctionScalarCast.getArgument()
SqlNode	SqlFunctionScalarExtract.getArgument()
SqlNode	SqlFunctionScalarCase.getBasis()
SqlNode	SqlPredicateBetween.getBetweenLeft()
SqlNode	SqlPredicateBetween.getBetweenRight()
SqlNode	SqlJoin.getCondition()
SqlNode	SqlPredicateLike.getEscapeChar()
SqlNode	AbstractSqlPredicateJson.getExpression()
SqlNode	SqlPredicateBetween.getExpression()
SqlNode	SqlPredicateInConstList.getExpression()
SqlNode	SqlPredicateIsNotNull.getExpression()
SqlNode	SqlPredicateIsNull.getExpression()
SqlNode	SqlPredicateNot.getExpression()
SqlNode	SqlStatementSelect.getFromClause()
SqlNode	SqlStatementSelect.getHaving()
SqlNode	AbstractSqlBinaryEquality.getLeft()
SqlNode	SqlJoin.getLeft()
SqlNode	SqlPredicateLike.getLeft()
SqlNode	SqlPredicateLikeRegexp.getLeft()
SqlNode	SqlNode.getParent()
SqlNode	SqlPredicateLike.getPattern()
SqlNode	SqlPredicateLikeRegexp.getPattern()
SqlNode	AbstractSqlBinaryEquality.getRight()
SqlNode	SqlJoin.getRight()
SqlNode	SqlStatementSelect.getWhereClause()

Methods in com.exasol.adapter.sql that return types with arguments of type SqlNode

Modifier and Type	Method	Description
List<SqlNode>	SqlPredicateAnd.getAndedPredicates()
List<SqlNode>	SqlFunctionAggregate.getArguments()
List<SqlNode>	SqlFunctionScalar.getArguments()
List<SqlNode>	SqlFunctionScalarCase.getArguments()
List<SqlNode>	SqlFunctionScalarJsonValue.getArguments()
Optional<SqlNode>	SqlFunctionScalarJsonValue.Behavior.getExpression()
List<SqlNode>	SqlExpressionList.getExpressions()
List<SqlNode>	SqlOrderBy.getExpressions()
List<SqlNode>	SqlPredicateInConstList.getInArguments()
List<SqlNode>	SqlPredicateOr.getOrPredicates()
List<SqlNode>	SqlFunctionScalarCase.getResults()

Methods in com.exasol.adapter.sql with parameters of type SqlNode

Modifier and Type	Method	Description
static SqlFunctionAggregateGroupConcat.Builder	SqlFunctionAggregateGroupConcat.builder(SqlNode argument)	Get a SqlFunctionAggregateGroupConcat builder.
static SqlFunctionAggregateListagg.Builder	SqlFunctionAggregateListagg.builder(SqlNode argument, SqlFunctionAggregateListagg.Behavior overflowBehavior)	Get a SqlFunctionAggregateListagg builder.
SqlStatementSelect.Builder	SqlStatementSelect.Builder.fromClause(SqlNode fromClause)	Set the from clause of the SQL Select Statement.
SqlStatementSelect.Builder	SqlStatementSelect.Builder.having(SqlNode having)	Set the having clause of the SQL Select Statement.
void	SqlNode.setParent(SqlNode parent)
SqlStatementSelect.Builder	SqlStatementSelect.Builder.whereClause(SqlNode whereClause)	Set the where clause of the SQL Select Statement.

Method parameters in com.exasol.adapter.sql with type arguments of type SqlNode

Modifier and Type	Method	Description
static SqlSelectList	SqlSelectList.createRegularSelectList(List<SqlNode> selectList)	Creates a regular SqlSelectList.

Constructors in com.exasol.adapter.sql with parameters of type SqlNode

Constructor	Description
AbstractSqlBinaryEquality(Predicate function, SqlNode left, SqlNode right)
AbstractSqlPredicateJson(Predicate predicate, SqlNode expression, AbstractSqlPredicateJson.TypeConstraints typeConstraint, AbstractSqlPredicateJson.KeyUniquenessConstraint keyUniquenessConstraint)
SqlFunctionScalarCase(List<SqlNode> arguments, List<SqlNode> results, SqlNode basis)
SqlFunctionScalarCast(DataType dataType, SqlNode argument)
SqlFunctionScalarExtract(SqlFunctionScalarExtract.ExtractParameter extractParameter, SqlNode argument)
SqlJoin(SqlNode left, SqlNode right, SqlNode condition, JoinType joinType)
SqlPredicateBetween(SqlNode expression, SqlNode betweenLeft, SqlNode betweenRight)
SqlPredicateEqual(SqlNode left, SqlNode right)
SqlPredicateInConstList(SqlNode expression, List<SqlNode> inArguments)	Create a new instance of SqlPredicateInConstList.
SqlPredicateIsJson(SqlNode expression, AbstractSqlPredicateJson.TypeConstraints typeConstraint, AbstractSqlPredicateJson.KeyUniquenessConstraint keyUniquenessConstraint)
SqlPredicateIsNotJson(SqlNode expression, AbstractSqlPredicateJson.TypeConstraints typeConstraint, AbstractSqlPredicateJson.KeyUniquenessConstraint keyUniquenessConstraint)
SqlPredicateIsNotNull(SqlNode expression)
SqlPredicateIsNull(SqlNode expression)
SqlPredicateLess(SqlNode left, SqlNode right)
SqlPredicateLessEqual(SqlNode left, SqlNode right)
SqlPredicateLike(SqlNode left, SqlNode pattern)
SqlPredicateLike(SqlNode left, SqlNode pattern, SqlNode escapeChar)
SqlPredicateLikeRegexp(SqlNode left, SqlNode pattern)
SqlPredicateNot(SqlNode expression)
SqlPredicateNotEqual(SqlNode left, SqlNode right)

Constructor parameters in com.exasol.adapter.sql with type arguments of type SqlNode

Constructor	Description
Behavior(SqlFunctionScalarJsonValue.BehaviorType behaviorType, Optional<SqlNode> expression)
SqlExpressionList(List<SqlNode> expressions)
SqlFunctionAggregate(AggregateFunction function, List<SqlNode> arguments, boolean distinct)
SqlFunctionScalar(ScalarFunction function, List<SqlNode> arguments)
SqlFunctionScalarCase(List<SqlNode> arguments, List<SqlNode> results, SqlNode basis)
SqlFunctionScalarJsonValue(ScalarFunction scalarFunction, List<SqlNode> arguments, DataType returningDataType, SqlFunctionScalarJsonValue.Behavior emptyBehavior, SqlFunctionScalarJsonValue.Behavior errorBehavior)
SqlGroupBy(List<SqlNode> groupByList)
SqlOrderBy(List<SqlNode> expressions, List<Boolean> isAsc, List<Boolean> nullsFirst)
SqlPredicateAnd(List<SqlNode> andedPredicates)
SqlPredicateInConstList(SqlNode expression, List<SqlNode> inArguments)	Create a new instance of SqlPredicateInConstList.
SqlPredicateOr(List<SqlNode> orPredicates)