Method writeSubquery

runtime/metricsview/astexpr.go:83–128

(sub *Subquery)

}

func (b *sqlExprBuilder) writeSubquery(sub *Subquery) error {
	// We construct a Query that combines the parent Query's contextual info with that of the Subquery.
	outer := b.ast.Query
	inner := &Query{
		MetricsView:         outer.MetricsView,
		Dimensions:          []Dimension{sub.Dimension},
		Measures:            sub.Measures,
		PivotOn:             nil,
		Spine:               nil,
		Sort:                nil,
		TimeRange:           outer.TimeRange,
		ComparisonTimeRange: outer.ComparisonTimeRange,
		Where:               sub.Where,
		Having:              sub.Having,
		Limit:               nil,
		Offset:              nil,
		TimeZone:            outer.TimeZone,
		UseDisplayNames:     false,
		Rows:                false,
		QueryLimits:         outer.QueryLimits,
		UnusedFields:        nil,
	} //exhaustruct:enforce

	// Generate SQL for the subquery
	innerSecurity := b.ast.Security
	if !b.visible {
		innerSecurity = skipMetricsViewSecurity{}
	}
	innerAST, err := NewAST(b.ast.MetricsView, innerSecurity, inner, b.ast.Dialect)
	if err != nil {
		return fmt.Errorf("failed to create AST for subquery: %w", err)
	}
	sql, args, err := innerAST.SQL()
	if err != nil {
		return fmt.Errorf("failed to generate SQL for subquery: %w", err)
	}

	// Output: (SELECT <dimension> FROM (<subquery>))
	b.writeString("(SELECT ")
	b.writeString(b.ast.Dialect.EscapeIdentifier(sub.Dimension.Name))
	b.writeString(" FROM (")
	b.writeString(sql)
	b.writeString("))")
	b.args = append(b.args, args...)
	return nil
}

func (b *sqlExprBuilder) writeCondition(cond *Condition) error {
	switch cond.Operator {