schema.sql file
CREATE VIEW ListDeployments
SQL SECURITY INVOKER AS
SELECT
    user_id,
    ARRAY_AGG(STRUCT<first_name STRING, last_name STRING>(first_name, last_name)) AS user_details
FROM Users;

func main() {
	filename := "schema.sql"
	bs, err := os.ReadFile(filename)
	if err != nil {
		log.Println("error reading schema file: %w", err)
	}

	ddl, err := spansql.ParseDDL(filename, string(bs))
	if err != nil {
		log.Printf("error parsing schema file: %v\n", err)
	}

	if ddl != nil {
		log.Println(ddl.List)
	}
}