Function buildViewStmt

backend/plugin/parser/pg/query_span_loader_builders.go:72–88

buildViewStmt translates ViewMetadata into a ViewStmt. The view body is parsed via ParsePg; the result must be a *ast.SelectStmt (not a RawStmt wrapper) because omni's DefineView type-asserts directly. If the body is empty or unparseable, returns an error; the loader will pseudo the view using depe

(schema string, view *storepb.ViewMetadata)

// If the body is empty or unparseable, returns an error; the loader will
// pseudo the view using dependency_columns metadata.
func buildViewStmt(schema string, view *storepb.ViewMetadata) (*ast.ViewStmt, error) {
	if view.Definition == "" {
		return nil, errors.New("empty view definition")
	}
	sel, err := parseSelectBody(view.Definition)
	if err != nil {
		return nil, errors.Wrapf(err, "view %q body", view.Name)
	}
	return &ast.ViewStmt{
		View: &ast.RangeVar{
			Schemaname:     schema,
			Relname:        view.Name,
			Relpersistence: 'p',
		},
		Query: sel,
	}, nil
}

// buildCreateTableAsStmt translates MaterializedViewMetadata into a
// CreateTableAsStmt with Objtype OBJECT_MATVIEW. Same SelectStmt contract