Method SQL

pkg/sql/ast/sql.go:526–627

============================================================ Statements ============================================================ SQL returns the full SQL string for this SELECT statement, including all clauses: WITH, DISTINCT ON/DISTINCT, SELECT list, FROM, JOIN, WHERE, GROUP BY, HAVING, WINDOW,

()

// GROUP BY, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, FETCH, and FOR.
// This enables round-trip serialization of parsed queries.
func (s *SelectStatement) SQL() string {
	if s == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)

	if s.With != nil {
		sb.WriteString(s.With.SQL())
		sb.WriteString(" ")
	}

	sb.WriteString("SELECT ")

	if len(s.DistinctOnColumns) > 0 {
		sb.WriteString("DISTINCT ON (")
		sb.WriteString(exprListSQL(s.DistinctOnColumns))
		sb.WriteString(") ")
	} else if s.Distinct {
		sb.WriteString("DISTINCT ")
	}

	sb.WriteString(exprListSQL(s.Columns))

	if len(s.From) > 0 {
		sb.WriteString(" FROM ")
		froms := make([]string, len(s.From))
		for i := range s.From {
			froms[i] = tableRefSQL(&s.From[i])
		}
		sb.WriteString(strings.Join(froms, ", "))
	}

	for _, j := range s.Joins {
		j := j // G601: Create local copy to avoid memory aliasing
		sb.WriteString(" ")
		sb.WriteString(joinSQL(&j))
	}

	if s.PrewhereClause != nil {
		sb.WriteString(" PREWHERE ")
		sb.WriteString(exprSQL(s.PrewhereClause))
	}

	if s.Where != nil {
		sb.WriteString(" WHERE ")
		sb.WriteString(exprSQL(s.Where))
	}

	if len(s.GroupBy) > 0 {
		sb.WriteString(" GROUP BY ")
		sb.WriteString(exprListSQL(s.GroupBy))
	}

	if s.Having != nil {
		sb.WriteString(" HAVING ")
		sb.WriteString(exprSQL(s.Having))
	}