Method SQL

runtime/metricsview/astsql.go:10–43

SQL builds a SQL query from the AST. It returns the query and query arguments to be passed to the database driver.

()

// SQL builds a SQL query from the AST.
// It returns the query and query arguments to be passed to the database driver.
func (a *AST) SQL() (string, []any, error) {
	b := &sqlBuilder{
		ast: a,
		out: &strings.Builder{},
	}

	if len(a.CTEs) > 0 {
		b.out.WriteString("WITH ")
		for i, cte := range a.CTEs {
			if i > 0 {
				b.out.WriteString(", ")
			}
			b.out.WriteString(cte.Alias)
			b.out.WriteString(" AS (")
			err := b.writeSelect(cte)
			if err != nil {
				return "", nil, err
			}
			b.out.WriteString(") ")
		}
	}

	var err error
	if a.Query.UseDisplayNames {
		err = b.writeSelectWithDisplayNames(a.Root)
	} else {
		err = b.writeSelect(a.Root)
	}
	if err != nil {
		return "", nil, err
	}

	return b.out.String(), b.args, nil
}

type sqlBuilder struct {
	ast  *AST