In order to resolve the 'Syntax error: Exception parsing query near 't0'' error, I would perform the following:
* Open "bv_list_roles" base view and navigate to "**Options>Search Methods > wrapper source configuration**" section.
* Set the property ["Delegate SQL Sentence as Sub Query"](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/advanced_configuration_of_views/view_configuration_properties#view-configuration-properties) as "**No**".
Once this is done, I could execute the view successfully. For more information, you could refer to the [Using the Create Base View From Query Option](https://community.denodo.com/kb/view/document/Using%20the%20Create%20Base%20View%20From%20Query%20Option?category=Data+Sources) Knowledge Base Article.
Hope this helps!