SubQuery: {
    columns: Column[];
    expressions?: Expression[] | null;
    filter_conditions?: FilterCondition[] | null;
    group_by?: GroupBy | null;
    joins?: JoinClause[] | null;
    limit?: number | null;
    offset?: number | null;
    order_by?: OrderBy | null;
    table: TableName;
}

Represents a complete ClickHouse query with parameters

Type declaration

  • columns: Column[]

    Simple columns to select

  • Optionalexpressions?: Expression[] | null

    Complex expressions to select

  • Optionalfilter_conditions?: FilterCondition[] | null

    WHERE clause conditions

  • Optionalgroup_by?: GroupBy | null
  • Optionaljoins?: JoinClause[] | null

    Tables to join with

  • Optionallimit?: number | null

    LIMIT clause

  • Optionaloffset?: number | null

    OFFSET clause

  • Optionalorder_by?: OrderBy | null
  • table: TableName