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

Packages that use SqlNode

Package	Description
com.exasol.adapter.request.parser
com.exasol.adapter.request.renderer
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(jakarta.json.JsonObject expression)	Parse an expression.

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

Methods in com.exasol.adapter.request.renderer with parameters of type SqlNode

Modifier and Type	Method	Description
jakarta.json.JsonValue	PushdownSqlRenderer.render(SqlNode node)	Serialize a SqlNode to JSON.

Uses of SqlNode in com.exasol.adapter.sql

Subclasses of SqlNode in com.exasol.adapter.sql

Modifier and Type	Class	Description
class	AbstractSqlBinaryEquality	Abstract base for comparison operators with two operands.
class	AbstractSqlPredicateJson	This class contains a common behavior for the SqlNodeType.PREDICATE_IS_JSON and SqlNodeType.PREDICATE_IS_NOT_JSON predicates.
class	SqlColumn	A SQL column.
class	SqlExpressionList	SQL expression list.
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	CASE function.
class	SqlFunctionScalarCast	The type Sql function scalar cast.
class	SqlFunctionScalarExtract	The type Sql function scalar extract.
class	SqlFunctionScalarJsonValue	This class represents the ScalarFunction.JSON_VALUE scalar function.
class	SqlGroupBy	Represents a GROUP BY statement.
class	SqlJoin	JOIN node.
class	SqlLimit	LIMIT sql node.
class	SqlLiteralBool	Bool literal.
class	SqlLiteralDate	Date literal.
class	SqlLiteralDouble	Double literal.
class	SqlLiteralExactnumeric	Literal for decimal types.
class	SqlLiteralInterval	Interval literal.
class	SqlLiteralNull	NULL literal.
class	SqlLiteralString	String literal.
class	SqlLiteralTimestamp	Timestamp literal.
class	SqlLiteralTimestampUtc	Timestamp UTC literal.
class	SqlOrderBy	ORDER BY clause.
class	SqlPredicate	This class represents SQL predicates.
class	SqlPredicateAnd	AND predicate.
class	SqlPredicateBetween	Between predicate.
class	SqlPredicateEqual	Equal predicate.
class	SqlPredicateInConstList	The type Sql predicate in const list.
class	SqlPredicateIsJson	This class represents the Predicate.IS_JSON predicate.
class	SqlPredicateIsNotJson	This class represents the Predicate.IS_NOT_JSON predicate.
class	SqlPredicateIsNotNull	The type Sql predicate is not null.
class	SqlPredicateIsNull	The type Sql predicate is null.
class	SqlPredicateLess	Less predicate.
class	SqlPredicateLessEqual	The type Sql predicate less equal.
class	SqlPredicateLike	LIKE predicate
class	SqlPredicateLikeRegexp	REGEXP_LIKE predicate.
class	SqlPredicateNot	Not predicate.
class	SqlPredicateNotEqual	Not equal predicate.
class	SqlPredicateOr	OR predicate.
class	SqlSelectList	This class represents a select list.
class	SqlStatement	SQL Statement.
class	SqlStatementSelect	We could consider to apply builder pattern here (if time)
class	SqlTable	This class represents a SQL table.

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

Modifier and Type	Field	Description
protected SqlNode	AbstractSqlPredicateJson.expression	The 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()	Gets argument.
SqlNode	SqlFunctionScalarExtract.getArgument()	Gets argument.
SqlNode	SqlFunctionScalarCase.getBasis()	Gets basis.
SqlNode	SqlPredicateBetween.getBetweenLeft()	Gets between left.
SqlNode	SqlPredicateBetween.getBetweenRight()	Gets between right.
SqlNode	SqlJoin.getCondition()	Gets condition.
SqlNode	SqlPredicateLike.getEscapeChar()	Gets escape char.
SqlNode	AbstractSqlPredicateJson.getExpression()	Gets expression.
SqlNode	SqlPredicateBetween.getExpression()	Gets expression.
SqlNode	SqlPredicateInConstList.getExpression()	Gets expression.
SqlNode	SqlPredicateIsNotNull.getExpression()	Gets expression.
SqlNode	SqlPredicateIsNull.getExpression()	Gets expression.
SqlNode	SqlPredicateNot.getExpression()	Gets expression.
SqlNode	SqlStatementSelect.getFromClause()	Gets from clause.
SqlNode	SqlStatementSelect.getHaving()	Gets having.
SqlNode	AbstractSqlBinaryEquality.getLeft()	Gets left.
SqlNode	SqlJoin.getLeft()	Gets left table.
SqlNode	SqlPredicateLike.getLeft()	Gets left.
SqlNode	SqlPredicateLikeRegexp.getLeft()	Gets left.
SqlNode	SqlNode.getParent()	Gets parent.
SqlNode	SqlPredicateLike.getPattern()	Gets pattern.
SqlNode	SqlPredicateLikeRegexp.getPattern()	Gets pattern.
SqlNode	AbstractSqlBinaryEquality.getRight()	Gets right.
SqlNode	SqlJoin.getRight()	Gets right table.
SqlNode	SqlStatementSelect.getWhereClause()	Gets where clause.

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

Modifier and Type	Method	Description
List<SqlNode>	SqlPredicateAnd.getAndedPredicates()	Gets anded predicates.
List<SqlNode>	SqlFunctionAggregate.getArguments()	Gets arguments.
List<SqlNode>	SqlFunctionScalar.getArguments()	Gets arguments.
List<SqlNode>	SqlFunctionScalarCase.getArguments()	Gets arguments.
List<SqlNode>	SqlFunctionScalarJsonValue.getArguments()	Gets arguments.
Optional<SqlNode>	SqlFunctionScalarJsonValue.Behavior.getExpression()	Gets expression.
List<SqlNode>	SqlExpressionList.getExpressions()	Gets expressions.
List<SqlNode>	SqlOrderBy.getExpressions()	Gets expressions.
List<SqlNode>	SqlPredicateInConstList.getInArguments()	Gets in arguments.
List<SqlNode>	SqlPredicateOr.getOrPredicates()	Gets or predicates.
List<SqlNode>	SqlFunctionScalarCase.getResults()	Gets results.

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)	Sets 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)	Instantiates a new Abstract sql binary equality.
AbstractSqlPredicateJson(Predicate predicate, SqlNode expression, AbstractSqlPredicateJson.TypeConstraints typeConstraint, AbstractSqlPredicateJson.KeyUniquenessConstraint keyUniquenessConstraint)	Instantiates a new Abstract sql predicate json.
SqlFunctionScalarCase(List<SqlNode> arguments, List<SqlNode> results, SqlNode basis)	Instantiates a new SQL function scalar case.
SqlFunctionScalarCast(DataType dataType, SqlNode argument)	Create a new instance of SqlFunctionScalarCast.
SqlFunctionScalarExtract(SqlFunctionScalarExtract.ExtractParameter extractParameter, SqlNode argument)	Instantiates a new Sql function scalar extract.
SqlJoin(SqlNode left, SqlNode right, SqlNode condition, JoinType joinType)	Instantiates a new Sql join.
SqlPredicateBetween(SqlNode expression, SqlNode betweenLeft, SqlNode betweenRight)	Instantiates a new Sql predicate between.
SqlPredicateEqual(SqlNode left, SqlNode right)	Instantiates a new Sql predicate equal.
SqlPredicateInConstList(SqlNode expression, List<SqlNode> inArguments)	Create a new instance of SqlPredicateInConstList.
SqlPredicateIsJson(SqlNode expression, AbstractSqlPredicateJson.TypeConstraints typeConstraint, AbstractSqlPredicateJson.KeyUniquenessConstraint keyUniquenessConstraint)	Instantiates a new Sql predicate is json.
SqlPredicateIsNotJson(SqlNode expression, AbstractSqlPredicateJson.TypeConstraints typeConstraint, AbstractSqlPredicateJson.KeyUniquenessConstraint keyUniquenessConstraint)	Instantiates a new Sql predicate is not json.
SqlPredicateIsNotNull(SqlNode expression)	Instantiates a new Sql predicate is not null.
SqlPredicateIsNull(SqlNode expression)	Instantiates a new Sql predicate is null.
SqlPredicateLess(SqlNode left, SqlNode right)	Instantiates a new Sql predicate less.
SqlPredicateLessEqual(SqlNode left, SqlNode right)	Instantiates a new Sql predicate less equal.
SqlPredicateLike(SqlNode left, SqlNode pattern)	Instantiates a new Sql predicate like.
SqlPredicateLike(SqlNode left, SqlNode pattern, SqlNode escapeChar)	Instantiates a new Sql predicate like.
SqlPredicateLikeRegexp(SqlNode left, SqlNode pattern)	Instantiates a new Sql predicate like regexp.
SqlPredicateNot(SqlNode expression)	Instantiates a new Sql predicate not.
SqlPredicateNotEqual(SqlNode left, SqlNode right)	Instantiates a new Sql predicate not equal.

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

Constructor	Description
Behavior(SqlFunctionScalarJsonValue.BehaviorType behaviorType, Optional<SqlNode> expression)	Instantiates a new Behavior.
SqlExpressionList(List<SqlNode> expressions)	Instantiates a new Sql expression list.
SqlFunctionAggregate(AggregateFunction function, List<SqlNode> arguments, boolean distinct)	Instantiates a new Sql function aggregate.
SqlFunctionScalar(ScalarFunction function, List<SqlNode> arguments)	Instantiates a new Sql function scalar.
SqlFunctionScalarCase(List<SqlNode> arguments, List<SqlNode> results, SqlNode basis)	Instantiates a new SQL function scalar case.
SqlFunctionScalarJsonValue(ScalarFunction scalarFunction, List<SqlNode> arguments, DataType returningDataType, SqlFunctionScalarJsonValue.Behavior emptyBehavior, SqlFunctionScalarJsonValue.Behavior errorBehavior)	Instantiates a new Sql function scalar json value.
SqlGroupBy(List<SqlNode> groupByList)	Create a new instance of SqlGroupBy.
SqlGroupBy(List<SqlNode> groupByList, boolean singleGroupAggregation)	Create a new instance of SqlGroupBy.
SqlOrderBy(List<SqlNode> expressions, List<Boolean> isAsc, List<Boolean> nullsFirst)	Instantiates a new Sql order by.
SqlPredicateAnd(List<SqlNode> andedPredicates)	Instantiates a new Sql predicate and.
SqlPredicateInConstList(SqlNode expression, List<SqlNode> inArguments)	Create a new instance of SqlPredicateInConstList.
SqlPredicateOr(List<SqlNode> orPredicates)	Instantiates a new Sql predicate or.