Custom datasource with symql

data.dscustom.php

<!--
Usecase example: 
-->

public function allowEditorToParse()
    {
        return false;
    }

public function execute(array &$param_pool = null)
    {
  $result = new XMLElement($this->dsParamROOTELEMENT);
			
    // fetch categories
		$query =new SymQLQuery('Categories');
		$query
		->select('system:id,title)
		->from('categories')
		->where('active', 'Yes')
		->orderby('title', 'asc');
		$resultsymqlquery = SymQL::run($query,SymQL::RETURN_ARRAY);

		//var_dump($resultsymqlquery['entries'][0]['entry']);die;

		foreach ($resultsymqlquery['entries'] as $entry => $value) {
		
		$entry = new XMLElement('category');
		$entry->setAttribute("id",$value['entry']['_id']);
		$entry->setAttribute("title",$value['entry']['title']['value']);

		$result->appendChild($entry);
}

return $result;

}
}