What kind of SQL uses Analytics?

What kind of SQL uses Analytics?

Hello,

I find confusing how the SQL queries work in Zoho Analytics. Coming from other platforms, these queries have sometimes different results with the same query. Does Zoho Analytics use personalize SQL? 
Also, some queries fail without any kind of information, just a message like "Your SQL Query is not supported in Zoho Analytics." Could be possible to add more information to that error mesage to be able to solve at the moment?