public function createView($viewName, array $definition, $schemaName = null)
{
if (!isset($definition['sql']) || empty($definition['sql'])) {
throw new Exception("The index 'sql' is required in the definition array");
}
return 'CREATE VIEW ' . Text::upper($this->prepareTable($viewName, $schemaName)) . ' AS ' . $definition['sql'];
}