Package io.github.torand.fastersql.subquery

Class ExpressionSubquery

java.lang.Object
io.github.torand.fastersql.subquery.ExpressionSubquery
All Implemented Interfaces:
Expression, Projection, Sql, Subquery
public class ExpressionSubquery extends Object implements Subquery, Expression
Implements a subquery to be used as projection or as operand for a predicate.

  • Constructor Details

    • ExpressionSubquery

      public ExpressionSubquery(SelectStatement query)
      Creates an expression subquery.
      Parameters:
      query - the query.

  • Method Details

    • sql

      public String sql(Context context)
      Description copied from interface: Sql
      Formats object as an SQL fragment.
      Specified by:
      sql in interface Sql
      Parameters:
      context - the context (incl. dialect).
      Returns:
      the formatted SQL fragment.

    • params

      public Stream<Object> params(Context context)
      Description copied from interface: Sql
      Gets the statement parameters introduced by this fragment.
      Specified by:
      params in interface Sql
      Parameters:
      context - the context (incl. dialect).
      Returns:
      the statement parameters.

    • columnRefs

      public Stream<Column> columnRefs()
      Description copied from interface: Sql
      Gets the columns referenced by this fragment. For validation purposes.
      Specified by:
      columnRefs in interface Sql
      Returns:
      the columns referenced by this fragment.

    • aliasRefs

      public Stream<ColumnAlias> aliasRefs()
      Description copied from interface: Sql
      Gets the column aliases referenced by this fragment. For validation purposes.
      Specified by:
      aliasRefs in interface Sql
      Returns:
      the column aliases referenced by this fragment.

    • query

      public SelectStatement query()
      Description copied from interface: Subquery
      Gets the SELECT statement of this subquery.
      Specified by:
      query in interface Subquery
      Returns:
      the SELECT statement of this subquery.

    • as

      public Projection as(String alias)
      Description copied from interface: Projection
      Assigns a column alias (label) for this projection.
      Specified by:
      as in interface Projection
      Parameters:
      alias - the column alias or label.
      Returns:
      the projection with specified alias assigned.

    • alias

      public Optional<ColumnAlias> alias()
      Description copied from interface: Projection
      Gets the column alias (label) assigned for this projection.
      Specified by:
      alias in interface Projection
      Returns:
      the column alias (label) assigned for this projection.