Method ToSQL

backend/common/qb/qb.go:156–203

ToSQL generates PostgreSQL-compatible SQL with $1, $2, ... placeholders. Returns the SQL string, parameters slice, and any error. Placeholder rules: - Single ? → parameter placeholder (converted to $1, $2, etc.) - Double ?? → literal ? in SQL (for PostgreSQL JSONB operators like ?, ?|, ?&)

()

// - Single ? → parameter placeholder (converted to $1, $2, etc.)
// - Double ?? → literal ? in SQL (for PostgreSQL JSONB operators like ?, ?|, ?&)
func (q *Query) ToSQL() (string, []any, error) {
	if q == nil {
		return "", nil, errors.New("cannot generate SQL from nil Query")
	}

	// First pass: concatenate all parts and collect params
	var sqlBuilder strings.Builder
	params := make([]any, 0)

	for _, part := range q.parts {
		// Check for errors in this part
		if len(part.Errs) > 0 {
			// Return the first error encountered
			return "", nil, part.Errs[0]
		}
		sqlBuilder.WriteString(part.Text)
		params = append(params, part.Params...)
	}

	sql := sqlBuilder.String()

	// Second pass: replace ? placeholders with $1, $2, etc., handling ?? escape sequence
	// Use a unique delimiter that won't appear in SQL
	const delimiter = "\x00"
	// Replace ?? with delimiter temporarily
	sql = strings.ReplaceAll(sql, "??", delimiter)
	// Split on remaining ? (these are all placeholders)
	parts := strings.Split(sql, "?")

	// Verify parameter count matches
	if len(parts)-1 != len(params) {
		return "", nil, errors.New("mismatched parameters: ? placeholders count does not match params count")
	}

	// Build final SQL with $1, $2, etc.
	var builder strings.Builder
	for i := range params {
		builder.WriteString(parts[i])
		builder.WriteString("$")
		builder.WriteString(strconv.Itoa(i + 1))
	}
	builder.WriteString(parts[len(parts)-1])

	// Replace delimiter back to ?
	finalSQL := strings.ReplaceAll(builder.String(), delimiter, "?")

	return finalSQL, params, nil
}