Create MySQL view for multi-table Silverstripe DataObject

CreateViewForClass.php

<?php
/**
 * Creates a Flat table view for a given class
 * @author Mark Guinn <mark@adaircreative.com>
 * @date 06.13.2014
 */
class CreateViewForClass extends BuildTask
{
	protected $title = 'DEV: Flat View for Class';
	protected $description = 'Use class=XXXX to create a flat view of all the tables that make up a given class';

	public function run($request) {
		if (!Director::isDev()) die("Never run this on a live site.\n");
		if (!$request->getVar('class')) die("Give me a class (e.g. framework/sake dev/tasks/CreateViewForClass class=Page)\n");
		$class = $request->getVar('class');
		$list = DataObject::get($class);
		$sql = $list->dataQuery()->sql();
		$sql = "create or replace\ndefiner=current_user\nsql security invoker\nview Flat_$class as\n" . $sql;
		echo "\nSQL FOR VIEW:\n$sql\n\n";
		DB::query($sql);
	}
}