See: Description
| Interface | Description |
|---|---|
| AliasFragment |
SQLFragment that consists of an expression and an alias.
|
| DBObjectUsage |
Interface implemented by fragments that use a DBObjectID to refer to another
DBObject.
|
| DeclarativeSQLQuery | Deprecated
- incorporated in to SQLQuery
|
| FromObjectUsage |
Interface implemented by any object that directly depends on a FromObject
(e.g.
|
| JoinCondition | |
| SqlAliasExpander |
A utility to resolve table alaiases in SQL so that a list of
Usages can be returned, each with a List<String> and
int offsets. |
| SqlAliasExpander.Usage | |
| SQLCallable |
Defines a callable method from within SQL (or PL/SQL)
|
| SQLCallableArgument |
Defines an argument of a callable method from within SQL (or PL/SQL)
|
| SQLFragment |
Interface for objects that encapsulate a fragment of SQL.
|
| SQLFragmentFactory | |
| SQLFragmentWithDatatype |
A SQLFragment that has a datatype, for example, a ColumnUsage or an Operation.
|
| SQLQueryBuilder |
Interface that defines a builder class for sql queries.
|
| SQLQueryBuilder.SQLQueryObjectSet |
A result set interface for the query builder class
|
| SQLQueryOwner |
Interfaced to be implemented by any object that can own a SQLQuery.
|
| Class | Description |
|---|---|
| AbstractAliasFragment |
SQLFragment that consists of an expression and an alias.
|
| AbstractDBObjectUsage |
Abstract implementation for a SQLFragment that uses another DBObject (e.g
a Column) through a FromObject in the query.
|
| AbstractFromObjectUsage |
Abstract SQLFragment implementation of FromObjectUsage.
|
| AbstractProviderUsageSQLFragment |
Abstract SQLFragment implementation that is also a ProviderUsage.
|
| AbstractSchemaObjectUsage |
Abstract class for usages that reference a SchemaObject (e.g.
|
| AbstractSQLFragment |
Abstract superclass for SQLFragment implementations.
|
| AbstractSQLQuery | Deprecated
- folded in to SQLQuery
|
| AbstractSQLQueryBuilder |
Abstract implementation of SQLQuery that performs functions generic to any
builder.
|
| AbstractSQLQueryBuilder.QueryColumnInfo | |
| ArithmeticOperation |
Concrete subclass of Operation for arithmetic operations - ADD, SUBTRACT,
MULTIPLY and DIVIDE.
|
| AsteriskUsage | Deprecated
- use ColumnKeywordUsage
|
| BuiltInFunction |
Class used for defining built in functions for the database.
|
| BuiltInFunctionArgument |
An argument to a SQL Built-in Function
|
| CaseStatement |
Class to represent a case statement in a sql query.
CASE [expression] WHEN condition THEN thenExpression WHEN condition THEN thenExpression ... |
| CaseStatement.WhenThen | |
| ColumnKeywordUsage |
A FromObjectUsage that has a keyword for the Column name, rather than an
actual column.
|
| ColumnUsage |
SQL fragment that is a use of a Column.
|
| Comparison |
Subclass of Operation for comparisons.
|
| ConnectByRoot |
SQLFragment representing the unary operator CONNECT_BY_ROOT.
|
| DataMiningFunction |
Subclass of Operation for data mining functions.
|
| DataMiningFunction.DataMiningArguments | Deprecated
no longer required, use get/setDmSpecificArgs directly.
|
| DataMiningFunction.DataMiningCostValues |
An array of values
|
| ExpressionList |
List of expressions.
|
| FKUsage |
SQLFragment for the usage of a FKConstraint.
|
| FromObject |
Object that represents a clause in the FROM statement of a SQL query.
|
| Function |
Subclass of Operation for functions.
|
| FunctionDefinition | Deprecated
- Use
BuiltInFunction |
| FunctionUsage | |
| GroupByExpression |
Expression for a part of a group by that isn't a simple column (e.g.
|
| GroupByObject |
SQLFragment for the GROUP BY ...
|
| HierarchicalQueryObject |
SQLFragment for the Hierarchical Query clause in a SQLQuery.
|
| IndexObject |
Object to wrap a column expression (usually just a name, but could be any
sql expression) with an optional order type (ASC/DESC).
|
| JoinObject |
Object that represent the JOIN clause of a SELECT statement (part of the
FROM clause).
|
| ModelObject |
SQLFragment for the MODEL clause in a SQLQuery.
|
| ModelObject.CellAssignment | |
| ModelObject.CellReferenceOptions | |
| ModelObject.ModelColumnClauses | |
| ModelObject.ModelRulesCellAssignmentExpr | |
| ModelObject.ModelRulesClause | |
| ModelObject.MultiColumnForLoop | |
| ModelObject.ReferenceModel | |
| ModelObject.SingleColumnForLoop | |
| NonDeclarativeSQLQuery | Deprecated
folded into SQLQuery
|
| OnJoinCondition |
Object to represent the ON condition of a JOIN clause.
|
| Operation |
Abstract class for operations.
|
| OrderByObject |
Object to wrap each part of the ORDER BY clause of a SQLQuery.
|
| ParserUtils | |
| PlSqlUsage |
Fragment that represents a usage of a piece of PlSql.
|
| RelationUsage |
SQL fragment that is a use of a Relation.
|
| SelectObject |
Object that represents a clause in the SELECT statement of a SQL query.
|
| SelectObjectUsage |
Class that represents the usage of a SelectObject.
|
| SequenceUsage |
SQL fragment that is a use of a Sequence.
|
| SetOperation |
SQLFragment for dealing with operations to do with sets and ranges like
IN and BETWEEN.
|
| SetOperator |
SQLFragment for dealing with queries that are linked using one of the SET
operators INTERSECT, UNION, MINUS and UNION ALL.
|
| SimpleSQLFragment |
SQLFragment that we can't break down any more.
|
| SQLFragmentExpressionBuilder | |
| SQLFragmentID | Deprecated
SQLFragments now use IdentifierBaseID insteasd
|
| SQLFragmentUtils |
Utilities for dealing with SQLFragments.
|
| SQLParseException.ParseError | |
| SQLQuery |
Object that represents a SQL query.
|
| SQLQueryBuilderFactory |
Factory class for creating a SQLQueryBuilder.
|
| SynonymUsage |
SQLFragment for using a Synonym or Alias in a SQL query.
|
| UsingJoinCondition |
Object to represent the condition part of a JOIN that has a USING clause.
|
| WhereObject |
Object that represents a clause in the WHERE statement of a SQL query.
|
| WindowFunction |
Subclass of Function for windowing functions (using the OVER syntax).
|
| WindowFunction.WindowFunctionBound | |
| WithClauseUsage |
FromObjectUsage which represents the usage of a WITH clause in the FROM
clause.
|
| XMLFunctionUsage |
Use spaces as argument seperators.
|
| Enum | Description |
|---|---|
| ArithmeticOperation.ArithmeticOperator |
Valid arithmetic operators.
|
| Comparison.Comparator |
Valid comparators for SQL.
|
| GroupByExpression.GroupingType | |
| IndexObject.OrderType | |
| ParserUtils.ExpressionType | |
| SequenceUsage.Mode |
Representation of how the sequence is used in the query
|
| SetOperation.Operator |
Valid operators for a SetOperation.
|
| SetOperator.Operator |
Valid operators for a SetOperator.
|
| SQLFragmentExpressionBuilder.ExpressionType | |
| WhereObject.WhereOperator |
Valid operators for a WhereObject.
|
| WindowFunction.BoundType | |
| WindowFunction.ClauseType | |
| WindowFunction.FromPolicy | |
| WindowFunction.NullPolicy |
| Exception | Description |
|---|---|
| AliasInUseException |
SQLQueryException thrown when an attempt is made to add an object whose
alias is already in use.
|
| AmbiguousColumnException |
Exception thrown when the name of a column in a query is ambiguous - i.e.
|
| IDException |
Exception thrown when a DBObject is missing an ID.
|
| InvalidAliasException |
Exception thrown when a select or from object has an invalid alias (e.g.
|
| InvalidSQLException |
SQLQueryException for representing errors in the sql (e.g.
|
| SQLParseException |
Subclass of SQLQueryException used for parse errors in the sql.
|
| SQLQueryCancelledException |
SQLQueryException thrown when the build of a SQLQuery is interrupted or
cancelled by the user.
|
| SQLQueryClauseException |
Exception thrown by a SQLQueryBuilder when there is an error with a clause
in the query, but that this error doesn't stop the query being declarative.
|
| SQLQueryException |
Superclass for all Exceptions thrown by the SQLQuery API.
|
SQLQueryBuilder is used to parse a select statement into a
SQLQuery object. All parts of the query are represented as child
SQLFragment objects.